FND Design Data [Home] [Help]

View: IC_LOCT_INV_RPTVW3

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

SELECT ILI.WHSE_CODE
, 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 ILI.WHSE_CODE
, ITM.ITEM_ID

Columns

Name
WHSE_CODE
ITEM_ID
WHSE_ONHAND
WHSE_ONHAND2