VIEW: APPS.CST_PERIOD_SUMMARY_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)