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_OBJECT_RELATIONSHIPS

Line 125: pa_object_relationships por,

121: FROM pa_proj_element_versions ppev,
122: pa_proj_elements ppe,
123: pa_proj_elem_ver_schedule pevs,
124: --bug 4541039
125: pa_object_relationships por,
126: pa_proj_elem_ver_structure pevst
127: --bug 4541039
128: WHERE ppe.project_id = ppev.project_id
129: AND ppe.proj_element_id = ppev.proj_element_id

Line 144: FROM pa_object_relationships

140: and pevst.project_id = por.object_id_to2
141: --bug 4541039
142: AND ppev.element_version_id IN (
143: SELECT object_id_to1
144: FROM pa_object_relationships
145: WHERE relationship_type = 'S'
146: START WITH object_id_from1 = cp_task_version_id
147: AND object_type_from IN ('PA_TASKS','PA_STRUCTURES')
148: AND relationship_type = 'S'

Line 158: FROM pa_object_relationships

154: --Getting linking relationship details.
155: CURSOR get_lnk_task_rel_det(cp_lnk_task_version_id NUMBER) IS
156: Select object_id_from1 lnk_task_ver_id,object_id_to1 struct_version_id,
157: object_id_from2 lnk_proj_id_from,object_id_to2 lnk_proj_id_to --Bug 3634389
158: FROM pa_object_relationships
159: WHERE object_id_from1 = cp_lnk_task_version_id
160: AND relationship_type = 'LW'
161: AND object_id_from2 <> object_id_to2
162: AND object_type_from = 'PA_TASKS' --Bug 3634389

Line 179: FROM pa_object_relationships pora

175: WHERE a.project_id = b.project_id
176: AND a.element_version_id = b.element_version_id
177: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance
178: AND b.element_version_id IN (SELECT object_id_from1
179: FROM pa_object_relationships pora
180: WHERE object_id_from1 = cp_lnk_task_version_id
181: AND relationship_type = 'S'
182: AND object_id_from2 <> object_id_to2
183: AND object_type_from IN ('PA_STRUCTURES','PA_TASKS') --Bug 3634389

Line 202: FROM pa_object_relationships

198: AND e.project_id = c.project_id -- Bug # 4868867.
199: AND e.status_code = 'STRUCTURE_PUBLISHED'
200: --end bug 4541039
201: AND c.element_version_id IN (SELECT object_id_to1
202: FROM pa_object_relationships
203: WHERE object_id_from1 = cp_lnk_task_version_id
204: AND relationship_type = 'LW'
205: AND object_id_from2 <> object_id_to2
206: AND object_type_from = 'PA_TASKS' --Bug 3634389

Line 223: FROM pa_object_relationships pora

219: WHERE a.project_id = b.project_id
220: AND a.element_version_id = b.element_version_id
221: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance
222: AND b.element_version_id IN (SELECT object_id_from1
223: FROM pa_object_relationships pora
224: WHERE object_id_from1 = cp_lnk_task_version_id
225: AND relationship_type = 'S'
226: AND object_id_from2 <> object_id_to2
227: AND object_type_from IN ('PA_STRUCTURES','PA_TASKS') --Bug 3634389

Line 245: FROM pa_object_relationships

241: and e.project_id = c.project_id -- Bug # 4868867.
242: AND e.status_code = 'STRUCTURE_PUBLISHED'
243: --end bug 4541039
244: AND c.element_version_id IN (SELECT object_id_to1
245: FROM pa_object_relationships
246: WHERE object_id_from1 = cp_lnk_task_version_id
247: AND relationship_type = 'LW'
248: AND object_id_from2 <> object_id_to2
249: AND object_type_from = 'PA_TASKS' --Bug 3634389

Line 528: ' pa_object_relationships c, pa_proj_elements d WHERE '||

524: ' NVL(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
525: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
526: ' c.object_type_from FROM '||
527: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
528: ' pa_object_relationships c, pa_proj_elements d WHERE '||
529: ' a.element_version_id = c.object_id_to1(+) AND '||
530: ' c.relationship_type(+)= '||''''||'S'||''''||' AND '||
531: ' a.project_id = b.project_id AND '||
532: ' a.element_version_id = b.element_version_id AND '||

Line 537: ' pa_object_relationships CONNECT BY '||

533: ' a.proj_element_id = d.proj_element_id AND '||
534: -- ' d.link_task_flag = '||''''||'N'||''''||' and '||
535: ' a.element_version_id IN ('||
536: ' SELECT object_id_from1 FROM '||
537: ' pa_object_relationships CONNECT BY '||
538: ' PRIOR object_id_from1 = object_id_to1 '||
539: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
540: ' AND relationship_type = '||''''||'S'||''''||
541: ' START WITH ('||

Line 552: ' pa_object_relationships c, pa_proj_elements d WHERE '||

548: ' nvl(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
549: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
550: ' c.object_type_from FROM '||
551: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
552: ' pa_object_relationships c, pa_proj_elements d WHERE '||
553: ' a.element_version_id = c.object_id_to1 AND '||
554: ' c.relationship_type = '||''''||'S'||''''||' AND '||
555: ' a.project_id = b.project_id AND '||
556: ' a.element_version_id = b.element_version_id AND '||

Line 562: ' pa_object_relationships CONNECT BY '||

558: -- ' a.element_version_id = d.proj_element_id AND '||
559: --' d.link_task_flag = '||''''||'N'||''''||' AND '||
560: ' c.object_id_from1 IN ('||
561: ' select object_id_from1 FROM '||
562: ' pa_object_relationships CONNECT BY '||
563: ' PRIOR object_id_from1 = object_id_to1 '||
564: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
565: ' AND relationship_type = '||''''||'S'||''''||
566: ' START WITH ('||

Line 1237: from pa_object_relationships a,

1233: -- End of changes
1234:
1235: cursor c1(c_child_element_id NUMBER) IS
1236: select b.project_id, b.element_version_id
1237: from pa_object_relationships a,
1238: pa_proj_element_versions b
1239: where a.relationship_type = 'L'
1240: and a.object_id_to1 = c_child_element_id
1241: and a.object_type_from = 'PA_TASKS'

Line 1304: FROM pa_object_relationships pora,

1300: SELECT pora.object_id_from1 parent_lnk_task_ver_id,
1301: pora.object_id_to1 struct_version_id,
1302: pora.object_id_from2 parent_proj_id,
1303: porb.object_id_from1 parent_task_ver_id
1304: FROM pa_object_relationships pora,
1305: pa_object_relationships porb
1306: WHERE pora.object_id_to1 = cp_structure_Version_id
1307: AND pora.RELATIONSHIP_TYPE = 'LW'
1308: AND pora.object_id_from2 <> pora.object_id_to2

Line 1305: pa_object_relationships porb

1301: pora.object_id_to1 struct_version_id,
1302: pora.object_id_from2 parent_proj_id,
1303: porb.object_id_from1 parent_task_ver_id
1304: FROM pa_object_relationships pora,
1305: pa_object_relationships porb
1306: WHERE pora.object_id_to1 = cp_structure_Version_id
1307: AND pora.RELATIONSHIP_TYPE = 'LW'
1308: AND pora.object_id_from2 <> pora.object_id_to2
1309: AND pora.OBJECT_TYPE_TO = 'PA_STRUCTURES'

Line 1361: FROM pa_object_relationships

1357: --in order to propagate the schedule dates upto the top of the hierarchy.
1358: CURSOR cur_select_hier(c_project_id NUMBER, c_structure_version_id NUMBER)
1359: IS
1360: SELECT object_id_from1, object_id_from2, object_id_to1, object_id_to2
1361: FROM pa_object_relationships
1362: START with object_id_to2 = c_project_id and relationship_type = 'LW' and object_id_to1 = c_structure_version_id
1363: CONNECT by object_id_to2 = prior object_id_from2
1364: AND relationship_type = prior relationship_type;
1365: l_rollup_from_sub_project VARCHAR2(1);

Line 1425: ' pa_object_relationships c, pa_proj_elements d where '||

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, pa_proj_elements d 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 '||
1429: ' a.element_version_id = b.element_version_id and '||

Line 1434: ' pa_object_relationships where '||

1430: ' a.proj_element_id = d.proj_element_id and '||
1431: ' d.link_task_flag = '||''''||'N'||''''||' and '||
1432: ' c.object_id_to1 IN ('||
1433: ' SELECT decode(object_type_from,'||''''||'PA_TASKS'||''''||',object_id_from1,object_id_to1) from '||
1434: ' pa_object_relationships where '||
1435: ' object_id_to1 IN ('||
1436: l_predicate||
1437: ')' ||
1438: ' and relationship_type = '||''''||'S'||''''||

Line 1448: ' pa_object_relationships c, pa_proj_elements d where '||

1444: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1445: ' b.scheduled_finish_date, c.object_id_from1, '||
1446: ' c.object_type_from from '||
1447: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1448: ' pa_object_relationships c, pa_proj_elements d where '||
1449: ' a.element_version_id = c.object_id_to1(+) and '||
1450: ' c.relationship_type(+)= '||''''||'S'||''''||' and '||
1451: ' a.project_id = b.project_id and '||
1452: ' a.element_version_id = b.element_version_id and '||

Line 1457: ' pa_object_relationships connect by '||

1453: ' a.proj_element_id = d.proj_element_id and '|| -- 3305199
1454: ' d.link_task_flag = '||''''||'N'||''''||' and '||
1455: ' a.element_version_id IN ('||
1456: ' select object_id_from1 from '||
1457: ' pa_object_relationships connect by '||
1458: ' prior object_id_from1 = object_id_to1 '||
1459: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
1460: ' and relationship_type = '||''''||'S'||''''||
1461: ' start with object_id_to1 IN ('||

Line 1472: ' pa_object_relationships c, pa_proj_elements d where '||

1468: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1469: ' b.scheduled_finish_date, c.object_id_from1, '||
1470: ' c.object_type_from from '||
1471: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1472: ' pa_object_relationships c, pa_proj_elements d where '||
1473: ' a.element_version_id = c.object_id_to1 and '||
1474: ' c.relationship_type = '||''''||'S'||''''||' and '||
1475: ' a.project_id = b.project_id and '||
1476: ' a.element_version_id = b.element_version_id and '||

Line 1482: ' pa_object_relationships connect by '||

1478: -- ' a.element_version_id = d.proj_element_id and '||
1479: ' d.link_task_flag = '||''''||'N'||''''||' and '||
1480: ' c.object_id_from1 IN ('||
1481: ' select object_id_from1 from '||
1482: ' pa_object_relationships connect by '||
1483: ' prior object_id_from1 = object_id_to1 '||
1484: ' and relationship_type = '||''''||'S'||''''||
1485: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
1486: ' start with object_id_to1 IN ('||

Line 1499: -- ' pa_object_relationships c where '||

1495: -- ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1496: -- ' b.scheduled_finish_date, c.object_id_from1, '||
1497: -- ' c.object_type_from from '||
1498: -- ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1499: -- ' pa_object_relationships c where '||
1500: -- ' a.element_version_id = c.object_id_to1(+) and '||
1501: -- ' c.relationship_type(+) = '||''''||'S'||''''||' and '||
1502: -- ' a.project_id = b.project_id and '||
1503: -- ' a.element_version_id = b.element_version_id and '||

Line 2274: pa_object_relationships e

2270: from pa_proj_elements a,
2271: pa_proj_element_versions b,
2272: pa_project_statuses c,
2273: pa_proj_element_versions d,
2274: pa_object_relationships e
2275: where a.project_id = b.project_id
2276: and a.proj_element_id = b.proj_element_id
2277: and a.status_code = c.project_status_code
2278: and b.element_version_id = e.object_id_to1

Line 2285: from pa_object_relationships

2281: and d.object_type = e.object_type_from
2282: and e.relationship_type = 'S'
2283: and b.element_version_id IN
2284: ( select object_id_to1
2285: from pa_object_relationships
2286: where relationship_type = 'S'
2287: and 1 = c_input
2288: start with object_id_from1 = p_structure_version_id
2289: and object_type_from = 'PA_STRUCTURES'

Line 2296: from pa_object_relationships

2292: AND RELATIONSHIP_TYPE = prior relationship_type
2293: and prior object_type_to = object_type_from
2294: UNION
2295: select object_id_to1
2296: from pa_object_relationships
2297: where relationship_type = 'S'
2298: and 2 = c_input
2299: and object_id_from1 IN
2300: ( select object_id_from1

Line 2301: from pa_object_relationships

2297: where relationship_type = 'S'
2298: and 2 = c_input
2299: and object_id_from1 IN
2300: ( select object_id_from1
2301: from pa_object_relationships
2302: where relationship_type = 'S'
2303: start with object_id_to1 = p_element_version_id
2304: and object_type_to = 'PA_TASKS'
2305: and relationship_type = 'S'

Line 2320: pa_object_relationships e

2316: from pa_proj_elements a,
2317: pa_proj_element_versions b,
2318: pa_project_statuses c,
2319: pa_proj_element_versions d,
2320: pa_object_relationships e
2321: where a.project_id = b.project_id
2322: and a.proj_element_id = b.proj_element_id
2323: and a.status_code = c.project_status_code
2324: and b.element_version_id = e.object_id_to1

Line 2331: from pa_object_relationships

2327: and d.object_type = e.object_type_from
2328: and e.relationship_type = 'S'
2329: and b.element_version_id IN
2330: ( select object_id_to1
2331: from pa_object_relationships
2332: where relationship_type = 'S'
2333: and object_id_to1 IN
2334: ( select object_id_to1
2335: from pa_object_relationships

Line 2335: from pa_object_relationships

2331: from pa_object_relationships
2332: where relationship_type = 'S'
2333: and object_id_to1 IN
2334: ( select object_id_to1
2335: from pa_object_relationships
2336: where relationship_type = 'S'
2337: start with object_id_to1 = p_element_version_id
2338: and object_type_to = 'PA_TASKS'
2339: and relationship_type = 'S'

Line 2358: from pa_object_relationships rel,

2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2355:
2356: CURSOR check_completed_ok(c_element_id NUMBER) IS
2357: select 1
2358: from pa_object_relationships rel,
2359: pa_proj_element_versions a,
2360: pa_proj_element_versions b,
2361: pa_proj_elements ppe,
2362: pa_project_statuses pps

Line 2717: FROM pa_object_relationships

2713: ) IS
2714: CURSOR cur_top_task(c_structure_version_id NUMBER)
2715: IS
2716: SELECT object_id_to1
2717: FROM pa_object_relationships
2718: WHERE object_id_from1 = c_structure_version_id
2719: AND relationship_type = 'S'
2720: AND object_type_from = 'PA_STRUCTURES'
2721: AND object_type_to = 'PA_TASKS'