APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_ACT_CMT_V

Line 397: PA_ADW_ACT_CMT_V

393: SUM(ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
394: SUM(ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
395: UNIT_OF_MEASURE
396: FROM
397: PA_ADW_ACT_CMT_V
398: WHERE
399: PROJECT_ID = x_project_id
400: AND (TASK_ID,
401: PA_PERIOD_KEY,

Line 429: PA_ADW_ACT_CMT_V PTXN,

425: NVL(PTXN.USER_COL4,'X'),
426: NVL(PTXN.USER_COL5,'X'),
427: NVL(PTXN.UNIT_OF_MEASURE,'X')
428: FROM
429: PA_ADW_ACT_CMT_V PTXN,
430: PA_ADW_LOWEST_TASKS_V PT
431: WHERE
432: PTXN.TASK_ID = PT.TASK_ID
433: AND PTXN.PROJECT_ID = x_project_id

Line 502: PA_ADW_ACT_CMT_V

498: SUM(ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
499: SUM(ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
500: UNIT_OF_MEASURE
501: FROM
502: PA_ADW_ACT_CMT_V
503: WHERE
504: PROJECT_ID = x_project_id
505: AND (TOP_TASK_ID,
506: PA_PERIOD_KEY,

Line 534: PA_ADW_ACT_CMT_V PTXN,

530: NVL(PTXN.USER_COL4,'X'),
531: NVL(PTXN.USER_COL5,'X'),
532: NVL(PTXN.UNIT_OF_MEASURE,'X')
533: FROM
534: PA_ADW_ACT_CMT_V PTXN,
535: PA_ADW_TOP_TASKS_V PT
536: WHERE
537: PTXN.TOP_TASK_ID = PT.TOP_TASK_ID
538: AND PTXN.PROJECT_ID = x_project_id

Line 605: PA_ADW_ACT_CMT_V

601: SUM(ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
602: SUM(ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
603: UNIT_OF_MEASURE
604: FROM
605: PA_ADW_ACT_CMT_V
606: WHERE
607: PROJECT_ID = x_project_id
608: AND (PROJECT_ID,
609: PA_PERIOD_KEY,

Line 637: PA_ADW_ACT_CMT_V PTXN

633: NVL(PTXN.USER_COL4,'X'),
634: NVL(PTXN.USER_COL5,'X'),
635: NVL(PTXN.UNIT_OF_MEASURE,'X')
636: FROM
637: PA_ADW_ACT_CMT_V PTXN
638: WHERE
639: PTXN.PROJECT_ID = x_project_id
640: AND (PTXN.RES_ADW_NOTIFY_FLAG = 'S' OR PTXN.TXN_ADW_NOTIFY_FLAG = 'S')
641: GROUP BY