APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_TOP_TASKS_V

Line 115: PA_ADW_TOP_TASKS_V PT

111: SUM(PTXN.ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
112: PTXN.UNIT_OF_MEASURE
113: FROM
114: PA_ADW_R_ACT_CMT_V PTXN,
115: PA_ADW_TOP_TASKS_V PT
116: WHERE
117: PTXN.TOP_TASK_ID = PT.TOP_TASK_ID
118: AND PTXN.PROJECT_ID = x_project_id
119: AND PTXN.RES_ADW_NOTIFY_FLAG = 'S'

Line 286: PA_ADW_TOP_TASKS_V PT

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
290: AND (PTXN.TSK_ADW_NOTIFY_FLAG = 'S' OR PTXN.TSK_ADW_NOTIFY_FLAG = 'P')

Line 535: PA_ADW_TOP_TASKS_V PT

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
539: AND (PTXN.RES_ADW_NOTIFY_FLAG = 'S' OR PTXN.TXN_ADW_NOTIFY_FLAG = 'S')

Line 1959: PA_ADW_TOP_TASKS_V PT

1955: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
1956: PBGT.BGT_UNIT_OF_MEASURE
1957: FROM
1958: PA_ADW_R_BGT_LINES_V PBGT,
1959: PA_ADW_TOP_TASKS_V PT
1960: WHERE
1961: PBGT.TOP_TASK_ID = PT.TOP_TASK_ID
1962: AND PBGT.PROJECT_ID = x_project_id
1963: AND PBGT.ADW_NOTIFY_FLAG = 'R'

Line 2108: PA_ADW_TOP_TASKS_V PT

2104: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2105: PBGT.BGT_UNIT_OF_MEASURE
2106: FROM
2107: PA_ADW_BGT_LINES_V PBGT,
2108: PA_ADW_TOP_TASKS_V PT
2109: WHERE
2110: PBGT.TOP_TASK_ID = PT.TOP_TASK_ID
2111: AND PBGT.PROJECT_ID = x_project_id
2112: AND PBGT.ADW_NOTIFY_FLAG = 'S'