[Home] [Help]
View: CST_PERIOD_CG_SUMMARY_V
Product: | BOM - Bills of Material |
Description: | This view consolidates the results from MTL_PERIOD_CG_SUMMARY and CST_PERIOD_CLOSE_SUMMARY |
Implementation/DBA Data: |
APPS.CST_PERIOD_CG_SUMMARY_V
|
View Text
SELECT MPCS.ACCT_PERIOD_ID
, MPCS.ORGANIZATION_ID
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.DESCRIPTION
, MPCS.INVENTORY_VALUE FROM MTL_PERIOD_CG_SUMMARY MPCS
, CST_COST_GROUPS CCG WHERE CCG.COST_GROUP_ID = MPCS.COST_GROUP_ID UNION ALL SELECT CPCS.ACCT_PERIOD_ID
, CPCS.ORGANIZATION_ID
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.DESCRIPTION
, SUM(NVL(CPCS.ROLLBACK_VALUE
, 0)) FROM CST_PERIOD_CLOSE_SUMMARY CPCS
, CST_COST_GROUPS CCG WHERE CCG.COST_GROUP_ID = CPCS.COST_GROUP_ID GROUP BY CPCS.ACCT_PERIOD_ID
, CPCS.ORGANIZATION_ID
, CCG.COST_GROUP_ID
, CCG.COST_GROUP
, CCG.DESCRIPTION
Columns
Name |
ACCT_PERIOD_ID |
ORGANIZATION_ID |
COST_GROUP_ID |
COST_GROUP |
DESCRIPTION |
INVENTORY_VALUE |