VIEW: APPS.PMIFV_LOT_EVENT_V

Source

View Text - Preformatted

SELECT t.item_id product_item_id, t.lot_id product_lot_id, t.trans_date, t.orgn_code, t.doc_type, t.doc_id, t.line_id, item.item_no, item.item_desc1, item.item_um, item.item_um2, lot.lot_no, lot.sublot_no, SUM(t.trans_qty) sum_trans_qty1, SUM(t.trans_qty2) sum_trans_qty2, t.whse_code, t.location, t.qc_grade, t.lot_status, t.reason_code, t.completed_ind FROM ic_tran_pnd t, ic_item_mst item, ic_lots_mst lot WHERE t.lot_id <> 0 AND item.item_id = t.item_id AND lot.item_id = t.item_id AND lot.lot_id = t.lot_id GROUP BY t.item_id, t.lot_id, t.trans_date, t.orgn_code, t.doc_type, t.doc_id, t.line_id, item.item_no, item.item_desc1, item_um, item_um2, lot.lot_no, lot.sublot_no, t.whse_code, t.location, t.qc_grade, t.lot_status, t.reason_code, t.completed_ind UNION ALL SELECT t.item_id product_item_id, t.lot_id product_lot_id, t.trans_date, t.orgn_code, t.doc_type, t.doc_id, t.line_id, item.item_no, item.item_desc1, item.item_um, item.item_um2, lot.lot_no, lot.sublot_no, SUM(t.trans_qty) sum_trans_qty1, SUM(t.trans_qty2) sum_trans_qty2, t.whse_code, t.location, t.qc_grade, t.lot_status, t.reason_code, 1 FROM ic_tran_cmp t, ic_item_mst item, ic_lots_mst lot WHERE t.lot_id <> 0 AND item.item_id = t.item_id AND lot.item_id = t.item_id AND lot.lot_id = t.lot_id GROUP BY t.item_id, t.lot_id, t.trans_date, t.orgn_code, t.doc_type, t.doc_id, t.line_id, item.item_no, item.item_desc1, item_um, item_um2, lot.lot_no, lot.sublot_no, t.whse_code, t.location, t.qc_grade, t.lot_status, t.reason_code with READ ONLY

View Text - HTML Formatted

SELECT T.ITEM_ID PRODUCT_ITEM_ID
, T.LOT_ID PRODUCT_LOT_ID
, T.TRANS_DATE
, T.ORGN_CODE
, T.DOC_TYPE
, T.DOC_ID
, T.LINE_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, LOT.LOT_NO
, LOT.SUBLOT_NO
, SUM(T.TRANS_QTY) SUM_TRANS_QTY1
, SUM(T.TRANS_QTY2) SUM_TRANS_QTY2
, T.WHSE_CODE
, T.LOCATION
, T.QC_GRADE
, T.LOT_STATUS
, T.REASON_CODE
, T.COMPLETED_IND
FROM IC_TRAN_PND T
, IC_ITEM_MST ITEM
, IC_LOTS_MST LOT
WHERE T.LOT_ID <> 0
AND ITEM.ITEM_ID = T.ITEM_ID
AND LOT.ITEM_ID = T.ITEM_ID
AND LOT.LOT_ID = T.LOT_ID GROUP BY T.ITEM_ID
, T.LOT_ID
, T.TRANS_DATE
, T.ORGN_CODE
, T.DOC_TYPE
, T.DOC_ID
, T.LINE_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM_UM
, ITEM_UM2
, LOT.LOT_NO
, LOT.SUBLOT_NO
, T.WHSE_CODE
, T.LOCATION
, T.QC_GRADE
, T.LOT_STATUS
, T.REASON_CODE
, T.COMPLETED_IND UNION ALL SELECT T.ITEM_ID PRODUCT_ITEM_ID
, T.LOT_ID PRODUCT_LOT_ID
, T.TRANS_DATE
, T.ORGN_CODE
, T.DOC_TYPE
, T.DOC_ID
, T.LINE_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, LOT.LOT_NO
, LOT.SUBLOT_NO
, SUM(T.TRANS_QTY) SUM_TRANS_QTY1
, SUM(T.TRANS_QTY2) SUM_TRANS_QTY2
, T.WHSE_CODE
, T.LOCATION
, T.QC_GRADE
, T.LOT_STATUS
, T.REASON_CODE
, 1
FROM IC_TRAN_CMP T
, IC_ITEM_MST ITEM
, IC_LOTS_MST LOT
WHERE T.LOT_ID <> 0
AND ITEM.ITEM_ID = T.ITEM_ID
AND LOT.ITEM_ID = T.ITEM_ID
AND LOT.LOT_ID = T.LOT_ID GROUP BY T.ITEM_ID
, T.LOT_ID
, T.TRANS_DATE
, T.ORGN_CODE
, T.DOC_TYPE
, T.DOC_ID
, T.LINE_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM_UM
, ITEM_UM2
, LOT.LOT_NO
, LOT.SUBLOT_NO
, T.WHSE_CODE
, T.LOCATION
, T.QC_GRADE
, T.LOT_STATUS
, T.REASON_CODE WITH READ ONLY