APPS.PA_PROJ_STRUCTURE_PUB dependencies on PJI_FM_XBS_ACCUM_TMP1

Line 1046: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

1042: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
1043: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
1044: )
1045: SELECT
1046: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1047: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
1048: p_parent_project_id
1049: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1050: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 1047: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

1043: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
1044: )
1045: SELECT
1046: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1047: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
1048: p_parent_project_id
1049: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1050: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1051: ,ppe.description

Line 1534: ,pji_fm_xbs_accum_tmp1 pfxat

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
1538: AND ppv.project_id = ppvs.project_id

Line 1623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

1619: ---and ppc.structure_type (+) = ppru.structure_type -- Fix for Bug # 4216980.
1620: AND ppv.parent_structure_version_id = p_structure_version_id
1621: UNION--Bug#11798422 - Replaced NVL with union
1622: SELECT
1623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
1625: p_parent_project_id
1626: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1627: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 1624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

1620: AND ppv.parent_structure_version_id = p_structure_version_id
1621: UNION--Bug#11798422 - Replaced NVL with union
1622: SELECT
1623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
1625: p_parent_project_id
1626: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1627: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1628: ,ppe.description

Line 2111: ,pji_fm_xbs_accum_tmp1 pfxat

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
2115: AND ppv.project_id = ppvs.project_id

Line 2443: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

2439: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
2440: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
2441: )
2442: SELECT
2443: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2444: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
2445: p_parent_project_id
2446: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
2447: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 2444: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

2440: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
2441: )
2442: SELECT
2443: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2444: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
2445: p_parent_project_id
2446: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
2447: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
2448: ,ppe.description

Line 2933: ,pji_fm_xbs_accum_tmp1 pfxat

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
2937: AND ppv.project_id = ppvs.project_id

Line 3023: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

3019: AND ppv.parent_structure_version_id = p_structure_version_id
3020: and ppv.wbs_level <= p_wbs_display_depth
3021: UNION--Bug#11798422 - Replaced NVL with union
3022: SELECT
3023: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3024: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
3025: p_parent_project_id
3026: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3027: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 3024: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

3020: and ppv.wbs_level <= p_wbs_display_depth
3021: UNION--Bug#11798422 - Replaced NVL with union
3022: SELECT
3023: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3024: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
3025: p_parent_project_id
3026: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3027: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
3028: ,ppe.description

Line 3513: ,pji_fm_xbs_accum_tmp1 pfxat

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
3517: AND ppv.project_id = ppvs.project_id

Line 3898: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

3894: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
3895: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
3896: )
3897: SELECT
3898: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3899: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
3900: p_parent_project_id
3901: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3902: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 3899: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

3895: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
3896: )
3897: SELECT
3898: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3899: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
3900: p_parent_project_id
3901: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3902: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
3903: ,ppe.description

Line 4383: ,pji_fm_xbs_accum_tmp1 pfxat

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
4387: AND ppv.project_id = ppvs.project_id

Line 4473: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

4469: AND ppv.parent_structure_version_id = p_structure_version_id
4470: and por.object_id_from1 = p_task_version_id
4471: UNION--Bug#11798422 - Replaced NVL with union
4472: SELECT
4473: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4474: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
4475: p_parent_project_id
4476: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
4477: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 4474: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

4470: and por.object_id_from1 = p_task_version_id
4471: UNION--Bug#11798422 - Replaced NVL with union
4472: SELECT
4473: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4474: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
4475: p_parent_project_id
4476: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
4477: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
4478: ,ppe.description

Line 4958: ,pji_fm_xbs_accum_tmp1 pfxat

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
4962: AND ppv.project_id = ppvs.project_id

Line 5472: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

5468: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
5469: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
5470: )
5471: SELECT
5472: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5473: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
5474: p_parent_project_id
5475: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
5476: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 5473: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

5469: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
5470: )
5471: SELECT
5472: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5473: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
5474: p_parent_project_id
5475: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
5476: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
5477: ,ppe.description

Line 5989: ,pji_fm_xbs_accum_tmp1 pfxat

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
5993: AND ppv.project_id = ppvs.project_id

Line 6298: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

6294: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
6295: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
6296: )
6297: SELECT
6298: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6299: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
6300: p_parent_project_id
6301: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
6302: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 6299: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

6295: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
6296: )
6297: SELECT
6298: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
6299: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
6300: p_parent_project_id
6301: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
6302: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
6303: ,ppe.description

Line 6815: ,pji_fm_xbs_accum_tmp1 pfxat

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
6819: AND ppv.project_id = ppvs.project_id

Line 7125: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

7121: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
7122: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
7123: )
7124: SELECT
7125: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
7126: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
7127: p_parent_project_id
7128: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
7129: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 7126: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

7122: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
7123: )
7124: SELECT
7125: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
7126: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
7127: p_parent_project_id
7128: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
7129: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
7130: ,ppe.description

Line 7642: ,pji_fm_xbs_accum_tmp1 pfxat

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
7646: AND ppv.project_id = ppvs.project_id

Line 8145: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

8141: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
8142: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
8143: )
8144: SELECT
8145: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8146: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
8147: p_parent_project_id
8148: ,to_char( ppvs.version_number )
8149: ,ppvs.name

Line 8146: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

8142: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
8143: )
8144: SELECT
8145: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8146: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
8147: p_parent_project_id
8148: ,to_char( ppvs.version_number )
8149: ,ppvs.name
8150: ,ppe.description

Line 8570: ,pji_fm_xbs_accum_tmp1 pfxat

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

Line 8623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

8619: AND pppa.structure_type(+) = 'WORKPLAN'
8620: -- Begin fix for Bug # 4416432, Issue # 7.
8621: UNION ALL
8622: SELECT
8623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
8625: p_parent_project_id
8626: ,to_char( ppvs.version_number )
8627: ,ppvs.name

Line 8624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

8620: -- Begin fix for Bug # 4416432, Issue # 7.
8621: UNION ALL
8622: SELECT
8623: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
8624: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
8625: p_parent_project_id
8626: ,to_char( ppvs.version_number )
8627: ,ppvs.name
8628: ,ppe.description

Line 9061: ,pji_fm_xbs_accum_tmp1 pfxat

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

Line 9131: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.

9127: AND pppa.object_id (+) = ppe.proj_element_id
9128: AND pppa.structure_type(+) = 'WORKPLAN'
9129: UNION--Bug#11798422 - Replaced NVL with union
9130: SELECT
9131: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
9132: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
9133: p_parent_project_id
9134: ,to_char( ppvs.version_number )
9135: ,ppvs.name

Line 9132: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

9128: AND pppa.structure_type(+) = 'WORKPLAN'
9129: UNION--Bug#11798422 - Replaced NVL with union
9130: SELECT
9131: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
9132: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
9133: p_parent_project_id
9134: ,to_char( ppvs.version_number )
9135: ,ppvs.name
9136: ,ppe.description

Line 9569: ,pji_fm_xbs_accum_tmp1 pfxat

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

Line 10413: --,pji_fm_xbs_accum_tmp1 pfxat

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
10417: AND ppv.project_id = ppvs.project_id

Line 11173: --,pji_fm_xbs_accum_tmp1 pfxat

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
11177: AND ppv.project_id = ppvs.project_id

Line 11608: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

11604: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
11605: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
11606: )
11607: SELECT
11608: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
11609: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
11610: p_parent_project_id
11611: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
11612: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 11609: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

11605: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
11606: )
11607: SELECT
11608: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
11609: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
11610: p_parent_project_id
11611: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
11612: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
11613: ,ppe.description

Line 12121: ,pji_fm_xbs_accum_tmp1 pfxat

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
12125: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 12436: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

12432: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
12433: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
12434: )
12435: SELECT
12436: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
12437: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
12438: p_parent_project_id
12439: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
12440: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 12437: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

12433: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
12434: )
12435: SELECT
12436: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
12437: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
12438: p_parent_project_id
12439: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
12440: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
12441: ,ppe.description

Line 12949: ,pji_fm_xbs_accum_tmp1 pfxat

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
12953: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 13265: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

13261: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
13262: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
13263: )
13264: SELECT
13265: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
13266: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
13267: p_parent_project_id
13268: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
13269: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 13266: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

13262: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
13263: )
13264: SELECT
13265: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
13266: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
13267: p_parent_project_id
13268: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
13269: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
13270: ,ppe.description

Line 13778: ,pji_fm_xbs_accum_tmp1 pfxat

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
13782: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 14229: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

14225: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
14226: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
14227: )
14228: SELECT
14229: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
14230: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
14231: p_parent_project_id
14232: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
14233: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 14230: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

14226: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
14227: )
14228: SELECT
14229: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
14230: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
14231: p_parent_project_id
14232: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
14233: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
14234: ,ppe.description

Line 14703: ,pji_fm_xbs_accum_tmp1 pfxat

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
14707: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 15026: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

15022: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
15023: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
15024: )
15025: SELECT
15026: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
15027: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
15028: p_parent_project_id
15029: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
15030: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 15027: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

15023: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
15024: )
15025: SELECT
15026: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
15027: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
15028: p_parent_project_id
15029: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
15030: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
15031: ,ppe.description

Line 15500: ,pji_fm_xbs_accum_tmp1 pfxat

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
15504: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 15824: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/

15820: , PLANNED_BASELINE_EFFORT_VAR -- Bug 5090355
15821: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
15822: )
15823: SELECT
15824: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
15825: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
15826: p_parent_project_id
15827: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
15828: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )

Line 15825: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130

15821: , PLANNED_BASELINE_COST_VAR -- Bug 5090355
15822: )
15823: SELECT
15824: --Bug 7644130 /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
15825: /*+ INDEX(pfxat pji_fm_xbs_accum_tmp1_n1)*/ --Bug 7644130
15826: p_parent_project_id
15827: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
15828: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
15829: ,ppe.description

Line 16298: ,pji_fm_xbs_accum_tmp1 pfxat

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
16302: AND ppv.parent_structure_version_id = ppvs.element_version_id