Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_STATUS_RSRC_BGT_REV_HIGH_V |
SELECT SRBRL.PROJECT_ID
, SRBRL.TASK_ID
, SRBRL.RESOURCE_LIST_MEMBER_ID
, SRBRL.PARENT_MEMBER_ID
, SRBRL.BUDGET_TYPE_CODE
, SRBRL.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(SRBRL.BASELINE_REVENUE_ITD
, 0))
, SUM(NVL(SRBRL.BASELINE_REVENUE_YTD
, 0))
, SUM(NVL(SRBRL.BASELINE_REVENUE_PP
, 0))
, SUM(NVL(SRBRL.BASELINE_REVENUE_PTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_REVENUE_ITD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_REVENUE_YTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_REVENUE_PP
, 0))
, SUM(NVL(SRBRL.ORIGINAL_REVENUE_PTD
, 0))
, SUM(NVL(SRBRL.BASELINE_QUANTITY_ITD
, 0))
, SUM(NVL(SRBRL.BASELINE_QUANTITY_YTD
, 0))
, SUM(NVL(SRBRL.BASELINE_QUANTITY_PP
, 0))
, SUM(NVL(SRBRL.BASELINE_QUANTITY_PTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_QUANTITY_ITD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_QUANTITY_YTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_QUANTITY_PP
, 0))
, SUM(NVL(SRBRL.ORIGINAL_QUANTITY_PTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRBRL.ORIGINAL_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRBRL.ORIGINAL_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRBRL.BASELINE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRBRL.BASELINE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRBRL.BASELINE_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRBRL.BASELINE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRBRL.BASELINE_REVENUE_TOT
, 0))
, SUM(NVL(SRBRL.ORIGINAL_REVENUE_TOT
, 0))
, SUM(NVL(SRBRL.ORIGINAL_LABOR_HOURS_TOT
, 0))
, SUM(NVL(SRBRL.BASELINE_LABOR_HOURS_TOT
, 0))
, SUM(NVL(SRBRL.BASELINE_QUANTITY_TOT
, 0))
, SUM(NVL(SRBRL.ORIGINAL_QUANTITY_TOT
, 0))
FROM PA_STATUS_RSRC_BGT_REV_LOW_V SRBRL GROUP BY SRBRL.PROJECT_ID
, SRBRL.TASK_ID
, SRBRL.RESOURCE_LIST_MEMBER_ID
, SRBRL.PARENT_MEMBER_ID
, SRBRL.BUDGET_TYPE_CODE
, SRBRL.RESOURCE_LIST_ASSIGNMENT_ID