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_PROJ_STRUCTURE_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 665: FROM pa_object_relationships

661: SELECT 'Y'
662: FROM DUAL
663: WHERE EXISTS
664: (SELECT 1
665: FROM pa_object_relationships
666: WHERE relationship_type='D');
667:
668: CURSOR C3(c_ci_type VARCHAR2)
669: IS

Line 1531: ,pa_object_relationships por

1527: ,pa_proj_element_versions ppv2
1528: ,pa_tasks pt
1529: ,pa_proj_elements ppe
1530: ,pa_proj_element_versions ppv
1531: ,pa_object_relationships por
1532: ,pa_proj_elements ppeph
1533: ,pa_proj_element_versions ppevph
1534: ,pji_fm_xbs_accum_tmp1 pfxat
1535: WHERE

Line 2108: ,pa_object_relationships por

2104: ,pa_proj_element_versions ppv2
2105: ,pa_tasks pt
2106: ,pa_proj_elements ppe
2107: ,pa_proj_element_versions ppv
2108: ,pa_object_relationships por
2109: ,pa_proj_elements ppeph
2110: ,pa_proj_element_versions ppevph
2111: ,pji_fm_xbs_accum_tmp1 pfxat
2112: WHERE

Line 2930: ,pa_object_relationships por

2926: ,pa_proj_element_versions ppv2
2927: ,pa_tasks pt
2928: ,pa_proj_elements ppe
2929: ,pa_proj_element_versions ppv
2930: ,pa_object_relationships por
2931: ,pa_proj_elements ppeph
2932: ,pa_proj_element_versions ppevph
2933: ,pji_fm_xbs_accum_tmp1 pfxat
2934: WHERE

Line 3510: ,pa_object_relationships por

3506: ,pa_proj_element_versions ppv2
3507: ,pa_tasks pt
3508: ,pa_proj_elements ppe
3509: ,pa_proj_element_versions ppv
3510: ,pa_object_relationships por
3511: ,pa_proj_elements ppeph
3512: ,pa_proj_element_versions ppevph
3513: ,pji_fm_xbs_accum_tmp1 pfxat
3514: WHERE

Line 4380: ,pa_object_relationships por

4376: ,pa_proj_element_versions ppv2
4377: ,pa_tasks pt
4378: ,pa_proj_elements ppe
4379: ,pa_proj_element_versions ppv
4380: ,pa_object_relationships por
4381: ,pa_proj_elements ppeph
4382: ,pa_proj_element_versions ppevph
4383: ,pji_fm_xbs_accum_tmp1 pfxat
4384: WHERE

Line 4955: ,pa_object_relationships por

4951: ,pa_proj_element_versions ppv2
4952: ,pa_tasks pt
4953: ,pa_proj_elements ppe
4954: ,pa_proj_element_versions ppv
4955: ,pa_object_relationships por
4956: ,pa_proj_elements ppeph
4957: ,pa_proj_element_versions ppevph
4958: ,pji_fm_xbs_accum_tmp1 pfxat
4959: WHERE

Line 5986: ,pa_object_relationships por

5982: ,pa_proj_element_versions ppv2
5983: ,pa_tasks pt
5984: ,pa_proj_elements ppe
5985: ,pa_proj_element_versions ppv
5986: ,pa_object_relationships por
5987: ,pa_proj_elements ppeph
5988: ,pa_proj_element_versions ppevph
5989: ,pji_fm_xbs_accum_tmp1 pfxat
5990: WHERE

Line 6812: ,pa_object_relationships por

6808: ,pa_proj_element_versions ppv2
6809: ,pa_tasks pt
6810: ,pa_proj_elements ppe
6811: ,pa_proj_element_versions ppv
6812: ,pa_object_relationships por
6813: ,pa_proj_elements ppeph
6814: ,pa_proj_element_versions ppevph
6815: ,pji_fm_xbs_accum_tmp1 pfxat
6816: WHERE

Line 7639: ,pa_object_relationships por

7635: ,pa_proj_element_versions ppv2
7636: ,pa_tasks pt
7637: ,pa_proj_elements ppe
7638: ,pa_proj_element_versions ppv
7639: ,pa_object_relationships por
7640: ,pa_proj_elements ppeph
7641: ,pa_proj_element_versions ppevph
7642: ,pji_fm_xbs_accum_tmp1 pfxat
7643: WHERE

Line 7793: from pa_object_relationships por1

7789:
7790: cursor get_structures IS
7791: select por1.object_id_to1, por1.object_id_to2
7792: ,display_sequence, por1.object_id_from2 --bug 4448499
7793: from pa_object_relationships por1
7794: ,pa_proj_element_versions ppv --bug 4448499
7795: where por1.relationship_type = 'LW'
7796: and ppv.element_version_id = por1.object_id_from1 --bug 4448499
7797: and por1.object_id_from1 IN (SELECT ppevs.element_version_id

Line 7815: pa_object_relationships b

7811: CURSOR cur_get_parent_disp( c_subproject_id NUMBER, c_subproj_struc_ver_id NUMBER )
7812: IS
7813: SELECT a.display_sequence
7814: FROM pa_structures_tasks_tmp a,
7815: pa_object_relationships b
7816: WHERE b.object_id_to1=c_subproj_struc_ver_id
7817: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
7818: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
7819: AND b.relationship_type = 'S'

Line 7884: from pa_object_relationships por1

7880: -- re-populated in the context of the currently accessed parent project.
7881:
7882: delete from pa_structures_tasks_tmp pstt
7883: where pstt.project_id in (select por1.object_id_to2
7884: from pa_object_relationships por1
7885: ,pa_proj_element_versions ppv
7886: where por1.relationship_type = 'LW'
7887: and ppv.element_version_id = por1.object_id_from1
7888: and por1.object_id_from1 IN (SELECT ppevs.element_version_id

Line 8568: ,pa_object_relationships por

8564: ,pa_proj_element_versions ppv2
8565: ,pa_proj_elements ppe
8566: ,pa_proj_element_versions ppv3
8567: ,pa_proj_element_versions ppv1
8568: ,pa_object_relationships por
8569: ,pa_object_relationships por2
8570: ,pji_fm_xbs_accum_tmp1 pfxat
8571: ----,pa_percent_completes ppc
8572: ,pa_progress_rollup ppru

Line 8569: ,pa_object_relationships por2

8565: ,pa_proj_elements ppe
8566: ,pa_proj_element_versions ppv3
8567: ,pa_proj_element_versions ppv1
8568: ,pa_object_relationships por
8569: ,pa_object_relationships por2
8570: ,pji_fm_xbs_accum_tmp1 pfxat
8571: ----,pa_percent_completes ppc
8572: ,pa_progress_rollup ppru
8573: ,pa_proj_progress_attr pppa

Line 9059: ,pa_object_relationships por

9055: ,pa_proj_element_versions ppv2
9056: ,pa_proj_elements ppe
9057: ,pa_proj_element_versions ppv3
9058: ,pa_proj_element_versions ppv1
9059: ,pa_object_relationships por
9060: ,pa_object_relationships por2
9061: ,pji_fm_xbs_accum_tmp1 pfxat
9062: ----,pa_percent_completes ppc
9063: ,pa_progress_rollup ppru

Line 9060: ,pa_object_relationships por2

9056: ,pa_proj_elements ppe
9057: ,pa_proj_element_versions ppv3
9058: ,pa_proj_element_versions ppv1
9059: ,pa_object_relationships por
9060: ,pa_object_relationships por2
9061: ,pji_fm_xbs_accum_tmp1 pfxat
9062: ----,pa_percent_completes ppc
9063: ,pa_progress_rollup ppru
9064: ,pa_proj_progress_attr pppa

Line 9567: ,pa_object_relationships por

9563: ,pa_proj_element_versions ppv2
9564: ,pa_proj_elements ppe
9565: ,pa_proj_element_versions ppv3
9566: ,pa_proj_element_versions ppv1
9567: ,pa_object_relationships por
9568: ,pa_object_relationships por2
9569: ,pji_fm_xbs_accum_tmp1 pfxat
9570: ----,pa_percent_completes ppc
9571: ,pa_progress_rollup ppru

Line 9568: ,pa_object_relationships por2

9564: ,pa_proj_elements ppe
9565: ,pa_proj_element_versions ppv3
9566: ,pa_proj_element_versions ppv1
9567: ,pa_object_relationships por
9568: ,pa_object_relationships por2
9569: ,pji_fm_xbs_accum_tmp1 pfxat
9570: ----,pa_percent_completes ppc
9571: ,pa_progress_rollup ppru
9572: ,pa_proj_progress_attr pppa

Line 10410: ,pa_object_relationships por

10406: ,pa_proj_element_versions ppv2
10407: ,pa_tasks pt
10408: ,pa_proj_elements ppe
10409: ,pa_proj_element_versions ppv
10410: ,pa_object_relationships por
10411: ,pa_proj_elements ppeph
10412: ,pa_proj_element_versions ppevph
10413: --,pji_fm_xbs_accum_tmp1 pfxat
10414: WHERE

Line 11170: ,pa_object_relationships por

11166: ,pa_proj_element_versions ppv2
11167: ,pa_tasks pt
11168: ,pa_proj_elements ppe
11169: ,pa_proj_element_versions ppv
11170: ,pa_object_relationships por
11171: ,pa_proj_elements ppeph
11172: ,pa_proj_element_versions ppevph
11173: --,pji_fm_xbs_accum_tmp1 pfxat
11174: WHERE

Line 12120: ,pa_object_relationships por

12116: ,pa_task_types tt
12117: ,pa_tasks pt
12118: ,pa_proj_elements ppe
12119: ,pa_proj_element_versions ppv
12120: ,pa_object_relationships por
12121: ,pji_fm_xbs_accum_tmp1 pfxat
12122: WHERE
12123: ppe.proj_element_id = ppv.proj_element_id
12124: AND ppe.project_id = ppv.project_id

Line 12948: ,pa_object_relationships por

12944: ,pa_task_types tt
12945: ,pa_tasks pt
12946: ,pa_proj_elements ppe
12947: ,pa_proj_element_versions ppv
12948: ,pa_object_relationships por
12949: ,pji_fm_xbs_accum_tmp1 pfxat
12950: WHERE
12951: ppe.proj_element_id = ppv.proj_element_id
12952: AND ppe.project_id = ppv.project_id

Line 13777: ,pa_object_relationships por

13773: ,pa_task_types tt
13774: ,pa_tasks pt
13775: ,pa_proj_elements ppe
13776: ,pa_proj_element_versions ppv
13777: ,pa_object_relationships por
13778: ,pji_fm_xbs_accum_tmp1 pfxat
13779: WHERE
13780: ppe.proj_element_id = ppv.proj_element_id
13781: AND ppe.project_id = ppv.project_id

Line 14702: ,pa_object_relationships por

14698: ,pa_task_types tt
14699: ,pa_tasks pt
14700: ,pa_proj_elements ppe
14701: ,pa_proj_element_versions ppv
14702: ,pa_object_relationships por
14703: ,pji_fm_xbs_accum_tmp1 pfxat
14704: WHERE
14705: ppe.proj_element_id = ppv.proj_element_id
14706: AND ppe.project_id = ppv.project_id

Line 15499: ,pa_object_relationships por

15495: ,pa_task_types tt
15496: ,pa_tasks pt
15497: ,pa_proj_elements ppe
15498: ,pa_proj_element_versions ppv
15499: ,pa_object_relationships por
15500: ,pji_fm_xbs_accum_tmp1 pfxat
15501: WHERE
15502: ppe.proj_element_id = ppv.proj_element_id
15503: AND ppe.project_id = ppv.project_id

Line 16297: ,pa_object_relationships por

16293: ,pa_task_types tt
16294: ,pa_tasks pt
16295: ,pa_proj_elements ppe
16296: ,pa_proj_element_versions ppv
16297: ,pa_object_relationships por
16298: ,pji_fm_xbs_accum_tmp1 pfxat
16299: WHERE
16300: ppe.proj_element_id = ppv.proj_element_id
16301: AND ppe.project_id = ppv.project_id