VIEW: APPS.IC_LOCT_INV_RPTVW4

Source

View Text - Preformatted

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

View Text - HTML Formatted

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