SELECT DISTINCT
  ITL.INVT_TRN_LN_NO,
  IT.INVT_TRN_ID,
  IT.WHSE_ID,
  ITL.INVT_ABBRV_CD_TO,
  ITL.PART_ID,
  ITL.PART_RVSN_ID,
  I.ITEM_DESC,
  ITLSL.LOT_ID,
  SL.MAN_VEND_SERIAL_ID,
  ITLSL.INVT_LOC_ID,
  ITL.PO_ID,

  SL.SHELF_LIFE_EXP_DT
FROM DELTEKCP.DELTEK.INVT_TRN IT
JOIN DELTEKCP.DELTEK.INVT_TRN_LN ITL
  ON IT.WHSE_ID = ITL.WHSE_ID
  AND IT.INVT_TRN_ID = ITL.INVT_TRN_ID
  AND IT.S_INVT_TRN_TYPE = ITL.S_INVT_TRN_TYPE
LEFT OUTER JOIN DELTEKCP.DELTEK.INVT_TRN_LN_SR_LT ITLSL
  ON ITL.WHSE_ID = ITLSL.WHSE_ID
  AND ITL.INVT_TRN_ID = ITLSL.INVT_TRN_ID
  AND ITL.S_INVT_TRN_TYPE = ITLSL.S_INVT_TRN_TYPE
  AND ITL.INVT_TRN_LN_KEY = ITLSL.INVT_TRN_LN_KEY

JOIN DELTEKCP.DELTEK.PART P
  ON ITL.PART_KEY = P.PART_KEY
JOIN DELTEKCP.DELTEK.SERIAL_LOT SL
  ON ITLSL.SERIAL_LOT_KEY = SL.SERIAL_LOT_KEY
JOIN DELTEKCP.DELTEK.ITEM I
  ON P.PART_KEY = I.ITEM_KEY
WHERE IT.INVT_TRN_ID = 'MOR0000329'
AND ITL.TRN_QTY > 0
ORDER BY ITL.INVT_TRN_LN_NO