APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_R_ACT_CMT_V

Line 55: PA_ADW_R_ACT_CMT_V PTXN,

51: SUM(PTXN.ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
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

Line 114: PA_ADW_R_ACT_CMT_V PTXN,

110: SUM(PTXN.ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
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

Line 171: PA_ADW_R_ACT_CMT_V

167: SUM(ACCUME_CMT_BURDENED_COST) ACCUME_CMT_BURDENED_COST,
168: SUM(ACCUME_CMT_QUANTITY) ACCUME_CMT_QUANTITY,
169: UNIT_OF_MEASURE
170: FROM
171: PA_ADW_R_ACT_CMT_V
172: WHERE
173: RES_ADW_NOTIFY_FLAG = 'S'
174: AND PROJECT_ID = x_project_id
175: GROUP BY

Line 998: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES

994:
995: -- Mark the project types as transferred to Interface table
996:
997: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
998: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES
999:
1000: UPDATE
1001: PA_OLD_RES_ACCUM_DTLS
1002: SET

Line 1424: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES

1420: );
1421: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' top task rows transferred to interface table');
1422:
1423: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
1424: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES
1425:
1426: UPDATE
1427: PA_RESOURCE_ACCUM_DETAILS
1428: SET