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