eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_LOWEST_TASKS_V

Line 56: PA_ADW_LOWEST_TASKS_V PT

52: SUM(PTXN.ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
53: PTXN.UNIT_OF_MEASURE
54: FROM
55: PA_ADW_R_ACT_CMT_V PTXN,
56: PA_ADW_LOWEST_TASKS_V PT
57: WHERE
58: PTXN.TASK_ID = PT.TASK_ID
59: AND PTXN.PROJECT_ID = x_project_id
60: -- Exclude top tasks

Line 227: PA_ADW_LOWEST_TASKS_V PT

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
231: -- Exclude top tasks

Line 430: PA_ADW_LOWEST_TASKS_V PT

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
434: -- Exclude the tasks which are top tasks

Line 1908: PA_ADW_LOWEST_TASKS_V PT

1904: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
1905: PBGT.BGT_UNIT_OF_MEASURE
1906: FROM
1907: PA_ADW_R_BGT_LINES_V PBGT,
1908: PA_ADW_LOWEST_TASKS_V PT
1909: WHERE
1910: PBGT.TASK_ID = PT.TASK_ID
1911: AND PBGT.PROJECT_ID = x_project_id
1912: -- Exclude the tasks which are top tasks

Line 2057: PA_ADW_LOWEST_TASKS_V PT

2053: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2054: PBGT.BGT_UNIT_OF_MEASURE
2055: FROM
2056: PA_ADW_BGT_LINES_V PBGT,
2057: PA_ADW_LOWEST_TASKS_V PT
2058: WHERE
2059: PBGT.TASK_ID = PT.TASK_ID
2060: -- Exclude the tasks which are top tasks
2061: AND PT.TASK_ID <> PT.TOP_TASK_ID