[Home] [Help]
View: IC_PERD_BAL_VW1
Product: | GMI - Process Manufacturing Inventory |
Description: | Period balance view. |
Implementation/DBA Data: |
APPS.IC_PERD_BAL_VW1
|
View Text
SELECT FISCAL_YEAR
, PERIOD
, ITEM_ID
, WHSE_CODE
, SUM(LOCT_ONHAND)
FROM IC_PERD_BAL GROUP BY FISCAL_YEAR
, PERIOD
, ITEM_ID
, WHSE_CODE
Columns
Name |
FISCAL_YEAR |
PERIOD |
ITEM_ID |
WHSE_CODE |
ENDING_BAL |