222: SUM(PTXN.ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
223: SUM(PTXN.ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
224: PTXN.UNIT_OF_MEASURE
225: FROM
226: PA_ADW_R_ST_ACT_CMT_V PTXN,
227: PA_ADW_LOWEST_TASKS_V PT
228: WHERE
229: PTXN.TASK_ID = PT.TASK_ID
230: AND PTXN.PROJECT_ID = x_project_id
281: SUM(PTXN.ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
282: SUM(PTXN.ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
283: PTXN.UNIT_OF_MEASURE
284: FROM
285: PA_ADW_R_ST_ACT_CMT_V PTXN,
286: PA_ADW_TOP_TASKS_V PT
287: WHERE
288: PTXN.TOP_TASK_ID = PT.TOP_TASK_ID
289: AND PTXN.PROJECT_ID = x_project_id
338: SUM(ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
339: SUM(ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
340: UNIT_OF_MEASURE
341: FROM
342: PA_ADW_R_ST_ACT_CMT_V
343: WHERE
344: (TSK_ADW_NOTIFY_FLAG = 'S' OR TSK_ADW_NOTIFY_FLAG = 'P')
345: AND PROJECT_ID = x_project_id
346: GROUP BY