View: PA_ACCUM_RSRC_CMT_V

Product:	PA - Projects
Description:	A summary view based on PA_ACCUM_RSRC_CMT_BASE_V, that shows project and task.
Implementation/DBA Data:	APPS.PA_ACCUM_RSRC_CMT_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.CMT_RAW_COST_ITD
, 0))
, SUM(NVL(AR.CMT_RAW_COST_YTD
, 0))
, SUM(NVL(AR.CMT_RAW_COST_PP
, 0))
, SUM(NVL(AR.CMT_RAW_COST_PTD
, 0))
, SUM(NVL(AR.CMT_BURDENED_COST_ITD
, 0))
, SUM(NVL(AR.CMT_BURDENED_COST_YTD
, 0))
, SUM(NVL(AR.CMT_BURDENED_COST_PP
, 0))
, SUM(NVL(AR.CMT_BURDENED_COST_PTD
, 0))
, SUM(NVL(AR.CMT_QUANTITY_ITD
, 0))
, SUM(NVL(AR.CMT_QUANTITY_YTD
, 0))
, SUM(NVL(AR.CMT_QUANTITY_PP
, 0))
, SUM(NVL(AR.CMT_QUANTITY_PTD
, 0))
FROM PA_ACCUM_RSRC_CMT_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