View: IC_ITEM_INV_V

Product:	GMI - Process Manufacturing Inventory
Description:	This is used in the OPM Allocation Engine in order to get the OnHand and Commit quantities for an item.
Implementation/DBA Data:	APPS.IC_ITEM_INV_V

View Text

SELECT L.ITEM_ID
, L.LOT_NO
, L.SUBLOT_NO
, L.LOT_ID
, S.LOT_STATUS
, L.LOT_CREATED
, L.EXPIRE_DATE
, L.QC_GRADE
, B.WHSE_CODE
, B.LOCATION
, B.LOCT_ONHAND
, B.LOCT_ONHAND2
, 0
, 0
FROM IC_LOTS_MST L
, IC_LOCT_INV B
, IC_LOTS_STS S
WHERE L.ITEM_ID = B.ITEM_ID
AND L.INACTIVE_IND=0
AND L.LOT_ID = B.LOT_ID
AND B.LOT_STATUS = S.LOT_STATUS(+)
AND NVL(S.ORDER_PROC_IND
, 1)=1
AND NVL(S.REJECTED_IND
, 0) = 0
AND B.LOCT_ONHAND > 0 UNION ALL SELECT T.ITEM_ID
, L.LOT_NO
, L.SUBLOT_NO
, T.LOT_ID
, T.LOT_STATUS
, L.LOT_CREATED
, L.EXPIRE_DATE
, L.QC_GRADE
, T.WHSE_CODE
, T.LOCATION
, 0
, 0
, T.TRANS_QTY COMMIT_QTY
, T.TRANS_QTY2 COMMIT_QTY2
FROM IC_LOTS_MST L
, IC_TRAN_PND T
, IC_ITEM_MST I
WHERE I.ITEM_ID = L.ITEM_ID
AND I.ITEM_ID = T.ITEM_ID
AND L.INACTIVE_IND = 0
AND T.LOT_ID = L.LOT_ID
AND T.DELETE_MARK = 0
AND T.COMPLETED_IND = 0
AND T.TRANS_QTY < 0

Columns