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_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 104: FROM pa_proj_elements a, pa_proj_element_versions b,

100: --status control is not used anymore
101: CURSOR get_system_status_code(c_element_version_id NUMBER)
102: IS
103: SELECT decode(project_system_status_code, 'CANCELLED', 'N', 'Y')
104: FROM pa_proj_elements a, pa_proj_element_versions b,
105: pa_project_statuses c
106: where a.proj_element_id = b.proj_element_id
107: and a.project_id = b.project_id
108: and b.element_version_id = c_element_version_id

Line 119: FROM pa_proj_element_versions ppev,

115: CURSOR get_lnk_task(cp_task_version_id NUMBER) IS
116: SELECT ppe.proj_element_id,
117: ppev.element_version_id lnk_task_ver_id,
118: ppev.project_id lnk_task_project_id
119: FROM pa_proj_element_versions ppev,
120: pa_proj_elements ppe,
121: pa_proj_elem_ver_schedule pevs,
122: --bug 4541039
123: pa_object_relationships por,

Line 171: FROM pa_proj_element_versions a,

167: cp_lnk_proj_id_from NUMBER,
168: cp_lnk_proj_id_to NUMBER) IS
169: SELECT min(scheduled_start_date) lnk_task_sch_start_Dt
170: FROM (SELECT min(b.scheduled_start_date) scheduled_start_date --bug 3967855
171: FROM pa_proj_element_versions a,
172: pa_proj_elem_ver_schedule b
173: WHERE a.project_id = b.project_id
174: AND a.element_version_id = b.element_version_id
175: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance

Line 186: FROM pa_proj_element_versions c,

182: AND object_type_to = 'PA_TASKS')
183: -- AND object_type_from = 'PA_STRUCTURES') --Bug 3634389
184: UNION ALL
185: SELECT min(d.scheduled_start_date) scheduled_start_date --bug 3967855
186: FROM pa_proj_element_versions c,
187: pa_proj_elem_ver_schedule d
188: ,pa_proj_elem_ver_structure e --bug 4541039
189: WHERE c.project_id = d.project_id
190: AND d.project_id =e.project_id --Bug#6277752 Added for performance

Line 214: FROM pa_proj_element_versions a,

210: cp_lnk_proj_id_from NUMBER,
211: cp_lnk_proj_id_to NUMBER) IS
212: SELECT max(scheduled_finish_date) lnk_task_sch_finish_Dt
213: FROM (SELECT max(b.scheduled_finish_date) scheduled_finish_date --bug 3967855
214: FROM pa_proj_element_versions a,
215: pa_proj_elem_ver_schedule b
216: WHERE a.project_id = b.project_id
217: AND a.element_version_id = b.element_version_id
218: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance

Line 229: FROM pa_proj_element_versions c,

225: AND object_type_to = 'PA_TASKS')
226: -- AND object_type_from = 'PA_STRUCTURES') --Bug 3634389
227: UNION ALL
228: SELECT max(d.scheduled_finish_date) scheduled_finish_date --bug 3967855
229: FROM pa_proj_element_versions c,
230: pa_proj_elem_ver_schedule d
231: ,pa_proj_elem_ver_structure e --bug 4541039
232: WHERE c.project_id = d.project_id
233: AND d.project_id =e.project_id --Bug#6277752 Added for performance

Line 277: FROM pa_proj_element_versions

273:
274: cursor get_structure_id(c_structure_ver_id NUMBER)
275: IS
276: SELECT project_id, proj_element_id
277: FROM pa_proj_element_versions
278: where element_version_id = c_structure_ver_id;
279: --end bug 4416432 issue # 5 and 6
280:
281: l_debug_mode VARCHAR2(1);

Line 499: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

495: ' a.object_type, b.PLANNED_EFFORT, '||
496: ' NVL(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
497: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
498: ' c.object_type_from FROM '||
499: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
500: ' pa_object_relationships c, pa_proj_elements d WHERE '||
501: ' a.element_version_id = c.object_id_to1(+) AND '||
502: ' c.relationship_type(+)= '||''''||'S'||''''||' AND '||
503: ' a.project_id = b.project_id AND '||

Line 523: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

519: ' a.object_type, b.PLANNED_EFFORT, '||
520: ' nvl(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
521: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
522: ' c.object_type_from FROM '||
523: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
524: ' pa_object_relationships c, pa_proj_elements d WHERE '||
525: ' a.element_version_id = c.object_id_to1 AND '||
526: ' c.relationship_type = '||''''||'S'||''''||' AND '||
527: ' a.project_id = b.project_id AND '||

Line 1191: pa_proj_element_versions b

1187:
1188: cursor c1(c_child_element_id NUMBER) IS
1189: select b.project_id, b.element_version_id
1190: from pa_object_relationships a,
1191: pa_proj_element_versions b
1192: where a.relationship_type = 'L'
1193: and a.object_id_to1 = c_child_element_id
1194: and a.object_type_from = 'PA_TASKS'
1195: and a.object_id_from1 = b.element_version_id

Line 1220: FROM pa_proj_element_versions

1216: -- hsiu auto sync changes
1217: cursor get_structure_id(c_structure_ver_id NUMBER)
1218: IS
1219: SELECT project_id, proj_element_id
1220: FROM pa_proj_element_versions
1221: where element_version_id = c_structure_ver_id;
1222:
1223: l_structure_id NUMBER;
1224: l_struc_project_id NUMBER;

Line 1231: FROM pa_proj_elements a, pa_proj_element_versions b

1227: CURSOR get_rollup_flag(c_element_version_id NUMBER)
1228: IS
1229: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(
1230: a.STATUS_CODE, 'PLAN_ROLLUP')
1231: FROM pa_proj_elements a, pa_proj_element_versions b
1232: WHERE a.proj_element_id = b.proj_element_id
1233: AND a.project_id = b.project_id
1234: AND b.element_version_id = c_element_version_id;
1235:

Line 1241: FROM pa_proj_elements a, pa_proj_element_versions b,

1237: --status control is not used anymore
1238: CURSOR get_system_status_code(c_element_version_id NUMBER)
1239: IS
1240: SELECT decode(project_system_status_code, 'CANCELLED', 'N', 'Y')
1241: FROM pa_proj_elements a, pa_proj_element_versions b,
1242: pa_project_statuses c
1243: where a.proj_element_id = b.proj_element_id
1244: and a.project_id = b.project_id
1245: and b.element_version_id = c_element_version_id

Line 1276: from pa_proj_element_versions where element_version_id=cp_str_ver_id) --bug 4287813

1272: FROM pa_proj_elem_ver_structure
1273: WHERE project_id = cp_proj_id
1274: -- AND proj_element_id = p_structure_id
1275: AND element_version_id = ( select parent_structure_version_id
1276: from pa_proj_element_versions where element_version_id=cp_str_ver_id) --bug 4287813
1277: AND status_code <> 'STRUCTURE_PUBLISHED';
1278: chk_str_working_ver_rec chk_str_working_ver%ROWTYPE;
1279:
1280: CURSOR get_parent_task_str_ver(cp_parent_task_ver_id NUMBER) IS

Line 1282: FROM pa_proj_element_versions

1278: chk_str_working_ver_rec chk_str_working_ver%ROWTYPE;
1279:
1280: CURSOR get_parent_task_str_ver(cp_parent_task_ver_id NUMBER) IS
1281: SELECT PARENT_STRUCTURE_VERSION_ID,project_id
1282: FROM pa_proj_element_versions
1283: WHERE element_version_id = cp_parent_task_ver_id;
1284: parent_task_str_ver_id NUMBER;
1285: parent_task_proj_id NUMBER;
1286: --

Line 1373: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1369: ' a.object_type, b.PLANNED_EFFORT, '||
1370: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1371: ' b.scheduled_finish_date, c.object_id_from1, '||
1372: ' c.object_type_from from '||
1373: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1374: ' pa_object_relationships c, pa_proj_elements d where '||
1375: ' a.element_version_id = c.object_id_to1(+) and '||
1376: ' c.relationship_type(+)= '||''''||'S'||''''||' and '||
1377: ' a.project_id = b.project_id and '||

Line 1397: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1393: ' a.object_type, b.PLANNED_EFFORT, '||
1394: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1395: ' b.scheduled_finish_date, c.object_id_from1, '||
1396: ' c.object_type_from from '||
1397: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1398: ' pa_object_relationships c, pa_proj_elements d where '||
1399: ' a.element_version_id = c.object_id_to1 and '||
1400: ' c.relationship_type = '||''''||'S'||''''||' and '||
1401: ' a.project_id = b.project_id and '||

Line 1424: -- ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1420: -- ' a.object_type, b.PLANNED_EFFORT, '||
1421: -- ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1422: -- ' b.scheduled_finish_date, c.object_id_from1, '||
1423: -- ' c.object_type_from from '||
1424: -- ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1425: -- ' pa_object_relationships c where '||
1426: -- ' a.element_version_id = c.object_id_to1(+) and '||
1427: -- ' c.relationship_type(+) = '||''''||'S'||''''||' and '||
1428: -- ' a.project_id = b.project_id and '||

Line 2183: pa_proj_element_versions b,

2179: select a.proj_element_id, a.object_type, b.wbs_level,
2180: decode(d.object_type, 'PA_STRUCTURES', NULL, d.proj_element_id) object_id_from1, decode(d.object_type, 'PA_STRUCTURES', NULL, d.object_type) object_type_from, c.PROJECT_STATUS_WEIGHT,
2181: a.status_code
2182: from pa_proj_elements a,
2183: pa_proj_element_versions b,
2184: pa_project_statuses c,
2185: pa_proj_element_versions d,
2186: pa_object_relationships e
2187: where a.project_id = b.project_id

Line 2185: pa_proj_element_versions d,

2181: a.status_code
2182: from pa_proj_elements a,
2183: pa_proj_element_versions b,
2184: pa_project_statuses c,
2185: pa_proj_element_versions d,
2186: pa_object_relationships e
2187: where a.project_id = b.project_id
2188: and a.proj_element_id = b.proj_element_id
2189: and a.status_code = c.project_status_code

Line 2237: pa_proj_element_versions a,

2233:
2234: CURSOR check_completed_ok(c_element_id NUMBER) IS
2235: select 1
2236: from pa_object_relationships rel,
2237: pa_proj_element_versions a,
2238: pa_proj_element_versions b,
2239: pa_proj_elements ppe,
2240: pa_project_statuses pps
2241: where a.proj_element_id = c_element_id

Line 2238: pa_proj_element_versions b,

2234: CURSOR check_completed_ok(c_element_id NUMBER) IS
2235: select 1
2236: from pa_object_relationships rel,
2237: pa_proj_element_versions a,
2238: pa_proj_element_versions b,
2239: pa_proj_elements ppe,
2240: pa_project_statuses pps
2241: where a.proj_element_id = c_element_id
2242: and a.parent_structure_version_id = p_structure_version_id

Line 2435: pa_proj_element_versions b,

2431: CURSOR get_zero_weight_status IS
2432: select a.project_id, a.proj_element_id,
2433: b.element_version_id, a.status_code
2434: from pa_proj_elements a,
2435: pa_proj_element_versions b,
2436: pa_project_statuses c
2437: where a.project_id = b.project_id
2438: and a.proj_element_id = b.proj_element_id
2439: and b.parent_structure_version_id = p_structure_version_id

Line 2578: FROM pa_proj_element_versions a,

2574: CURSOR cur_select_grid
2575: IS
2576: --select working verisons from versioned projects
2577: SELECT a.project_id, a.element_version_id, a.prg_level
2578: FROM pa_proj_element_versions a,
2579: pa_proj_elem_ver_structure b,
2580: pa_proj_workplan_attr ppwa,
2581: pa_proj_structure_types ppst,
2582: pa_proj_element_versions c

Line 2582: pa_proj_element_versions c

2578: FROM pa_proj_element_versions a,
2579: pa_proj_elem_ver_structure b,
2580: pa_proj_workplan_attr ppwa,
2581: pa_proj_structure_types ppst,
2582: pa_proj_element_versions c
2583: WHERE
2584: c.project_id = p_project_id
2585: AND c.prg_group = a.prg_group
2586: AND a.project_id = b.project_id

Line 2597: FROM pa_proj_element_versions a,

2593: AND ppst.structure_type_id =1
2594: UNION
2595: --select published verisons from non-versioned projects
2596: SELECT a.project_id, a.element_version_id, a.prg_level
2597: FROM pa_proj_element_versions a,
2598: pa_proj_elem_ver_structure b,
2599: pa_proj_workplan_attr ppwa,
2600: pa_proj_structure_types ppst,
2601: pa_proj_element_versions c

Line 2601: pa_proj_element_versions c

2597: FROM pa_proj_element_versions a,
2598: pa_proj_elem_ver_structure b,
2599: pa_proj_workplan_attr ppwa,
2600: pa_proj_structure_types ppst,
2601: pa_proj_element_versions c
2602: WHERE
2603: c.project_id = p_project_id
2604: AND c.prg_group = a.prg_group
2605: AND a.project_id = b.project_id