View: AHL_VWP_ROLLUP_COSTS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view query is used to retreive data from CST_EAM_ROLLUP_COSTS table.
Implementation/DBA Data:	APPS.AHL_VWP_ROLLUP_COSTS_V

View Text

SELECT OBJECT_ID
, GROUP_ID
, PROGRAM_APPLICATION_ID
, NVL(ACTUAL_MAT_COST
, 0)+ NVL(ACTUAL_LAB_COST
, 0)+ NVL(ACTUAL_EQP_COST
, 0) ACTUAL_COST
, NVL(ESTIMATED_MAT_COST
, 0)+ NVL(ESTIMATED_LAB_COST
, 0)+ NVL(ESTIMATED_EQP_COST
, 0) ESTIMATED_COST
FROM CST_EAM_ROLLUP_COSTS

Columns