FND Design Data [Home] [Help]

View: IC_LOCT_INV_RPTVW2

Product: GMI - Process Manufacturing Inventory
Description: Not currently used.
Implementation/DBA Data: ViewAPPS.IC_LOCT_INV_RPTVW2
View Text

SELECT ITM.ITEM_ID
, SUM(ILI.LOCT_ONHAND)
, SUM(ILI.LOCT_ONHAND2)
FROM IC_ITEM_MST ITM
, IC_LOCT_INV ILI
WHERE ITM.ITEM_ID = ILI.ITEM_ID
AND ILI.DELETE_MARK = 0
AND ITM.DELETE_MARK = 0 GROUP BY ITM.ITEM_ID

Columns

Name
ITEM_ID
TOTAL_ONHAND
TOTAL_ONHAND2