View: PA_ACCUM_RSRC_ACT_V

Product:	PA - Projects
Description:	A summary view based on PA_ACCUM_RSRC_ACT_BASE_V, that shows project and task level resource actuals.
Implementation/DBA Data:	APPS.PA_ACCUM_RSRC_ACT_V

View Text

SELECT AR.PROJECT_ID
, AR.TASK_ID
, AR.RESOURCE_LIST_MEMBER_ID
, AR.PARENT_MEMBER_ID
, AR.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(AR.RAW_COST_ITD
, 0))
, SUM(NVL(AR.RAW_COST_YTD
, 0))
, SUM(NVL(AR.RAW_COST_PP
, 0))
, SUM(NVL(AR.RAW_COST_PTD
, 0))
, SUM(NVL(AR.BILLABLE_RAW_COST_ITD
, 0))
, SUM(NVL(AR.BILLABLE_RAW_COST_YTD
, 0))
, SUM(NVL(AR.BILLABLE_RAW_COST_PP
, 0))
, SUM(NVL(AR.BILLABLE_RAW_COST_PTD
, 0))
, SUM(NVL(AR.BURDENED_COST_ITD
, 0))
, SUM(NVL(AR.BURDENED_COST_YTD
, 0))
, SUM(NVL(AR.BURDENED_COST_PP
, 0))
, SUM(NVL(AR.BURDENED_COST_PTD
, 0))
, SUM(NVL(AR.BILLABLE_BURDENED_COST_ITD
, 0))
, SUM(NVL(AR.BILLABLE_BURDENED_COST_YTD
, 0))
, SUM(NVL(AR.BILLABLE_BURDENED_COST_PP
, 0))
, SUM(NVL(AR.BILLABLE_BURDENED_COST_PTD
, 0))
, SUM(NVL(AR.ACTUALS_QUANTITY_ITD
, 0))
, SUM(NVL(AR.ACTUALS_QUANTITY_YTD
, 0))
, SUM(NVL(AR.ACTUALS_QUANTITY_PP
, 0))
, SUM(NVL(AR.ACTUALS_QUANTITY_PTD
, 0))
, SUM(NVL(AR.BILLABLE_QUANTITY_ITD
, 0))
, SUM(NVL(AR.BILLABLE_QUANTITY_YTD
, 0))
, SUM(NVL(AR.BILLABLE_QUANTITY_PP
, 0))
, SUM(NVL(AR.BILLABLE_QUANTITY_PTD
, 0))
, SUM(NVL(AR.ACTUALS_LABOR_HOURS_ITD
, 0))
, SUM(NVL(AR.ACTUALS_LABOR_HOURS_YTD
, 0))
, SUM(NVL(AR.ACTUALS_LABOR_HOURS_PP
, 0))
, SUM(NVL(AR.ACTUALS_LABOR_HOURS_PTD
, 0))
, SUM(NVL(AR.BILLABLE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(AR.BILLABLE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(AR.BILLABLE_LABOR_HOURS_PP
, 0))
, SUM(NVL(AR.BILLABLE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(AR.REVENUE_ITD
, 0))
, SUM(NVL(AR.REVENUE_YTD
, 0))
, SUM(NVL(AR.REVENUE_PP
, 0))
, SUM(NVL(AR.REVENUE_PTD
, 0))
FROM PA_ACCUM_RSRC_ACT_BASE_V AR GROUP BY AR.PROJECT_ID
, AR.TASK_ID
, AR.RESOURCE_LIST_MEMBER_ID
, AR.PARENT_MEMBER_ID
, AR.RESOURCE_LIST_ASSIGNMENT_ID

Columns