View: CST_EAM_ROLLUP_BYPERIODS_EST_V

Product:	BOM - Bills of Material
Description:	Asset Rollup Estimated Cost by Period
Implementation/DBA Data:	APPS.CST_EAM_ROLLUP_BYPERIODS_EST_V

View Text

SELECT CS.GROUP_ID
, CS.PERIOD_SET_NAME
, CS.PERIOD_NAME
, CS.PERIOD_START_DATE
, CS.INV_ID
, MI.CONCATENATED_SEGMENTS
, CS.ORG_ID
, CS.SERIAL_NUMBER
, CS.TOTAL
, CS.MATERIAL
, CS.LABOR
, CS.EQUIPMENT
FROM (SELECT T1.GROUP_ID
, T1.INVENTORY_ITEM_ID AS INV_ID
, T1.ORGANIZATION_ID AS ORG_ID
, T1.SERIAL_NUMBER AS SERIAL_NUMBER
, T1.PERIOD_SET_NAME
, T1.PERIOD_NAME
, T1.PERIOD_START_DATE
, (NVL(SUM(T1.SYSTEM_ESTIMATED_MAT_COST)
, 0)+NVL(SUM(T1.SYSTEM_ESTIMATED_LAB_COST)
, 0)+NVL(SUM(T1.SYSTEM_ESTIMATED_EQP_COST)
, 0)) AS TOTAL
, NVL(SUM(T1.SYSTEM_ESTIMATED_MAT_COST)
, 0) AS MATERIAL
, NVL(SUM(T1.SYSTEM_ESTIMATED_LAB_COST)
, 0) AS LABOR
, NVL(SUM(T1.SYSTEM_ESTIMATED_EQP_COST)
, 0) AS EQUIPMENT
FROM CST_EAM_ROLLUP_TEMP T1 GROUP BY T1.INVENTORY_ITEM_ID
, T1.ORGANIZATION_ID
, T1.SERIAL_NUMBER
, T1.PERIOD_SET_NAME
, T1.PERIOD_NAME
, T1.PERIOD_START_DATE
, T1.GROUP_ID) CS
, MTL_SYSTEM_ITEMS_B_KFV MI
WHERE MI.INVENTORY_ITEM_ID = CS.INV_ID
AND MI.ORGANIZATION_ID = CS.ORG_ID ORDER BY PERIOD_START_DATE ASC

Columns