Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | This view is used to populate the Lot Events tab of the Lot Genealogy Inquiry. |
Implementation/DBA Data: | APPS.GMI_LOTS_EVENT_V |
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')