Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | Private View |
Implementation/DBA Data: | APPS.IC_SUMM_INV_PENDING_V |
SELECT T.ITEM_ID
, T.WHSE_CODE
, T.QC_GRADE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, DECODE(T.DOC_TYPE
, 'PORD'
, SUM(T.TRANS_QTY))
, DECODE(T.DOC_TYPE
, 'PORD'
, SUM(NVL(T.TRANS_QTY2
, 0)))
, DECODE(T.DOC_TYPE
, 'PROD'
, SUM(T.TRANS_QTY) * DECODE(T.LINE_TYPE
, -1
, 0
, 1)
, 0)
, DECODE(T.DOC_TYPE
, 'PROD'
, SUM(NVL(T.TRANS_QTY2
, 0)) * DECODE(T.LINE_TYPE
, -1
, 0
, 1)
, 0)
, DECODE(T.DOC_TYPE
, 'OMSO'
, SUM(T.TRANS_QTY)
, 'OPSO'
, SUM(T.TRANS_QTY)
, 0)
, DECODE(T.DOC_TYPE
, 'OMSO'
, SUM(NVL(T.TRANS_QTY2
, 0))
, 'OPSO'
, SUM(NVL(T.TRANS_QTY2
, 0))
, 0)
, DECODE(T.DOC_TYPE
, 'PROD'
, SUM(T.TRANS_QTY)* DECODE(T.LINE_TYPE
, -1
, 1
, 0)
, 0)
, DECODE(T.DOC_TYPE
, 'PROD'
, SUM(NVL(T.TRANS_QTY2
, 0))* DECODE(T.LINE_TYPE
, -1
, 1
, 0)
, 0)
, DECODE(T.DOC_TYPE
, 'XFER'
, SUM(T.TRANS_QTY)
, 0)
, DECODE(T.DOC_TYPE
, 'XFER'
, SUM(NVL(T.TRANS_QTY2
, 0))
, 0)
FROM IC_LOTS_MST M
, IC_ITEM_MST I
, IC_TRAN_PND T
WHERE T.COMPLETED_IND = 0
AND T.DELETE_MARK = 0
AND T.TRANS_QTY <> 0
AND M.ITEM_ID = T.ITEM_ID
AND M.LOT_ID = T.LOT_ID
AND I.ITEM_ID = T.ITEM_ID
AND I.NONINV_IND = 0 GROUP BY T.ITEM_ID
, T.WHSE_CODE
, T.QC_GRADE
, T.DOC_TYPE
, T.LINE_TYPE