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 123: pa_object_relationships por,

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,
124: pa_proj_elem_ver_structure pevst
125: --bug 4541039
126: WHERE ppe.project_id = ppev.project_id
127: AND ppe.proj_element_id = ppev.proj_element_id

Line 142: FROM pa_object_relationships

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

Line 156: FROM pa_object_relationships

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

Line 177: FROM pa_object_relationships pora

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
176: AND b.element_version_id IN (SELECT object_id_from1
177: FROM pa_object_relationships pora
178: WHERE object_id_from1 = cp_lnk_task_version_id
179: AND relationship_type = 'S'
180: AND object_id_from2 <> object_id_to2
181: AND object_type_from IN ('PA_STRUCTURES','PA_TASKS') --Bug 3634389

Line 199: FROM pa_object_relationships

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

Line 220: FROM pa_object_relationships pora

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
219: AND b.element_version_id IN (SELECT object_id_from1
220: FROM pa_object_relationships pora
221: WHERE object_id_from1 = cp_lnk_task_version_id
222: AND relationship_type = 'S'
223: AND object_id_from2 <> object_id_to2
224: AND object_type_from IN ('PA_STRUCTURES','PA_TASKS') --Bug 3634389

Line 242: FROM pa_object_relationships

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

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

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 '||
504: ' a.element_version_id = b.element_version_id AND '||

Line 509: ' pa_object_relationships CONNECT BY '||

505: ' a.proj_element_id = d.proj_element_id AND '||
506: -- ' d.link_task_flag = '||''''||'N'||''''||' and '||
507: ' a.element_version_id IN ('||
508: ' SELECT object_id_from1 FROM '||
509: ' pa_object_relationships CONNECT BY '||
510: ' PRIOR object_id_from1 = object_id_to1 '||
511: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
512: ' AND relationship_type = '||''''||'S'||''''||
513: ' START WITH ('||

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

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 '||
528: ' a.element_version_id = b.element_version_id AND '||

Line 534: ' pa_object_relationships CONNECT BY '||

530: -- ' a.element_version_id = d.proj_element_id AND '||
531: --' d.link_task_flag = '||''''||'N'||''''||' AND '||
532: ' c.object_id_from1 IN ('||
533: ' select object_id_from1 FROM '||
534: ' pa_object_relationships CONNECT BY '||
535: ' PRIOR object_id_from1 = object_id_to1 '||
536: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
537: ' AND relationship_type = '||''''||'S'||''''||
538: ' START WITH ('||

Line 1190: from pa_object_relationships a,

1186: -- End of changes
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'

Line 1257: FROM pa_object_relationships pora,

1253: SELECT pora.object_id_from1 parent_lnk_task_ver_id,
1254: pora.object_id_to1 struct_version_id,
1255: pora.object_id_from2 parent_proj_id,
1256: porb.object_id_from1 parent_task_ver_id
1257: FROM pa_object_relationships pora,
1258: pa_object_relationships porb
1259: WHERE pora.object_id_to1 = cp_structure_Version_id
1260: AND pora.RELATIONSHIP_TYPE = 'LW'
1261: AND pora.object_id_from2 <> pora.object_id_to2

Line 1258: pa_object_relationships porb

1254: pora.object_id_to1 struct_version_id,
1255: pora.object_id_from2 parent_proj_id,
1256: porb.object_id_from1 parent_task_ver_id
1257: FROM pa_object_relationships pora,
1258: pa_object_relationships porb
1259: WHERE pora.object_id_to1 = cp_structure_Version_id
1260: AND pora.RELATIONSHIP_TYPE = 'LW'
1261: AND pora.object_id_from2 <> pora.object_id_to2
1262: AND pora.OBJECT_TYPE_TO = 'PA_STRUCTURES'

Line 1314: FROM pa_object_relationships

1310: --in order to propagate the schedule dates upto the top of the hierarchy.
1311: CURSOR cur_select_hier(c_project_id NUMBER, c_structure_version_id NUMBER)
1312: IS
1313: SELECT object_id_from1, object_id_from2, object_id_to1, object_id_to2
1314: FROM pa_object_relationships
1315: START with object_id_to2 = c_project_id and relationship_type = 'LW' and object_id_to1 = c_structure_version_id
1316: CONNECT by object_id_to2 = prior object_id_from2
1317: AND relationship_type = prior relationship_type;
1318: l_rollup_from_sub_project VARCHAR2(1);

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

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 '||
1378: ' a.element_version_id = b.element_version_id and '||

Line 1383: ' pa_object_relationships connect by '||

1379: ' a.proj_element_id = d.proj_element_id and '|| -- 3305199
1380: ' d.link_task_flag = '||''''||'N'||''''||' and '||
1381: ' a.element_version_id IN ('||
1382: ' select object_id_from1 from '||
1383: ' pa_object_relationships connect by '||
1384: ' prior object_id_from1 = object_id_to1 '||
1385: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
1386: ' and relationship_type = '||''''||'S'||''''||
1387: ' start with object_id_to1 IN ('||

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

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 '||
1402: ' a.element_version_id = b.element_version_id and '||

Line 1408: ' pa_object_relationships connect by '||

1404: -- ' a.element_version_id = d.proj_element_id and '||
1405: ' d.link_task_flag = '||''''||'N'||''''||' and '||
1406: ' c.object_id_from1 IN ('||
1407: ' select object_id_from1 from '||
1408: ' pa_object_relationships connect by '||
1409: ' prior object_id_from1 = object_id_to1 '||
1410: ' and relationship_type = '||''''||'S'||''''||
1411: ' AND RELATIONSHIP_TYPE = prior relationship_type '||
1412: ' start with object_id_to1 IN ('||

Line 1425: -- ' pa_object_relationships c 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 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 2186: pa_object_relationships e

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
2190: and b.element_version_id = e.object_id_to1

Line 2197: from pa_object_relationships

2193: and d.object_type = e.object_type_from
2194: and e.relationship_type = 'S'
2195: and b.element_version_id IN
2196: ( select object_id_to1
2197: from pa_object_relationships
2198: where relationship_type = 'S'
2199: and 1 = c_input
2200: start with object_id_from1 = p_structure_version_id
2201: and object_type_from = 'PA_STRUCTURES'

Line 2208: from pa_object_relationships

2204: AND RELATIONSHIP_TYPE = prior relationship_type
2205: and prior object_type_to = object_type_from
2206: UNION
2207: select object_id_to1
2208: from pa_object_relationships
2209: where relationship_type = 'S'
2210: and 2 = c_input
2211: and object_id_from1 IN
2212: ( select object_id_from1

Line 2213: from pa_object_relationships

2209: where relationship_type = 'S'
2210: and 2 = c_input
2211: and object_id_from1 IN
2212: ( select object_id_from1
2213: from pa_object_relationships
2214: where relationship_type = 'S'
2215: start with object_id_to1 = p_element_version_id
2216: and object_type_to = 'PA_TASKS'
2217: and relationship_type = 'S'

Line 2236: from pa_object_relationships rel,

2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
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

Line 2562: FROM pa_object_relationships

2558: ) IS
2559: CURSOR cur_top_task(c_structure_version_id NUMBER)
2560: IS
2561: SELECT object_id_to1
2562: FROM pa_object_relationships
2563: WHERE object_id_from1 = c_structure_version_id
2564: AND relationship_type = 'S'
2565: AND object_type_from = 'PA_STRUCTURES'
2566: AND object_type_to = 'PA_TASKS'