DBA Data[Home] [Help]

VIEW: APPS.IC_PERD_BAL_VW1

Source

View Text - Preformatted

SELECT FISCAL_YEAR , PERIOD , ITEM_ID , WHSE_CODE , SUM(LOCT_ONHAND) FROM IC_PERD_BAL GROUP BY FISCAL_YEAR, PERIOD, ITEM_ID, WHSE_CODE
View Text - HTML Formatted

SELECT FISCAL_YEAR
, PERIOD
, ITEM_ID
, WHSE_CODE
, SUM(LOCT_ONHAND)
FROM IC_PERD_BAL GROUP BY FISCAL_YEAR
, PERIOD
, ITEM_ID
, WHSE_CODE