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
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
|
|
|