View: PA_ACCUM_RSRC_REV_BGT_V

Product:	PA - Projects
Description:	A summary view based on PA_ACCUM_RSRC_REV_BGT_BASE_V, that shows project and task level revenue budgets.
Implementation/DBA Data:	APPS.PA_ACCUM_RSRC_REV_BGT_V

View Text

SELECT AR.PROJECT_ID
, AR.TASK_ID
, AR.RESOURCE_LIST_MEMBER_ID
, AR.PARENT_MEMBER_ID
, AR.BUDGET_TYPE_CODE
, AR.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(AR.BASELINE_REVENUE_ITD
, 0))
, SUM(NVL(AR.BASELINE_REVENUE_YTD
, 0))
, SUM(NVL(AR.BASELINE_REVENUE_PP
, 0))
, SUM(NVL(AR.BASELINE_REVENUE_PTD
, 0))
, SUM(NVL(AR.ORIGINAL_REVENUE_ITD
, 0))
, SUM(NVL(AR.ORIGINAL_REVENUE_YTD
, 0))
, SUM(NVL(AR.ORIGINAL_REVENUE_PP
, 0))
, SUM(NVL(AR.ORIGINAL_REVENUE_PTD
, 0))
, SUM(NVL(AR.BASELINE_QUANTITY_ITD
, 0))
, SUM(NVL(AR.BASELINE_QUANTITY_YTD
, 0))
, SUM(NVL(AR.BASELINE_QUANTITY_PP
, 0))
, SUM(NVL(AR.BASELINE_QUANTITY_PTD
, 0))
, SUM(NVL(AR.ORIGINAL_QUANTITY_ITD
, 0))
, SUM(NVL(AR.ORIGINAL_QUANTITY_YTD
, 0))
, SUM(NVL(AR.ORIGINAL_QUANTITY_PP
, 0))
, SUM(NVL(AR.ORIGINAL_QUANTITY_PTD
, 0))
, SUM(NVL(AR.ORIGINAL_LABOR_HOURS_ITD
, 0))
, SUM(NVL(AR.ORIGINAL_LABOR_HOURS_YTD
, 0))
, SUM(NVL(AR.ORIGINAL_LABOR_HOURS_PP
, 0))
, SUM(NVL(AR.ORIGINAL_LABOR_HOURS_PTD
, 0))
, SUM(NVL(AR.BASELINE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(AR.BASELINE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(AR.BASELINE_LABOR_HOURS_PP
, 0))
, SUM(NVL(AR.BASELINE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(AR.BASELINE_REVENUE_TOT
, 0))
, SUM(NVL(AR.ORIGINAL_REVENUE_TOT
, 0))
, SUM(NVL(AR.ORIGINAL_LABOR_HOURS_TOT
, 0))
, SUM(NVL(AR.BASELINE_LABOR_HOURS_TOT
, 0))
, SUM(NVL(AR.BASELINE_QUANTITY_TOT
, 0))
, SUM(NVL(AR.ORIGINAL_QUANTITY_TOT
, 0))
FROM PA_ACCUM_RSRC_REV_BGT_BASE_V AR GROUP BY AR.PROJECT_ID
, AR.TASK_ID
, AR.RESOURCE_LIST_MEMBER_ID
, AR.PARENT_MEMBER_ID
, AR.BUDGET_TYPE_CODE
, AR.RESOURCE_LIST_ASSIGNMENT_ID

Columns