VIEW: APPS.GMI_LOTS_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_vw1 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 HAVING SUM(t.trans_qty) <> 0 OR SUM(t.trans_qty2) <> 0 OR DOC_TYPE IN ('GRDI','GRDR','MGRI','STSI','STSR')

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_VW1 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 HAVING SUM(T.TRANS_QTY) <> 0 OR SUM(T.TRANS_QTY2) <> 0 OR DOC_TYPE IN ('GRDI'
, 'GRDR'
, 'MGRI'
, 'STSI'
, 'STSR')