View: GMI_LOTS_LIST_V

Product:	GMI - Process Manufacturing Inventory
Description:	This view is the basis for the views GMI_LOTS_DEST_LIST_V and GMI_LOTS_SOURCE_LIST_V.
Implementation/DBA Data:	APPS.GMI_LOTS_LIST_V

View Text

SELECT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, I.INV_CLASS
, I.INV_TYPE
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, TRUNC(L.LOT_CREATED) CREATION_DATE
, L.QC_GRADE
, T.ORGN_CODE
, V.VENDOR_NO
FROM IC_TRAN_PND T
, IC_ITEM_MST I
, IC_LOTS_MST L
, PO_VEND_MST V
, PO_RECV_DTL RD
WHERE T.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 L.LOT_ID <> 0
AND T.DOC_TYPE = 'RECV'
AND RD.RECV_ID(+) = T.DOC_ID
AND RD.LINE_ID(+) = T.LINE_ID
AND V.VENDOR_ID(+) = RD.SHIPVEND_ID UNION ALL SELECT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, I.INV_CLASS
, I.INV_TYPE
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, TRUNC(L.LOT_CREATED) CREATION_DATE
, L.QC_GRADE
, T.ORGN_CODE
, V.VENDOR_NO
FROM IC_TRAN_CMP T
, IC_ITEM_MST I
, IC_LOTS_MST L
, PO_VEND_MST V
, PO_RECV_DTL RD
WHERE T.ITEM_ID = I.ITEM_ID
AND L.ITEM_ID = T.ITEM_ID
AND L.LOT_ID = T.LOT_ID
AND L.LOT_ID <> 0
AND T.DOC_TYPE = 'RECV'
AND RD.RECV_ID(+) = T.DOC_ID
AND RD.LINE_ID(+) = T.LINE_ID
AND V.VENDOR_ID(+) = RD.SHIPVEND_ID UNION ALL SELECT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, I.INV_CLASS
, I.INV_TYPE
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, TRUNC(L.LOT_CREATED) CREATION_DATE
, L.QC_GRADE
, T.ORGN_CODE
, V.VENDOR_NO
FROM IC_TRAN_PND T
, IC_ITEM_MST I
, IC_LOTS_MST L
, PO_VEND_MST V
WHERE T.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 L.LOT_ID <> 0
AND T.DOC_TYPE <> 'RECV'
AND V.VENDOR_ID(+) = L.SHIPVEND_ID UNION ALL SELECT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, I.INV_CLASS
, I.INV_TYPE
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, TRUNC(L.LOT_CREATED) CREATION_DATE
, L.QC_GRADE
, T.ORGN_CODE
, V.VENDOR_NO
FROM IC_TRAN_CMP T
, IC_ITEM_MST I
, IC_LOTS_MST L
, PO_VEND_MST V
WHERE T.ITEM_ID = I.ITEM_ID
AND L.ITEM_ID = T.ITEM_ID
AND L.LOT_ID = T.LOT_ID
AND L.LOT_ID <> 0
AND T.DOC_TYPE <> 'RECV'
AND V.VENDOR_ID(+) = L.SHIPVEND_ID

Columns