1519: -----,pa_percent_completes ppc
1520: ,pa_project_statuses pps
1521: ,pa_project_statuses pps5
1522: ,pa_proj_elements ppe5
1523: ,pa_proj_element_versions ppv5
1524: ,pa_proj_workplan_attr ppwa
1525: ,pa_proj_element_versions ppev6
1526: ,pa_proj_progress_attr pppa
1527: ,pa_proj_element_versions ppv2
1521: ,pa_project_statuses pps5
1522: ,pa_proj_elements ppe5
1523: ,pa_proj_element_versions ppv5
1524: ,pa_proj_workplan_attr ppwa
1525: ,pa_proj_element_versions ppev6
1526: ,pa_proj_progress_attr pppa
1527: ,pa_proj_element_versions ppv2
1528: ,pa_tasks pt
1529: ,pa_proj_elements ppe
1523: ,pa_proj_element_versions ppv5
1524: ,pa_proj_workplan_attr ppwa
1525: ,pa_proj_element_versions ppev6
1526: ,pa_proj_progress_attr pppa
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
1526: ,pa_proj_progress_attr pppa
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
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
1536: ppe.proj_element_id = ppv.proj_element_id
1537: AND ppv.parent_structure_version_id = ppvs.element_version_id
2096: -----,pa_percent_completes ppc
2097: ,pa_project_statuses pps
2098: ,pa_project_statuses pps5
2099: ,pa_proj_elements ppe5
2100: ,pa_proj_element_versions ppv5
2101: ,pa_proj_workplan_attr ppwa
2102: ,pa_proj_element_versions ppev6
2103: ,pa_proj_progress_attr pppa
2104: ,pa_proj_element_versions ppv2
2098: ,pa_project_statuses pps5
2099: ,pa_proj_elements ppe5
2100: ,pa_proj_element_versions ppv5
2101: ,pa_proj_workplan_attr ppwa
2102: ,pa_proj_element_versions ppev6
2103: ,pa_proj_progress_attr pppa
2104: ,pa_proj_element_versions ppv2
2105: ,pa_tasks pt
2106: ,pa_proj_elements ppe
2100: ,pa_proj_element_versions ppv5
2101: ,pa_proj_workplan_attr ppwa
2102: ,pa_proj_element_versions ppev6
2103: ,pa_proj_progress_attr pppa
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
2103: ,pa_proj_progress_attr pppa
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
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
2113: ppe.proj_element_id = ppv.proj_element_id
2114: AND ppv.parent_structure_version_id = ppvs.element_version_id
2918: -----,pa_percent_completes ppc Bug 5580992
2919: ,pa_project_statuses pps
2920: ,pa_project_statuses pps5
2921: ,pa_proj_elements ppe5
2922: ,pa_proj_element_versions ppv5
2923: ,pa_proj_workplan_attr ppwa
2924: ,pa_proj_element_versions ppev6
2925: ,pa_proj_progress_attr pppa
2926: ,pa_proj_element_versions ppv2
2920: ,pa_project_statuses pps5
2921: ,pa_proj_elements ppe5
2922: ,pa_proj_element_versions ppv5
2923: ,pa_proj_workplan_attr ppwa
2924: ,pa_proj_element_versions ppev6
2925: ,pa_proj_progress_attr pppa
2926: ,pa_proj_element_versions ppv2
2927: ,pa_tasks pt
2928: ,pa_proj_elements ppe
2922: ,pa_proj_element_versions ppv5
2923: ,pa_proj_workplan_attr ppwa
2924: ,pa_proj_element_versions ppev6
2925: ,pa_proj_progress_attr pppa
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
2925: ,pa_proj_progress_attr pppa
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
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
2935: ppe.proj_element_id = ppv.proj_element_id
2936: AND ppv.parent_structure_version_id = ppvs.element_version_id
3498: -----,pa_percent_completes ppc Bug 5580992
3499: ,pa_project_statuses pps
3500: ,pa_project_statuses pps5
3501: ,pa_proj_elements ppe5
3502: ,pa_proj_element_versions ppv5
3503: ,pa_proj_workplan_attr ppwa
3504: ,pa_proj_element_versions ppev6
3505: ,pa_proj_progress_attr pppa
3506: ,pa_proj_element_versions ppv2
3500: ,pa_project_statuses pps5
3501: ,pa_proj_elements ppe5
3502: ,pa_proj_element_versions ppv5
3503: ,pa_proj_workplan_attr ppwa
3504: ,pa_proj_element_versions ppev6
3505: ,pa_proj_progress_attr pppa
3506: ,pa_proj_element_versions ppv2
3507: ,pa_tasks pt
3508: ,pa_proj_elements ppe
3502: ,pa_proj_element_versions ppv5
3503: ,pa_proj_workplan_attr ppwa
3504: ,pa_proj_element_versions ppev6
3505: ,pa_proj_progress_attr pppa
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
3505: ,pa_proj_progress_attr pppa
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
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
3515: ppe.proj_element_id = ppv.proj_element_id
3516: AND ppv.parent_structure_version_id = ppvs.element_version_id
4368: -----,pa_percent_completes ppc
4369: ,pa_project_statuses pps
4370: ,pa_project_statuses pps5
4371: ,pa_proj_elements ppe5
4372: ,pa_proj_element_versions ppv5
4373: ,pa_proj_workplan_attr ppwa
4374: ,pa_proj_element_versions ppev6
4375: ,pa_proj_progress_attr pppa
4376: ,pa_proj_element_versions ppv2
4370: ,pa_project_statuses pps5
4371: ,pa_proj_elements ppe5
4372: ,pa_proj_element_versions ppv5
4373: ,pa_proj_workplan_attr ppwa
4374: ,pa_proj_element_versions ppev6
4375: ,pa_proj_progress_attr pppa
4376: ,pa_proj_element_versions ppv2
4377: ,pa_tasks pt
4378: ,pa_proj_elements ppe
4372: ,pa_proj_element_versions ppv5
4373: ,pa_proj_workplan_attr ppwa
4374: ,pa_proj_element_versions ppev6
4375: ,pa_proj_progress_attr pppa
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
4375: ,pa_proj_progress_attr pppa
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
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
4385: ppe.proj_element_id = ppv.proj_element_id
4386: AND ppv.parent_structure_version_id = ppvs.element_version_id
4943: -----,pa_percent_completes ppc
4944: ,pa_project_statuses pps
4945: ,pa_project_statuses pps5
4946: ,pa_proj_elements ppe5
4947: ,pa_proj_element_versions ppv5
4948: ,pa_proj_workplan_attr ppwa
4949: ,pa_proj_element_versions ppev6
4950: ,pa_proj_progress_attr pppa
4951: ,pa_proj_element_versions ppv2
4945: ,pa_project_statuses pps5
4946: ,pa_proj_elements ppe5
4947: ,pa_proj_element_versions ppv5
4948: ,pa_proj_workplan_attr ppwa
4949: ,pa_proj_element_versions ppev6
4950: ,pa_proj_progress_attr pppa
4951: ,pa_proj_element_versions ppv2
4952: ,pa_tasks pt
4953: ,pa_proj_elements ppe
4947: ,pa_proj_element_versions ppv5
4948: ,pa_proj_workplan_attr ppwa
4949: ,pa_proj_element_versions ppev6
4950: ,pa_proj_progress_attr pppa
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
4950: ,pa_proj_progress_attr pppa
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
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
4960: ppe.proj_element_id = ppv.proj_element_id
4961: AND ppv.parent_structure_version_id = ppvs.element_version_id
5974: -----,pa_percent_completes ppc
5975: ,pa_project_statuses pps
5976: ,pa_project_statuses pps5
5977: ,pa_proj_elements ppe5
5978: ,pa_proj_element_versions ppv5
5979: ,pa_proj_workplan_attr ppwa
5980: ,pa_proj_element_versions ppev6
5981: ,pa_proj_progress_attr pppa
5982: ,pa_proj_element_versions ppv2
5976: ,pa_project_statuses pps5
5977: ,pa_proj_elements ppe5
5978: ,pa_proj_element_versions ppv5
5979: ,pa_proj_workplan_attr ppwa
5980: ,pa_proj_element_versions ppev6
5981: ,pa_proj_progress_attr pppa
5982: ,pa_proj_element_versions ppv2
5983: ,pa_tasks pt
5984: ,pa_proj_elements ppe
5978: ,pa_proj_element_versions ppv5
5979: ,pa_proj_workplan_attr ppwa
5980: ,pa_proj_element_versions ppev6
5981: ,pa_proj_progress_attr pppa
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
5981: ,pa_proj_progress_attr pppa
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
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
5991: ppe.proj_element_id = ppv.proj_element_id
5992: AND ppv.parent_structure_version_id = ppvs.element_version_id
6800: -----,pa_percent_completes ppc
6801: ,pa_project_statuses pps
6802: ,pa_project_statuses pps5
6803: ,pa_proj_elements ppe5
6804: ,pa_proj_element_versions ppv5
6805: ,pa_proj_workplan_attr ppwa
6806: ,pa_proj_element_versions ppev6
6807: ,pa_proj_progress_attr pppa
6808: ,pa_proj_element_versions ppv2
6802: ,pa_project_statuses pps5
6803: ,pa_proj_elements ppe5
6804: ,pa_proj_element_versions ppv5
6805: ,pa_proj_workplan_attr ppwa
6806: ,pa_proj_element_versions ppev6
6807: ,pa_proj_progress_attr pppa
6808: ,pa_proj_element_versions ppv2
6809: ,pa_tasks pt
6810: ,pa_proj_elements ppe
6804: ,pa_proj_element_versions ppv5
6805: ,pa_proj_workplan_attr ppwa
6806: ,pa_proj_element_versions ppev6
6807: ,pa_proj_progress_attr pppa
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
6807: ,pa_proj_progress_attr pppa
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
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
6817: ppe.proj_element_id = ppv.proj_element_id
6818: AND ppv.parent_structure_version_id = ppvs.element_version_id
7627: -----,pa_percent_completes ppc
7628: ,pa_project_statuses pps
7629: ,pa_project_statuses pps5
7630: ,pa_proj_elements ppe5
7631: ,pa_proj_element_versions ppv5
7632: ,pa_proj_workplan_attr ppwa
7633: ,pa_proj_element_versions ppev6
7634: ,pa_proj_progress_attr pppa
7635: ,pa_proj_element_versions ppv2
7629: ,pa_project_statuses pps5
7630: ,pa_proj_elements ppe5
7631: ,pa_proj_element_versions ppv5
7632: ,pa_proj_workplan_attr ppwa
7633: ,pa_proj_element_versions ppev6
7634: ,pa_proj_progress_attr pppa
7635: ,pa_proj_element_versions ppv2
7636: ,pa_tasks pt
7637: ,pa_proj_elements ppe
7631: ,pa_proj_element_versions ppv5
7632: ,pa_proj_workplan_attr ppwa
7633: ,pa_proj_element_versions ppev6
7634: ,pa_proj_progress_attr pppa
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
7634: ,pa_proj_progress_attr pppa
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
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
7644: ppe.proj_element_id = ppv.proj_element_id
7645: AND ppv.parent_structure_version_id = ppvs.element_version_id
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
7798: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
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
7798: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
7799: WHERE ppes.project_id = ppevs.project_id
7800: AND ppes.proj_element_id = ppevs.proj_element_id
7801: AND ppes.link_task_flag = 'Y'
7802: AND ppes.object_type = 'PA_TASKS'
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
7889: FROM pa_proj_elements ppes
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
7889: FROM pa_proj_elements ppes
7890: , pa_proj_element_versions ppevs
7891: WHERE ppes.project_id = ppevs.project_id
7892: AND ppes.proj_element_id = ppevs.proj_element_id
7893: AND ppes.link_task_flag = 'Y'
7894: AND ppes.object_type = 'PA_TASKS'
8560: ,per_all_people_f papf
8561: ,pa_projects_all ppa
8562: ,pa_page_layouts ppl
8563: ,pa_project_statuses pps
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
8562: ,pa_page_layouts ppl
8563: ,pa_project_statuses pps
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
8563: ,pa_project_statuses pps
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
8573: ,pa_proj_progress_attr pppa
8574: where
8575: por.object_id_from1 in ( SELECT ppevs.element_version_id
8576: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
8577: WHERE ppes.project_id = ppevs.project_id
8578: AND ppes.proj_element_id = ppevs.proj_element_id
8579: AND ppes.link_task_flag = 'Y'
8580: AND ppes.object_type = 'PA_TASKS'
9051: ,per_all_people_f papf
9052: ,pa_projects_all ppa
9053: ,pa_page_layouts ppl
9054: ,pa_project_statuses pps
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
9053: ,pa_page_layouts ppl
9054: ,pa_project_statuses pps
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
9054: ,pa_project_statuses pps
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
9064: ,pa_proj_progress_attr pppa
9065: where
9066: por.object_id_from1 in ( SELECT ppevs.element_version_id
9067: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
9068: WHERE ppes.project_id = ppevs.project_id
9069: AND ppes.proj_element_id = ppevs.proj_element_id
9070: AND ppes.link_task_flag = 'Y'
9071: AND ppes.object_type = 'PA_TASKS'
9559: ,per_all_people_f papf
9560: ,pa_projects_all ppa
9561: ,pa_page_layouts ppl
9562: ,pa_project_statuses pps
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
9561: ,pa_page_layouts ppl
9562: ,pa_project_statuses pps
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
9562: ,pa_project_statuses pps
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
9572: ,pa_proj_progress_attr pppa
9573: where
9574: por.object_id_from1 in ( SELECT ppevs.element_version_id
9575: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
9576: WHERE ppes.project_id = ppevs.project_id
9577: AND ppes.proj_element_id = ppevs.proj_element_id
9578: AND ppes.link_task_flag = 'Y'
9579: AND ppes.object_type = 'PA_TASKS'
10398: ----,pa_percent_completes ppc
10399: ,pa_project_statuses pps
10400: ,pa_project_statuses pps5
10401: ,pa_proj_elements ppe5
10402: ,pa_proj_element_versions ppv5
10403: ,pa_proj_workplan_attr ppwa
10404: ,pa_proj_element_versions ppev6
10405: ,pa_proj_progress_attr pppa
10406: ,pa_proj_element_versions ppv2
10400: ,pa_project_statuses pps5
10401: ,pa_proj_elements ppe5
10402: ,pa_proj_element_versions ppv5
10403: ,pa_proj_workplan_attr ppwa
10404: ,pa_proj_element_versions ppev6
10405: ,pa_proj_progress_attr pppa
10406: ,pa_proj_element_versions ppv2
10407: ,pa_tasks pt
10408: ,pa_proj_elements ppe
10402: ,pa_proj_element_versions ppv5
10403: ,pa_proj_workplan_attr ppwa
10404: ,pa_proj_element_versions ppev6
10405: ,pa_proj_progress_attr pppa
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
10405: ,pa_proj_progress_attr pppa
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
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
10415: ppe.proj_element_id = ppv.proj_element_id
10416: AND ppv.parent_structure_version_id = ppvs.element_version_id
11158: ----,pa_percent_completes ppc
11159: ,pa_project_statuses pps
11160: ,pa_project_statuses pps5
11161: ,pa_proj_elements ppe5
11162: ,pa_proj_element_versions ppv5
11163: ,pa_proj_workplan_attr ppwa
11164: ,pa_proj_element_versions ppev6
11165: ,pa_proj_progress_attr pppa
11166: ,pa_proj_element_versions ppv2
11160: ,pa_project_statuses pps5
11161: ,pa_proj_elements ppe5
11162: ,pa_proj_element_versions ppv5
11163: ,pa_proj_workplan_attr ppwa
11164: ,pa_proj_element_versions ppev6
11165: ,pa_proj_progress_attr pppa
11166: ,pa_proj_element_versions ppv2
11167: ,pa_tasks pt
11168: ,pa_proj_elements ppe
11162: ,pa_proj_element_versions ppv5
11163: ,pa_proj_workplan_attr ppwa
11164: ,pa_proj_element_versions ppev6
11165: ,pa_proj_progress_attr pppa
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
11165: ,pa_proj_progress_attr pppa
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
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
11175: ppe.proj_element_id = ppv.proj_element_id
11176: AND ppv.parent_structure_version_id = ppvs.element_version_id
12092: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12093: FROM pa_proj_elem_ver_structure ppvs
12094: ,pa_proj_elem_ver_schedule ppvsch
12095: ,pa_proj_elements ppe5
12096: ,pa_proj_element_versions ppv5
12097: ,per_all_people_f papf
12098: ,pa_project_statuses pps2
12099: ,pa_lookups fl3
12100: ,hr_all_organization_units_tl hou
12098: ,pa_project_statuses pps2
12099: ,pa_lookups fl3
12100: ,hr_all_organization_units_tl hou
12101: ,pa_projects_all ppa
12102: ,pa_proj_element_versions ppv2
12103: ,pa_proj_structure_types ppst
12104: ,pa_structure_types pst
12105: ,fnd_lookups fl1
12106: ,fnd_lookups fl2
12115: ,pa_project_statuses pps5
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
12920: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12921: FROM pa_proj_elem_ver_structure ppvs
12922: ,pa_proj_elem_ver_schedule ppvsch
12923: ,pa_proj_elements ppe5
12924: ,pa_proj_element_versions ppv5
12925: ,per_all_people_f papf
12926: ,pa_project_statuses pps2
12927: ,pa_lookups fl3
12928: ,hr_all_organization_units_tl hou
12926: ,pa_project_statuses pps2
12927: ,pa_lookups fl3
12928: ,hr_all_organization_units_tl hou
12929: ,pa_projects_all ppa
12930: ,pa_proj_element_versions ppv2
12931: ,pa_proj_structure_types ppst
12932: ,pa_structure_types pst
12933: ,fnd_lookups fl1
12934: ,fnd_lookups fl2
12943: ,pa_project_statuses pps5
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
13749: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13750: FROM pa_proj_elem_ver_structure ppvs
13751: ,pa_proj_elem_ver_schedule ppvsch
13752: ,pa_proj_elements ppe5
13753: ,pa_proj_element_versions ppv5
13754: ,per_all_people_f papf
13755: ,pa_project_statuses pps2
13756: ,pa_lookups fl3
13757: ,hr_all_organization_units_tl hou
13755: ,pa_project_statuses pps2
13756: ,pa_lookups fl3
13757: ,hr_all_organization_units_tl hou
13758: ,pa_projects_all ppa
13759: ,pa_proj_element_versions ppv2
13760: ,pa_proj_structure_types ppst
13761: ,pa_structure_types pst
13762: ,fnd_lookups fl1
13763: ,fnd_lookups fl2
13772: ,pa_project_statuses pps5
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
14674: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
14675: FROM pa_proj_elem_ver_structure ppvs
14676: ,pa_proj_elem_ver_schedule ppvsch
14677: ,pa_proj_elements ppe5
14678: ,pa_proj_element_versions ppv5
14679: ,per_all_people_f papf
14680: ,pa_project_statuses pps2
14681: ,pa_lookups fl3
14682: ,hr_all_organization_units_tl hou
14680: ,pa_project_statuses pps2
14681: ,pa_lookups fl3
14682: ,hr_all_organization_units_tl hou
14683: ,pa_projects_all ppa
14684: ,pa_proj_element_versions ppv2
14685: ,pa_proj_structure_types ppst
14686: ,pa_structure_types pst
14687: ,fnd_lookups fl1
14688: ,fnd_lookups fl2
14697: ,pa_project_statuses pps5
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
15471: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
15472: FROM pa_proj_elem_ver_structure ppvs
15473: ,pa_proj_elem_ver_schedule ppvsch
15474: ,pa_proj_elements ppe5
15475: ,pa_proj_element_versions ppv5
15476: ,per_all_people_f papf
15477: ,pa_project_statuses pps2
15478: ,pa_lookups fl3
15479: ,hr_all_organization_units_tl hou
15477: ,pa_project_statuses pps2
15478: ,pa_lookups fl3
15479: ,hr_all_organization_units_tl hou
15480: ,pa_projects_all ppa
15481: ,pa_proj_element_versions ppv2
15482: ,pa_proj_structure_types ppst
15483: ,pa_structure_types pst
15484: ,fnd_lookups fl1
15485: ,fnd_lookups fl2
15494: ,pa_project_statuses pps5
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
16269: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
16270: FROM pa_proj_elem_ver_structure ppvs
16271: ,pa_proj_elem_ver_schedule ppvsch
16272: ,pa_proj_elements ppe5
16273: ,pa_proj_element_versions ppv5
16274: ,per_all_people_f papf
16275: ,pa_project_statuses pps2
16276: ,pa_lookups fl3
16277: ,hr_all_organization_units_tl hou
16275: ,pa_project_statuses pps2
16276: ,pa_lookups fl3
16277: ,hr_all_organization_units_tl hou
16278: ,pa_projects_all ppa
16279: ,pa_proj_element_versions ppv2
16280: ,pa_proj_structure_types ppst
16281: ,pa_structure_types pst
16282: ,fnd_lookups fl1
16283: ,fnd_lookups fl2
16292: ,pa_project_statuses pps5
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