VIEW: APPS.PMIFV_LOT_RESOURCE_LIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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