VIEW: APPS.PMIFV_BATCH_LOTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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