View: CST_PERIOD_SUMMARY_V

Product:	BOM - Bills of Material
Description:	This view consolidates the results from MTL_PERIOD_SUMMARY and CST_PERIOD_CLOSE_SUMMARY
Implementation/DBA Data:	APPS.CST_PERIOD_SUMMARY_V

View Text

SELECT MPS.ACCT_PERIOD_ID
, MPS.ORGANIZATION_ID
, MSI.SECONDARY_INVENTORY_NAME
, DECODE(MSI.SECONDARY_INVENTORY_NAME
, NULL
, ML.MEANING
, MSI.DESCRIPTION)
, MPS.INVENTORY_VALUE FROM MTL_PERIOD_SUMMARY MPS
, MTL_SECONDARY_INVENTORIES MSI
, MFG_LOOKUPS ML WHERE MSI.ORGANIZATION_ID (+) = MPS.ORGANIZATION_ID AND MSI.SECONDARY_INVENTORY_NAME (+) = MPS.SECONDARY_INVENTORY AND ML.LOOKUP_TYPE = 'CST_PER_CLOSE_MISC' AND ML.LOOKUP_CODE = 1 UNION ALL SELECT CPCS.ACCT_PERIOD_ID
, CPCS.ORGANIZATION_ID
, MSI.SECONDARY_INVENTORY_NAME
, DECODE(MSI.SECONDARY_INVENTORY_NAME
, NULL
, ML.MEANING
, MSI.DESCRIPTION)
, /* WE DO NOT USE ACCOUNTED VALUE BECAUSE IT IS ADJUSTED TO THE ROLLBACK VALUE */ SUM(NVL(CPCS.ROLLBACK_VALUE
, 0)) FROM CST_PERIOD_CLOSE_SUMMARY CPCS
, MTL_SECONDARY_INVENTORIES MSI
, MFG_LOOKUPS ML WHERE MSI.ORGANIZATION_ID (+) = CPCS.ORGANIZATION_ID AND MSI.SECONDARY_INVENTORY_NAME (+) = CPCS.SUBINVENTORY_CODE AND ML.LOOKUP_TYPE = 'CST_PER_CLOSE_MISC' AND ML.LOOKUP_CODE = 1 GROUP BY CPCS.ACCT_PERIOD_ID
, CPCS.ORGANIZATION_ID
, MSI.SECONDARY_INVENTORY_NAME
, DECODE(MSI.SECONDARY_INVENTORY_NAME
, NULL
, ML.MEANING
, MSI.DESCRIPTION)

Columns