View: PMIFV_LOT_RESOURCE_LIST_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This view lists lots that shared a particular set of parameters.
Implementation/DBA Data:	APPS.PMIFV_LOT_RESOURCE_LIST_V

View Text

SELECT DISTINCT I.ITEM_NO
, I.ITEM_DESC1
, I.ITEM_ID
, I.INV_CLASS
, I.INV_TYPE
, T.LOT_ID
, L.LOT_NO
, L.SUBLOT_NO
, L.CREATION_DATE
, L.QC_GRADE
, T.ORGN_CODE
, S.ORGN_NAME
, V.VENDOR_NO
, V.VENDOR_NAME
, V.VENDOR_ID
, O.RESOURCES
FROM IC_TRAN_PND T
, IC_ITEM_MST I
, IC_LOTS_MST L
, PO_VEND_MST V
, SY_ORGN_MST S
, GME_BATCH_STEP_RESOURCES O
WHERE T.ITEM_ID = I.ITEM_ID
AND L.ITEM_ID = T.ITEM_ID
AND L.LOT_ID = T.LOT_ID
AND T.LOT_ID <> 0
AND T.LINE_TYPE IN (1
, 2)
AND S.ORGN_CODE = T.ORGN_CODE
AND V.VENDOR_ID(+) = L.SHIPVEND_ID
AND T.DOC_TYPE = 'PROD'
AND O.BATCH_ID = T.DOC_ID WITH READ ONLY

Columns