View: CST_EAM_ASSET_BY_DEPT_EST_V

Product:	BOM - Bills of Material
Description:	Asset Estimated Cost by Maintenance Department Type
Implementation/DBA Data:	APPS.CST_EAM_ASSET_BY_DEPT_EST_V

View Text

SELECT CS.PERIOD_SET_NAME
, CS.PERIOD_NAME
, CS.PERIOD_START_DATE
, B1.MEANING AS NAME
, CS.INV_ID
, MI.CONCATENATED_SEGMENTS
, CS.ORG_ID
, CS.SERIAL_NUMBER
, CS.TOTAL
, CS.MATERIAL
, CS.LABOR
, CS.EQUIPMENT
FROM (SELECT T1.MAINT_COST_CATEGORY
, 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_ASSET_PER_BALANCES T1 GROUP BY T1.MAINT_COST_CATEGORY
, T1.INVENTORY_ITEM_ID
, T1.ORGANIZATION_ID
, T1.SERIAL_NUMBER
, T1.PERIOD_SET_NAME
, T1.PERIOD_NAME
, T1.PERIOD_START_DATE) CS
, MTL_SYSTEM_ITEMS_B_KFV MI
, MFG_LOOKUPS B1
WHERE MI.INVENTORY_ITEM_ID = CS.INV_ID
AND MI.ORGANIZATION_ID = CS.ORG_ID
AND CS.MAINT_COST_CATEGORY = B1.LOOKUP_CODE
AND B1.LOOKUP_TYPE = 'BOM_EAM_COST_CATEGORY' ORDER BY PERIOD_START_DATE ASC

Columns