DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_R_ST_ACT_CMT_V

Line 226: PA_ADW_R_ST_ACT_CMT_V PTXN,

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

Line 285: PA_ADW_R_ST_ACT_CMT_V PTXN,

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

Line 342: PA_ADW_R_ST_ACT_CMT_V

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