[Home] [Help]
View: IC_LOCT_INV_RPTVW4
Product: | GMI - Process Manufacturing Inventory |
Description: | Trial Picklist report view. |
Implementation/DBA Data: |
APPS.IC_LOCT_INV_RPTVW4
|
View Text
SELECT WHSE_CODE
, ITEM_ID
, LOCATION
, SUM(LOCT_ONHAND)
, SUM(LOCT_ONHAND2)
FROM IC_LOCT_INV
WHERE DELETE_MARK = 0 GROUP BY WHSE_CODE
, ITEM_ID
, LOCATION
Columns
Name |
WHSE_CODE |
ITEM_ID |
LOCATION |
LOCT_ONHAND |
LOCT_ONHAND2 |