Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_STATUS_RSRC_BGT_COST_HIGH_V |
SELECT SRBCL.PROJECT_ID
, SRBCL.TASK_ID
, SRBCL.RESOURCE_LIST_MEMBER_ID
, SRBCL.PARENT_MEMBER_ID
, SRBCL.BUDGET_TYPE_CODE
, SRBCL.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(SRBCL.BASELINE_RAW_COST_ITD
, 0))
, SUM(NVL(SRBCL.BASELINE_RAW_COST_YTD
, 0))
, SUM(NVL(SRBCL.BASELINE_RAW_COST_PP
, 0))
, SUM(NVL(SRBCL.BASELINE_RAW_COST_PTD
, 0))
, SUM(NVL(SRBCL.BASELINE_BURDENED_COST_ITD
, 0))
, SUM(NVL(SRBCL.BASELINE_BURDENED_COST_YTD
, 0))
, SUM(NVL(SRBCL.BASELINE_BURDENED_COST_PP
, 0))
, SUM(NVL(SRBCL.BASELINE_BURDENED_COST_PTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_RAW_COST_ITD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_RAW_COST_YTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_RAW_COST_PP
, 0))
, SUM(NVL(SRBCL.ORIGINAL_RAW_COST_PTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_BURDENED_COST_ITD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_BURDENED_COST_YTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_BURDENED_COST_PP
, 0))
, SUM(NVL(SRBCL.ORIGINAL_BURDENED_COST_PTD
, 0))
, SUM(NVL(SRBCL.BASELINE_QUANTITY_ITD
, 0))
, SUM(NVL(SRBCL.BASELINE_QUANTITY_YTD
, 0))
, SUM(NVL(SRBCL.BASELINE_QUANTITY_PP
, 0))
, SUM(NVL(SRBCL.BASELINE_QUANTITY_PTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_QUANTITY_ITD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_QUANTITY_YTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_QUANTITY_PP
, 0))
, SUM(NVL(SRBCL.ORIGINAL_QUANTITY_PTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRBCL.ORIGINAL_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRBCL.ORIGINAL_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRBCL.BASELINE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRBCL.BASELINE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRBCL.BASELINE_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRBCL.BASELINE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRBCL.BASELINE_RAW_COST_TOT
, 0))
, SUM(NVL(SRBCL.BASELINE_BURDENED_COST_TOT
, 0))
, SUM(NVL(SRBCL.ORIGINAL_RAW_COST_TOT
, 0))
, SUM(NVL(SRBCL.ORIGINAL_BURDENED_COST_TOT
, 0))
, SUM(NVL(SRBCL.ORIGINAL_LABOR_HOURS_TOT
, 0))
, SUM(NVL(SRBCL.BASELINE_LABOR_HOURS_TOT
, 0))
, SUM(NVL(SRBCL.BASELINE_QUANTITY_TOT
, 0))
, SUM(NVL(SRBCL.ORIGINAL_QUANTITY_TOT
, 0))
FROM PA_STATUS_RSRC_BGT_COST_LOW_V SRBCL GROUP BY SRBCL.PROJECT_ID
, SRBCL.TASK_ID
, SRBCL.RESOURCE_LIST_MEMBER_ID
, SRBCL.PARENT_MEMBER_ID
, SRBCL.BUDGET_TYPE_CODE
, SRBCL.RESOURCE_LIST_ASSIGNMENT_ID