[Home] [Help]
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
Name |
OBJECT_ID |
GROUP_ID |
PROGRAM_APPLICATION_ID |
ACTUAL_COST |
ESTIMATED_COST |