View: PA_STATUS_TASK_BGT_COST_HIGH_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_TASK_BGT_COST_HIGH_V

View Text

SELECT STBC.PROJECT_ID
, STBC.TASK_ID
, STBC.BUDGET_TYPE_CODE
, SUM(NVL(STBC.BASELINE_RAW_COST_ITD
, 0))
, SUM(NVL(STBC.BASELINE_RAW_COST_YTD
, 0))
, SUM(NVL(STBC.BASELINE_RAW_COST_PP
, 0))
, SUM(NVL(STBC.BASELINE_RAW_COST_PTD
, 0))
, SUM(NVL(STBC.BASELINE_BURDENED_COST_ITD
, 0))
, SUM(NVL(STBC.BASELINE_BURDENED_COST_YTD
, 0))
, SUM(NVL(STBC.BASELINE_BURDENED_COST_PP
, 0))
, SUM(NVL(STBC.BASELINE_BURDENED_COST_PTD
, 0))
, SUM(NVL(STBC.ORIGINAL_RAW_COST_ITD
, 0))
, SUM(NVL(STBC.ORIGINAL_RAW_COST_YTD
, 0))
, SUM(NVL(STBC.ORIGINAL_RAW_COST_PP
, 0))
, SUM(NVL(STBC.ORIGINAL_RAW_COST_PTD
, 0))
, SUM(NVL(STBC.ORIGINAL_BURDENED_COST_ITD
, 0))
, SUM(NVL(STBC.ORIGINAL_BURDENED_COST_YTD
, 0))
, SUM(NVL(STBC.ORIGINAL_BURDENED_COST_PP
, 0))
, SUM(NVL(STBC.ORIGINAL_BURDENED_COST_PTD
, 0))
, SUM(NVL(STBC.ORIGINAL_LABOR_HOURS_ITD
, 0))
, SUM(NVL(STBC.ORIGINAL_LABOR_HOURS_YTD
, 0))
, SUM(NVL(STBC.ORIGINAL_LABOR_HOURS_PP
, 0))
, SUM(NVL(STBC.ORIGINAL_LABOR_HOURS_PTD
, 0))
, SUM(NVL(STBC.BASELINE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(STBC.BASELINE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(STBC.BASELINE_LABOR_HOURS_PP
, 0))
, SUM(NVL(STBC.BASELINE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(STBC.BASELINE_RAW_COST_TOT
, 0))
, SUM(NVL(STBC.BASELINE_BURDENED_COST_TOT
, 0))
, SUM(NVL(STBC.ORIGINAL_RAW_COST_TOT
, 0))
, SUM(NVL(STBC.ORIGINAL_BURDENED_COST_TOT
, 0))
, SUM(NVL(STBC.ORIGINAL_LABOR_HOURS_TOT
, 0))
, SUM(NVL(STBC.BASELINE_LABOR_HOURS_TOT
, 0))
FROM PA_STATUS_TASK_BGT_COST_LOW_V STBC GROUP BY STBC.PROJECT_ID
, STBC.TASK_ID
, STBC.BUDGET_TYPE_CODE

Columns