View: IC_LOCT_INV_UNALLOC

Product:	GMI - Process Manufacturing Inventory
Description:	Not currently used
Implementation/DBA Data:	APPS.IC_LOCT_INV_UNALLOC

View Text

SELECT INV.ITEM_ID
, INV.WHSE_CODE
, INV.LOCATION
, INV.LOCT_ONHAND
, INV.LOT_STATUS
, INV.LOT_ID
, MST.LOT_NO
, MST.SUBLOT_NO
, MST.EXPIRE_DATE
, STS.PROD_IND
, STS.ORDER_PROC_IND
, STS.SHIPPING_IND
, STS.NETTABLE_IND
FROM IC_LOTS_MST MST
, IC_LOTS_STS STS
, IC_LOCT_INV INV
WHERE MST.INACTIVE_IND = 0
AND INV.ITEM_ID = MST.ITEM_ID
AND INV.LOT_ID = MST.LOT_ID
AND INV.LOT_STATUS = STS.LOT_STATUS
AND INV.LOCT_ONHAND > 0
AND INV.LOT_ID <> 0
AND STS.REJECTED_IND = 0

Columns