View: PMIFV_BATCH_LOTS_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Lots produced by a batch
Implementation/DBA Data:	APPS.PMIFV_BATCH_LOTS_V

View Text

SELECT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, T.ORGN_CODE
, O.ORGN_NAME
, B.BATCH_NO
, B.BATCH_ID
, B.BATCH_CLOSE_DATE
, T.TRANS_QTY
, T.TRANS_UM
, T.COMPLETED_IND
, T.LINE_TYPE
FROM IC_TRAN_PND T
, IC_ITEM_MST I
, IC_LOTS_MST L
, SY_ORGN_MST O
, GME_BATCH_HEADER B
, FM_FORM_MST_B FORMULA
WHERE L.ITEM_ID = I.ITEM_ID
AND T.COMPLETED_IND = 1
AND L.ITEM_ID = T.ITEM_ID
AND L.LOT_ID = T.LOT_ID
AND FORMULA.FORMULA_ID = B.FORMULA_ID
AND L.LOT_ID <>0
AND T.DOC_TYPE = 'PROD'
AND O.ORGN_CODE(+)= T.ORGN_CODE
AND B.BATCH_ID = T.DOC_ID
AND LINE_TYPE <> -1
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(O.ORGN_CODE) WITH READ ONLY

Columns