1042: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
1043: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
1044: )
1045: SELECT
1046: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1047: p_parent_project_id
1048: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1049: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1050: ,ppe.description
1529: ,pa_proj_element_versions ppv
1530: ,pa_object_relationships por
1531: ,pa_proj_elements ppeph
1532: ,pa_proj_element_versions ppevph
1533: ,pji_fm_xbs_accum_tmp1 pfxat
1534: WHERE
1535: ppe.proj_element_id = ppv.proj_element_id
1536: AND ppv.parent_structure_version_id = ppvs.element_version_id
1537: AND ppv.project_id = ppvs.project_id
1855: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
1856: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
1857: )
1858: SELECT
1859: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1860: p_parent_project_id
1861: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1862: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1863: ,ppe.description
2344: ,pa_proj_element_versions ppv
2345: ,pa_object_relationships por
2346: ,pa_proj_elements ppeph
2347: ,pa_proj_element_versions ppevph
2348: ,pji_fm_xbs_accum_tmp1 pfxat
2349: WHERE
2350: ppe.proj_element_id = ppv.proj_element_id
2351: AND ppv.parent_structure_version_id = ppvs.element_version_id
2352: AND ppv.project_id = ppvs.project_id
2718: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
2719: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
2720: )
2721: SELECT
2722: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2723: p_parent_project_id
2724: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
2725: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
2726: ,ppe.description
3202: ,pa_proj_element_versions ppv
3203: ,pa_object_relationships por
3204: ,pa_proj_elements ppeph
3205: ,pa_proj_element_versions ppevph
3206: ,pji_fm_xbs_accum_tmp1 pfxat
3207: WHERE
3208: ppe.proj_element_id = ppv.proj_element_id
3209: AND ppv.parent_structure_version_id = ppvs.element_version_id
3210: AND ppv.project_id = ppvs.project_id
3657: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
3658: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
3659: )
3660: SELECT
3661: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3662: p_parent_project_id
3663: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3664: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
3665: ,ppe.description
4173: ,pa_proj_element_versions ppv
4174: ,pa_object_relationships por
4175: ,pa_proj_elements ppeph
4176: ,pa_proj_element_versions ppevph
4177: ,pji_fm_xbs_accum_tmp1 pfxat
4178: WHERE
4179: ppe.proj_element_id = ppv.proj_element_id
4180: AND ppv.parent_structure_version_id = ppvs.element_version_id
4181: AND ppv.project_id = ppvs.project_id
4482: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
4483: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
4484: )
4485: SELECT
4486: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4487: p_parent_project_id
4488: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
4489: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
4490: ,ppe.description
4998: ,pa_proj_element_versions ppv
4999: ,pa_object_relationships por
5000: ,pa_proj_elements ppeph
5001: ,pa_proj_element_versions ppevph
5002: ,pji_fm_xbs_accum_tmp1 pfxat
5003: WHERE
5004: ppe.proj_element_id = ppv.proj_element_id
5005: AND ppv.parent_structure_version_id = ppvs.element_version_id
5006: AND ppv.project_id = ppvs.project_id
5308: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
5309: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
5310: )
5311: SELECT
5312: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5313: p_parent_project_id
5314: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
5315: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
5316: ,ppe.description
5824: ,pa_proj_element_versions ppv
5825: ,pa_object_relationships por
5826: ,pa_proj_elements ppeph
5827: ,pa_proj_element_versions ppevph
5828: ,pji_fm_xbs_accum_tmp1 pfxat
5829: WHERE
5830: ppe.proj_element_id = ppv.proj_element_id
5831: AND ppv.parent_structure_version_id = ppvs.element_version_id
5832: AND ppv.project_id = ppvs.project_id
6327: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
6328: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
6329: )
6330: SELECT
6331: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6332: p_parent_project_id
6333: ,to_char( ppvs.version_number )
6334: ,ppvs.name
6335: ,ppe.description
6751: ,pa_proj_element_versions ppv3
6752: ,pa_proj_element_versions ppv1
6753: ,pa_object_relationships por
6754: ,pa_object_relationships por2
6755: ,pji_fm_xbs_accum_tmp1 pfxat
6756: ----,pa_percent_completes ppc
6757: ,pa_progress_rollup ppru
6758: ,pa_proj_progress_attr pppa
6759: where
6804: AND pppa.structure_type(+) = 'WORKPLAN'
6805: -- Begin fix for Bug # 4416432, Issue # 7.
6806: UNION ALL
6807: SELECT
6808: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6809: p_parent_project_id
6810: ,to_char( ppvs.version_number )
6811: ,ppvs.name
6812: ,ppe.description
7241: ,pa_proj_element_versions ppv3
7242: ,pa_proj_element_versions ppv1
7243: ,pa_object_relationships por
7244: ,pa_object_relationships por2
7245: ,pji_fm_xbs_accum_tmp1 pfxat
7246: ----,pa_percent_completes ppc
7247: ,pa_progress_rollup ppru
7248: ,pa_proj_progress_attr pppa
7249: where
8079: ,pa_proj_element_versions ppv
8080: ,pa_object_relationships por
8081: ,pa_proj_elements ppeph
8082: ,pa_proj_element_versions ppevph
8083: --,pji_fm_xbs_accum_tmp1 pfxat
8084: WHERE
8085: ppe.proj_element_id = ppv.proj_element_id
8086: AND ppv.parent_structure_version_id = ppvs.element_version_id
8087: AND ppv.project_id = ppvs.project_id
8839: ,pa_proj_element_versions ppv
8840: ,pa_object_relationships por
8841: ,pa_proj_elements ppeph
8842: ,pa_proj_element_versions ppevph
8843: --,pji_fm_xbs_accum_tmp1 pfxat
8844: WHERE
8845: ppe.proj_element_id = ppv.proj_element_id
8846: AND ppv.parent_structure_version_id = ppvs.element_version_id
8847: AND ppv.project_id = ppvs.project_id
9274: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
9275: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
9276: )
9277: SELECT
9278: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
9279: p_parent_project_id
9280: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
9281: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
9282: ,ppe.description
9786: ,pa_tasks pt
9787: ,pa_proj_elements ppe
9788: ,pa_proj_element_versions ppv
9789: ,pa_object_relationships por
9790: ,pji_fm_xbs_accum_tmp1 pfxat
9791: WHERE
9792: ppe.proj_element_id = ppv.proj_element_id
9793: AND ppe.project_id = ppv.project_id
9794: AND ppv.parent_structure_version_id = ppvs.element_version_id
10101: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
10102: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
10103: )
10104: SELECT
10105: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10106: p_parent_project_id
10107: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10108: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10109: ,ppe.description
10613: ,pa_tasks pt
10614: ,pa_proj_elements ppe
10615: ,pa_proj_element_versions ppv
10616: ,pa_object_relationships por
10617: ,pji_fm_xbs_accum_tmp1 pfxat
10618: WHERE
10619: ppe.proj_element_id = ppv.proj_element_id
10620: AND ppe.project_id = ppv.project_id
10621: AND ppv.parent_structure_version_id = ppvs.element_version_id
10929: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
10930: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
10931: )
10932: SELECT
10933: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10934: p_parent_project_id
10935: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10936: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10937: ,ppe.description
11441: ,pa_tasks pt
11442: ,pa_proj_elements ppe
11443: ,pa_proj_element_versions ppv
11444: ,pa_object_relationships por
11445: ,pji_fm_xbs_accum_tmp1 pfxat
11446: WHERE
11447: ppe.proj_element_id = ppv.proj_element_id
11448: AND ppe.project_id = ppv.project_id
11449: AND ppv.parent_structure_version_id = ppvs.element_version_id
11892: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
11893: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
11894: )
11895: SELECT
11896: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
11897: p_parent_project_id
11898: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
11899: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
11900: ,ppe.description
12365: ,pa_tasks pt
12366: ,pa_proj_elements ppe
12367: ,pa_proj_element_versions ppv
12368: ,pa_object_relationships por
12369: ,pji_fm_xbs_accum_tmp1 pfxat
12370: WHERE
12371: ppe.proj_element_id = ppv.proj_element_id
12372: AND ppe.project_id = ppv.project_id
12373: AND ppv.parent_structure_version_id = ppvs.element_version_id
12688: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
12689: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
12690: )
12691: SELECT
12692: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
12693: p_parent_project_id
12694: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
12695: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
12696: ,ppe.description
13161: ,pa_tasks pt
13162: ,pa_proj_elements ppe
13163: ,pa_proj_element_versions ppv
13164: ,pa_object_relationships por
13165: ,pji_fm_xbs_accum_tmp1 pfxat
13166: WHERE
13167: ppe.proj_element_id = ppv.proj_element_id
13168: AND ppe.project_id = ppv.project_id
13169: AND ppv.parent_structure_version_id = ppvs.element_version_id
13485: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
13486: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
13487: )
13488: SELECT
13489: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
13490: p_parent_project_id
13491: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
13492: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
13493: ,ppe.description
13958: ,pa_tasks pt
13959: ,pa_proj_elements ppe
13960: ,pa_proj_element_versions ppv
13961: ,pa_object_relationships por
13962: ,pji_fm_xbs_accum_tmp1 pfxat
13963: WHERE
13964: ppe.proj_element_id = ppv.proj_element_id
13965: AND ppe.project_id = ppv.project_id
13966: AND ppv.parent_structure_version_id = ppvs.element_version_id