[Home] [Help]
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
Name |
ITEM_ID |
WHSE_CODE |
LOCATION |
LOCT_ONHAND |
LOT_STATUS |
LOT_ID |
LOT_NO |
SUBLOT_NO |
EXPIRE_DATE |
PROD_IND |
ORDER_PROC_IND |
SHIPPING_IND |
NETTABLE_IND |