View: PA_STATUS_RSRC_CMT_HIGH_V

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

View Text

SELECT SRCL.PROJECT_ID
, SRCL.TASK_ID
, SRCL.RESOURCE_LIST_MEMBER_ID
, SRCL.PARENT_MEMBER_ID
, SRCL.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(SRCL.CMT_RAW_COST_ITD
, 0))
, SUM(NVL(SRCL.CMT_RAW_COST_YTD
, 0))
, SUM(NVL(SRCL.CMT_RAW_COST_PP
, 0))
, SUM(NVL(SRCL.CMT_RAW_COST_PTD
, 0))
, SUM(NVL(SRCL.CMT_BURDENED_COST_ITD
, 0))
, SUM(NVL(SRCL.CMT_BURDENED_COST_YTD
, 0))
, SUM(NVL(SRCL.CMT_BURDENED_COST_PP
, 0))
, SUM(NVL(SRCL.CMT_BURDENED_COST_PTD
, 0))
, SUM(NVL(SRCL.CMT_QUANTITY_ITD
, 0))
, SUM(NVL(SRCL.CMT_QUANTITY_YTD
, 0))
, SUM(NVL(SRCL.CMT_QUANTITY_PP
, 0))
, SUM(NVL(SRCL.CMT_QUANTITY_PTD
, 0))
FROM PA_STATUS_RSRC_CMT_LOW_V SRCL GROUP BY SRCL.PROJECT_ID
, SRCL.TASK_ID
, SRCL.RESOURCE_LIST_MEMBER_ID
, SRCL.PARENT_MEMBER_ID
, SRCL.RESOURCE_LIST_ASSIGNMENT_ID

Columns