View: PA_STATUS_RSRC_BGT_REV_HIGH_V

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

View Text

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

Columns