[Home] [Help]
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
1052: ,ppe.object_type
1053: ,ppv.element_version_id
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
1052: ,ppe.object_type
1053: ,ppv.element_version_id
1054: ,ppe.proj_element_id
1069: ,por.relationship_type
1070: ,por.relationship_subtype
1071: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1072: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1073: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1074: summary_element_flag -- Fix for Bug # 4490532.
1075: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1076: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1077: ,PPS.PROJECT_STATUS_NAME
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
1532: ,pa_proj_elements ppeph
1539: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
1540: AND ppv.element_version_id = ppvsch.element_version_id (+)
1541: AND ppv.project_id = ppvsch.project_id (+)
1542: AND ppv.element_version_id = por.object_id_to1
1543: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1544: AND ppe.manager_person_id = papf.person_id(+)
1545: AND ppe.object_type = 'PA_TASKS'
1546: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
1547: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1541: AND ppv.project_id = ppvsch.project_id (+)
1542: AND ppv.element_version_id = por.object_id_to1
1543: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1544: AND ppe.manager_person_id = papf.person_id(+)
1545: AND ppe.object_type = 'PA_TASKS'
1546: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
1547: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1548: AND ppe.carrying_out_organization_id = hou.organization_id (+)
1549: AND userenv('LANG') = hou.language (+)
1547: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1548: AND ppe.carrying_out_organization_id = hou.organization_id (+)
1549: AND userenv('LANG') = hou.language (+)
1550: AND ppe.project_id = ppa.project_id
1551: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1552: AND por.object_id_from1 = ppv2.element_version_id(+)
1553: AND ppe.proj_element_id = ppst.proj_element_id(+)
1554: AND pst.structure_type_id(+) = ppst.structure_type_id
1555: AND por.relationship_type = 'S'
1557: AND ppv.proj_element_id = pt.task_id (+)
1558: AND pt.work_type_id = pwt.work_type_id (+)
1559: AND pwt.language (+) = userenv('lang')
1560: AND tt.task_type_id = ppe.type_id
1561: AND tt.object_type = 'PA_TASKS'
1562: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
1563: AND pps3.STATUS_TYPE (+) = 'TASK'
1564: --AND pt.address_id = addr.address_id (+)
1565: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
1583: ppr2.object_id = ppv.proj_element_id
1584: and ppr2.proj_element_id = ppv.proj_element_id
1585: and ppr2.object_version_id = ppv.element_version_id
1586: and ppr2.project_id = ppv.project_id
1587: and ppr2.object_type = 'PA_TASKS'
1588: and ppr2.structure_type = 'WORKPLAN'
1589: and ppr2.structure_version_id is null
1590: and ppr2.current_flag <> 'W')
1591: -- End fix for Bug # 4499065.
1591: -- End fix for Bug # 4499065.
1592: AND ppru.structure_version_id(+) IS NULL
1593: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
1594: ---AND ppc.project_id (+) = ppru.project_id
1595: AND 'PA_TASKS' = ppru.object_type (+)
1596: ---AND ppc.object_id (+) = ppru.object_id
1597: ---AND ppc.date_computed (+) = ppru.as_of_date
1598: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
1599: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
1629: ,ppe.object_type
1630: ,ppv.element_version_id
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
1629: ,ppe.object_type
1630: ,ppv.element_version_id
1631: ,ppe.proj_element_id
1646: ,por.relationship_type
1647: ,por.relationship_subtype
1648: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1649: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1650: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1651: summary_element_flag -- Fix for Bug # 4490532.
1652: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1653: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1654: ,PPS.PROJECT_STATUS_NAME
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
2109: ,pa_proj_elements ppeph
2116: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
2117: AND ppv.element_version_id = ppvsch.element_version_id (+)
2118: AND ppv.project_id = ppvsch.project_id (+)
2119: AND ppv.element_version_id = por.object_id_to1
2120: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2121: AND ppe.manager_person_id = papf.person_id(+)
2122: AND ppe.object_type = 'PA_TASKS'
2123: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2124: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2118: AND ppv.project_id = ppvsch.project_id (+)
2119: AND ppv.element_version_id = por.object_id_to1
2120: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2121: AND ppe.manager_person_id = papf.person_id(+)
2122: AND ppe.object_type = 'PA_TASKS'
2123: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2124: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2125: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2126: AND userenv('LANG') = hou.language (+)
2124: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2125: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2126: AND userenv('LANG') = hou.language (+)
2127: AND ppe.project_id = ppa.project_id
2128: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
2129: AND por.object_id_from1 = ppv2.element_version_id(+)
2130: AND ppe.proj_element_id = ppst.proj_element_id(+)
2131: AND pst.structure_type_id(+) = ppst.structure_type_id
2132: AND por.relationship_type = 'S'
2134: AND ppv.proj_element_id = pt.task_id (+)
2135: AND pt.work_type_id = pwt.work_type_id (+)
2136: AND pwt.language (+) = userenv('lang')
2137: AND tt.task_type_id = ppe.type_id
2138: AND tt.object_type = 'PA_TASKS'
2139: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
2140: AND pps3.STATUS_TYPE (+) = 'TASK'
2141: --AND pt.address_id = addr.address_id (+)
2142: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
2161: ppr2.object_id = ppv.proj_element_id
2162: and ppr2.proj_element_id = ppv.proj_element_id
2163: and ppr2.object_version_id = ppv.element_version_id
2164: and ppr2.project_id = ppv.project_id
2165: and ppr2.object_type = 'PA_TASKS'
2166: and ppr2.structure_type = 'WORKPLAN'
2167: and ppr2.structure_version_id is null
2168: and ppr2.current_flag <> 'W')
2169: -- End fix for Bug # 4499065.
2169: -- End fix for Bug # 4499065.
2170: AND ppru.structure_version_id(+) IS NULL
2171: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
2172: ---AND ppc.project_id (+) = ppru.project_id
2173: AND 'PA_TASKS' = ppru.object_type (+)
2174: ---AND ppc.object_id (+) = ppru.object_id
2175: ---AND ppc.date_computed (+) = ppru.as_of_date
2176: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
2177: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
2449: ,ppe.object_type
2450: ,ppv.element_version_id
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
2449: ,ppe.object_type
2450: ,ppv.element_version_id
2451: ,ppe.proj_element_id
2466: ,por.relationship_type
2467: ,por.relationship_subtype
2468: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
2469: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
2470: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
2471: summary_element_flag -- Fix for Bug # 4490532.
2472: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
2473: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
2474: ,PPS.PROJECT_STATUS_NAME
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
2931: ,pa_proj_elements ppeph
2938: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
2939: AND ppv.element_version_id = ppvsch.element_version_id (+)
2940: AND ppv.project_id = ppvsch.project_id (+)
2941: AND ppv.element_version_id = por.object_id_to1
2942: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2943: AND ppe.manager_person_id = papf.person_id(+)
2944: AND ppe.object_type = 'PA_TASKS'
2945: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2946: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2940: AND ppv.project_id = ppvsch.project_id (+)
2941: AND ppv.element_version_id = por.object_id_to1
2942: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2943: AND ppe.manager_person_id = papf.person_id(+)
2944: AND ppe.object_type = 'PA_TASKS'
2945: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2946: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2947: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2948: AND userenv('LANG') = hou.language (+)
2946: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2947: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2948: AND userenv('LANG') = hou.language (+)
2949: AND ppe.project_id = ppa.project_id
2950: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
2951: AND por.object_id_from1 = ppv2.element_version_id(+)
2952: AND ppe.proj_element_id = ppst.proj_element_id(+)
2953: AND pst.structure_type_id(+) = ppst.structure_type_id
2954: AND por.relationship_type = 'S'
2956: AND ppv.proj_element_id = pt.task_id (+)
2957: AND pt.work_type_id = pwt.work_type_id (+)
2958: AND pwt.language (+) = userenv('lang')
2959: AND tt.task_type_id = ppe.type_id
2960: AND tt.object_type = 'PA_TASKS'
2961: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
2962: AND pps3.STATUS_TYPE (+) = 'TASK'
2963: --AND pt.address_id = addr.address_id (+)
2964: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
2982: ppr2.object_id = ppv.proj_element_id
2983: and ppr2.proj_element_id = ppv.proj_element_id
2984: and ppr2.object_version_id = ppv.element_version_id
2985: and ppr2.project_id = ppv.project_id
2986: and ppr2.object_type = 'PA_TASKS'
2987: and ppr2.structure_type = 'WORKPLAN'
2988: and ppr2.structure_version_id is null
2989: and ppr2.current_flag <> 'W')
2990: -- End fix for Bug # 4499065.
2990: -- End fix for Bug # 4499065.
2991: AND ppru.structure_version_id(+) IS NULL
2992: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
2993: ---AND ppc.project_id (+) = ppru.project_id Bug 5580992
2994: AND 'PA_TASKS' = ppru.object_type (+)
2995: ---AND ppc.object_id (+) = ppru.object_id Bug 5580992
2996: ---AND ppc.date_computed (+) = ppru.as_of_date Bug 5580992
2997: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
2998: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
3029: ,ppe.object_type
3030: ,ppv.element_version_id
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
3029: ,ppe.object_type
3030: ,ppv.element_version_id
3031: ,ppe.proj_element_id
3046: ,por.relationship_type
3047: ,por.relationship_subtype
3048: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
3049: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
3050: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
3051: summary_element_flag -- Fix for Bug # 4490532.
3052: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
3053: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
3054: ,PPS.PROJECT_STATUS_NAME
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
3511: ,pa_proj_elements ppeph
3518: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
3519: AND ppv.element_version_id = ppvsch.element_version_id (+)
3520: AND ppv.project_id = ppvsch.project_id (+)
3521: AND ppv.element_version_id = por.object_id_to1
3522: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
3523: AND ppe.manager_person_id = papf.person_id(+)
3524: AND ppe.object_type = 'PA_TASKS'
3525: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
3526: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3520: AND ppv.project_id = ppvsch.project_id (+)
3521: AND ppv.element_version_id = por.object_id_to1
3522: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
3523: AND ppe.manager_person_id = papf.person_id(+)
3524: AND ppe.object_type = 'PA_TASKS'
3525: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
3526: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3527: AND ppe.carrying_out_organization_id = hou.organization_id (+)
3528: AND userenv('LANG') = hou.language (+)
3526: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3527: AND ppe.carrying_out_organization_id = hou.organization_id (+)
3528: AND userenv('LANG') = hou.language (+)
3529: AND ppe.project_id = ppa.project_id
3530: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
3531: AND por.object_id_from1 = ppv2.element_version_id(+)
3532: AND ppe.proj_element_id = ppst.proj_element_id(+)
3533: AND pst.structure_type_id(+) = ppst.structure_type_id
3534: AND por.relationship_type = 'S'
3536: AND ppv.proj_element_id = pt.task_id (+)
3537: AND pt.work_type_id = pwt.work_type_id (+)
3538: AND pwt.language (+) = userenv('lang')
3539: AND tt.task_type_id = ppe.type_id
3540: AND tt.object_type = 'PA_TASKS'
3541: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
3542: AND pps3.STATUS_TYPE (+) = 'TASK'
3543: --AND pt.address_id = addr.address_id (+)
3544: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
3563: ppr2.object_id = ppv.proj_element_id
3564: and ppr2.proj_element_id = ppv.proj_element_id
3565: and ppr2.object_version_id = ppv.element_version_id
3566: and ppr2.project_id = ppv.project_id
3567: and ppr2.object_type = 'PA_TASKS'
3568: and ppr2.structure_type = 'WORKPLAN'
3569: and ppr2.structure_version_id is null
3570: and ppr2.current_flag <> 'W')
3571: -- End fix for Bug # 4499065.
3571: -- End fix for Bug # 4499065.
3572: AND ppru.structure_version_id(+) IS NULL
3573: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
3574: ---AND ppc.project_id (+) = ppru.project_id Bug 5580992
3575: AND 'PA_TASKS' = ppru.object_type (+)
3576: ---AND ppc.object_id (+) = ppru.object_id Bug 5580992
3577: ---AND ppc.date_computed (+) = ppru.as_of_date Bug 5580992
3578: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
3579: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
3625: INTO l_tmp_pc ,l_tmp_desc
3626: FROM pa_percent_completes ppc
3627: WHERE ppc.project_id=rec.project_id
3628: AND ppc.object_id = rec.proj_element_id
3629: AND ppc.object_type = 'PA_TASKS'
3630: AND ppc.date_computed = rec.as_of_date
3631: and ppc.current_flag = 'Y' -- Fix for Bug # 4190747.
3632: and ppc.structure_type = 'WORKPLAN' -- Fix for Bug # 4216980.
3633: and ppc.published_flag = 'Y'; -- Fix for Bug # 4190747.
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
3904: ,ppe.object_type
3905: ,ppv.element_version_id
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
3904: ,ppe.object_type
3905: ,ppv.element_version_id
3906: ,ppe.proj_element_id
3921: ,por.relationship_type
3922: ,por.relationship_subtype
3923: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
3924: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
3925: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
3926: summary_element_flag -- Fix for Bug # 4490532.
3927: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
3928: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
3929: ,PPS.PROJECT_STATUS_NAME
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
4381: ,pa_proj_elements ppeph
4388: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
4389: AND ppv.element_version_id = ppvsch.element_version_id (+)
4390: AND ppv.project_id = ppvsch.project_id (+)
4391: AND ppv.element_version_id = por.object_id_to1
4392: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4393: AND ppe.manager_person_id = papf.person_id(+)
4394: AND ppe.object_type = 'PA_TASKS'
4395: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4396: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4390: AND ppv.project_id = ppvsch.project_id (+)
4391: AND ppv.element_version_id = por.object_id_to1
4392: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4393: AND ppe.manager_person_id = papf.person_id(+)
4394: AND ppe.object_type = 'PA_TASKS'
4395: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4396: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4397: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4398: AND userenv('LANG') = hou.language (+)
4396: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4397: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4398: AND userenv('LANG') = hou.language (+)
4399: AND ppe.project_id = ppa.project_id
4400: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
4401: AND por.object_id_from1 = ppv2.element_version_id(+)
4402: AND ppe.proj_element_id = ppst.proj_element_id(+)
4403: AND pst.structure_type_id(+) = ppst.structure_type_id
4404: AND por.relationship_type = 'S'
4406: AND ppv.proj_element_id = pt.task_id (+)
4407: AND pt.work_type_id = pwt.work_type_id (+)
4408: AND pwt.language (+) = userenv('lang')
4409: AND tt.task_type_id = ppe.type_id
4410: AND tt.object_type = 'PA_TASKS'
4411: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
4412: AND pps3.STATUS_TYPE (+) = 'TASK'
4413: --AND pt.address_id = addr.address_id (+)
4414: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
4432: ppr2.object_id = ppv.proj_element_id
4433: and ppr2.proj_element_id = ppv.proj_element_id
4434: and ppr2.object_version_id = ppv.element_version_id
4435: and ppr2.project_id = ppv.project_id
4436: and ppr2.object_type = 'PA_TASKS'
4437: and ppr2.structure_type = 'WORKPLAN'
4438: and ppr2.structure_version_id is null
4439: and ppr2.current_flag <> 'W')
4440: -- End fix for Bug # 4499065.
4440: -- End fix for Bug # 4499065.
4441: AND ppru.structure_version_id(+) IS NULL
4442: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
4443: ---AND ppc.project_id (+) = ppru.project_id
4444: AND 'PA_TASKS' = ppru.object_type (+)
4445: ---AND ppc.object_id (+) = ppru.object_id
4446: ---AND ppc.date_computed (+) = ppru.as_of_date
4447: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
4448: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
4479: ,ppe.object_type
4480: ,ppv.element_version_id
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
4479: ,ppe.object_type
4480: ,ppv.element_version_id
4481: ,ppe.proj_element_id
4496: ,por.relationship_type
4497: ,por.relationship_subtype
4498: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
4499: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
4500: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
4501: summary_element_flag -- Fix for Bug # 4490532.
4502: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
4503: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
4504: ,PPS.PROJECT_STATUS_NAME
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
4956: ,pa_proj_elements ppeph
4963: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
4964: AND ppv.element_version_id = ppvsch.element_version_id (+)
4965: AND ppv.project_id = ppvsch.project_id (+)
4966: AND ppv.element_version_id = por.object_id_to1
4967: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4968: AND ppe.manager_person_id = papf.person_id(+)
4969: AND ppe.object_type = 'PA_TASKS'
4970: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4971: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4965: AND ppv.project_id = ppvsch.project_id (+)
4966: AND ppv.element_version_id = por.object_id_to1
4967: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4968: AND ppe.manager_person_id = papf.person_id(+)
4969: AND ppe.object_type = 'PA_TASKS'
4970: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4971: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4972: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4973: AND userenv('LANG') = hou.language (+)
4971: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4972: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4973: AND userenv('LANG') = hou.language (+)
4974: AND ppe.project_id = ppa.project_id
4975: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
4976: AND por.object_id_from1 = ppv2.element_version_id(+)
4977: AND ppe.proj_element_id = ppst.proj_element_id(+)
4978: AND pst.structure_type_id(+) = ppst.structure_type_id
4979: AND por.relationship_type = 'S'
4981: AND ppv.proj_element_id = pt.task_id (+)
4982: AND pt.work_type_id = pwt.work_type_id (+)
4983: AND pwt.language (+) = userenv('lang')
4984: AND tt.task_type_id = ppe.type_id
4985: AND tt.object_type = 'PA_TASKS'
4986: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
4987: AND pps3.STATUS_TYPE (+) = 'TASK'
4988: --AND pt.address_id = addr.address_id (+)
4989: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
5008: ppr2.object_id = ppv.proj_element_id
5009: and ppr2.proj_element_id = ppv.proj_element_id
5010: and ppr2.object_version_id = ppv.element_version_id
5011: and ppr2.project_id = ppv.project_id
5012: and ppr2.object_type = 'PA_TASKS'
5013: and ppr2.structure_type = 'WORKPLAN'
5014: and ppr2.structure_version_id is null
5015: and ppr2.current_flag <> 'W')
5016: -- End fix for Bug # 4499065.
5016: -- End fix for Bug # 4499065.
5017: AND ppru.structure_version_id(+) IS NULL
5018: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
5019: ---AND ppc.project_id (+) = ppru.project_id
5020: AND 'PA_TASKS' = ppru.object_type (+)
5021: ---AND ppc.object_id (+) = ppru.object_id
5022: ---AND ppc.date_computed (+) = ppru.as_of_date
5023: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
5024: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
5076: INTO l_tmp_pc ,l_tmp_desc
5077: FROM pa_percent_completes ppc
5078: WHERE ppc.project_id=rec.project_id
5079: AND ppc.object_id = rec.proj_element_id
5080: AND ppc.object_type = 'PA_TASKS'
5081: AND ppc.date_computed = rec.as_of_date
5082: and ppc.current_flag = 'Y' -- Fix for Bug # 4190747.
5083: and ppc.structure_type = 'WORKPLAN' -- Fix for Bug # 4216980.
5084: and ppc.published_flag = 'Y'; -- Fix for Bug # 4190747.
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
5478: ,ppe.object_type
5479: ,ppv.element_version_id
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
5478: ,ppe.object_type
5479: ,ppv.element_version_id
5480: ,ppe.proj_element_id
5495: ,por.relationship_type
5496: ,por.relationship_subtype
5497: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
5498: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
5499: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
5500: summary_element_flag -- Fix for Bug # 4490532.
5501: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
5502: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
5503: ,PPS.PROJECT_STATUS_NAME
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
5987: ,pa_proj_elements ppeph
5994: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
5995: AND ppv.element_version_id = ppvsch.element_version_id (+)
5996: AND ppv.project_id = ppvsch.project_id (+)
5997: AND ppv.element_version_id = por.object_id_to1
5998: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5999: AND ppe.manager_person_id = papf.person_id(+)
6000: AND ppe.object_type = 'PA_TASKS'
6001: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
6002: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5996: AND ppv.project_id = ppvsch.project_id (+)
5997: AND ppv.element_version_id = por.object_id_to1
5998: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5999: AND ppe.manager_person_id = papf.person_id(+)
6000: AND ppe.object_type = 'PA_TASKS'
6001: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
6002: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
6003: AND ppe.carrying_out_organization_id = hou.organization_id (+)
6004: AND userenv('LANG') = hou.language (+)
6002: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
6003: AND ppe.carrying_out_organization_id = hou.organization_id (+)
6004: AND userenv('LANG') = hou.language (+)
6005: AND ppe.project_id = ppa.project_id
6006: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
6007: AND por.object_id_from1 = ppv2.element_version_id(+)
6008: AND ppe.proj_element_id = ppst.proj_element_id(+)
6009: AND pst.structure_type_id(+) = ppst.structure_type_id
6010: AND por.relationship_type = 'S'
6012: AND ppv.proj_element_id = pt.task_id (+)
6013: AND pt.work_type_id = pwt.work_type_id (+)
6014: AND pwt.language (+) = userenv('lang')
6015: AND tt.task_type_id = ppe.type_id
6016: AND tt.object_type = 'PA_TASKS'
6017: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
6018: AND pps3.STATUS_TYPE (+) = 'TASK'
6019: --AND pt.address_id = addr.address_id (+)
6020: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
6027: AND ppru.structure_type (+) = 'WORKPLAN'
6028: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
6029: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
6030: ---AND ppc.project_id (+) = ppru.project_id
6031: AND 'PA_TASKS' = ppru.object_type (+)
6032: ---AND ppc.object_id (+) = ppru.object_id
6033: ---AND ppc.date_computed (+) = ppru.as_of_date
6034: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
6035: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
6304: ,ppe.object_type
6305: ,ppv.element_version_id
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
6304: ,ppe.object_type
6305: ,ppv.element_version_id
6306: ,ppe.proj_element_id
6321: ,por.relationship_type
6322: ,por.relationship_subtype
6323: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
6324: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
6325: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
6326: summary_element_flag -- Fix for Bug # 4490532.
6327: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
6328: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
6329: ,PPS.PROJECT_STATUS_NAME
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
6813: ,pa_proj_elements ppeph
6820: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
6821: AND ppv.element_version_id = ppvsch.element_version_id (+)
6822: AND ppv.project_id = ppvsch.project_id (+)
6823: AND ppv.element_version_id = por.object_id_to1
6824: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6825: AND ppe.manager_person_id = papf.person_id(+)
6826: AND ppe.object_type = 'PA_TASKS'
6827: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
6828: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
6822: AND ppv.project_id = ppvsch.project_id (+)
6823: AND ppv.element_version_id = por.object_id_to1
6824: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6825: AND ppe.manager_person_id = papf.person_id(+)
6826: AND ppe.object_type = 'PA_TASKS'
6827: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
6828: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
6829: AND ppe.carrying_out_organization_id = hou.organization_id (+)
6830: AND userenv('LANG') = hou.language (+)
6828: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
6829: AND ppe.carrying_out_organization_id = hou.organization_id (+)
6830: AND userenv('LANG') = hou.language (+)
6831: AND ppe.project_id = ppa.project_id
6832: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
6833: AND por.object_id_from1 = ppv2.element_version_id(+)
6834: AND ppe.proj_element_id = ppst.proj_element_id(+)
6835: AND pst.structure_type_id(+) = ppst.structure_type_id
6836: AND por.relationship_type = 'S'
6838: AND ppv.proj_element_id = pt.task_id (+)
6839: AND pt.work_type_id = pwt.work_type_id (+)
6840: AND pwt.language (+) = userenv('lang')
6841: AND tt.task_type_id = ppe.type_id
6842: AND tt.object_type = 'PA_TASKS'
6843: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
6844: AND pps3.STATUS_TYPE (+) = 'TASK'
6845: --AND pt.address_id = addr.address_id (+)
6846: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
6853: AND ppru.structure_type (+) = 'WORKPLAN'
6854: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
6855: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
6856: ---AND ppc.project_id (+) = ppru.project_id
6857: AND 'PA_TASKS' = ppru.object_type (+)
6858: ---AND ppc.object_id (+) = ppru.object_id
6859: ---AND ppc.date_computed (+) = ppru.as_of_date
6860: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
6861: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
7131: ,ppe.object_type
7132: ,ppv.element_version_id
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
7131: ,ppe.object_type
7132: ,ppv.element_version_id
7133: ,ppe.proj_element_id
7148: ,por.relationship_type
7149: ,por.relationship_subtype
7150: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
7151: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
7152: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
7153: summary_element_flag -- Fix for Bug # 4490532.
7154: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
7155: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
7156: ,PPS.PROJECT_STATUS_NAME
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
7640: ,pa_proj_elements ppeph
7647: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
7648: AND ppv.element_version_id = ppvsch.element_version_id (+)
7649: AND ppv.project_id = ppvsch.project_id (+)
7650: AND ppv.element_version_id = por.object_id_to1
7651: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
7652: AND ppe.manager_person_id = papf.person_id(+)
7653: AND ppe.object_type = 'PA_TASKS'
7654: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
7655: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
7649: AND ppv.project_id = ppvsch.project_id (+)
7650: AND ppv.element_version_id = por.object_id_to1
7651: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
7652: AND ppe.manager_person_id = papf.person_id(+)
7653: AND ppe.object_type = 'PA_TASKS'
7654: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
7655: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
7656: AND ppe.carrying_out_organization_id = hou.organization_id (+)
7657: AND userenv('LANG') = hou.language (+)
7655: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
7656: AND ppe.carrying_out_organization_id = hou.organization_id (+)
7657: AND userenv('LANG') = hou.language (+)
7658: AND ppe.project_id = ppa.project_id
7659: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
7660: AND por.object_id_from1 = ppv2.element_version_id(+)
7661: AND ppe.proj_element_id = ppst.proj_element_id(+)
7662: AND pst.structure_type_id(+) = ppst.structure_type_id
7663: AND por.relationship_type = 'S'
7665: AND ppv.proj_element_id = pt.task_id (+)
7666: AND pt.work_type_id = pwt.work_type_id (+)
7667: AND pwt.language (+) = userenv('lang')
7668: AND tt.task_type_id = ppe.type_id
7669: AND tt.object_type = 'PA_TASKS'
7670: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
7671: AND pps3.STATUS_TYPE (+) = 'TASK'
7672: --AND pt.address_id = addr.address_id (+)
7673: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
7680: AND ppru.structure_type (+) = 'WORKPLAN'
7681: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
7682: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
7683: ---AND ppc.project_id (+) = ppru.project_id
7684: AND 'PA_TASKS' = ppru.object_type (+)
7685: ---AND ppc.object_id (+) = ppru.object_id
7686: ---AND ppc.date_computed (+) = ppru.as_of_date
7687: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
7688: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_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'
7803: AND ppes.project_id= p_project_id
7804: AND ppevs.parent_structure_version_id = p_structure_version_id)
7805: order by display_sequence --bug 4448499
7806: ;
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'
7820: AND a.element_version_id = b.object_id_from1;
7821:
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'
7820: AND a.element_version_id = b.object_id_from1;
7821:
7822: l_immediate_parent_proj_id NUMBER;
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'
7895: AND ppes.project_id= p_project_id
7896: AND ppevs.parent_structure_version_id = p_structure_version_id));
7897:
7898:
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'
8581: AND ppes.project_id= p_project_id
8582: AND ppevs.parent_structure_version_id = p_structure_version_id
8583: )
8584: AND por.relationship_type in ( 'LW' )
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'
9072: AND ppes.project_id= p_project_id
9073: AND ppevs.parent_structure_version_id = p_structure_version_id
9074: )
9075: AND por.relationship_type in ( 'LW' )
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'
9580: AND ppes.project_id= p_project_id
9581: AND ppevs.parent_structure_version_id = p_structure_version_id
9582: )
9583: AND por.relationship_type in ( 'LW' )
10043: , PROGRESS_ROLLUP_ID
10044: )
10045: SELECT
10046: p_parent_project_id
10047: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10048: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10049: ,ppe.description
10050: ,ppe.object_type
10051: ,ppv.element_version_id
10044: )
10045: SELECT
10046: p_parent_project_id
10047: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10048: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10049: ,ppe.description
10050: ,ppe.object_type
10051: ,ppv.element_version_id
10052: ,ppe.proj_element_id
10061: ,por.relationship_type
10062: ,por.relationship_subtype
10063: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10064: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
10065: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10066: summary_element_flag -- Fix for Bug # 4490532.
10067: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10068: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
10069: ,PPS.PROJECT_STATUS_NAME
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
10411: ,pa_proj_elements ppeph
10418: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
10419: AND ppv.element_version_id = ppvsch.element_version_id (+)
10420: AND ppv.project_id = ppvsch.project_id (+)
10421: AND ppv.element_version_id = por.object_id_to1
10422: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
10423: AND ppe.manager_person_id = papf.person_id(+)
10424: AND ppe.object_type = 'PA_TASKS'
10425: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
10426: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
10420: AND ppv.project_id = ppvsch.project_id (+)
10421: AND ppv.element_version_id = por.object_id_to1
10422: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
10423: AND ppe.manager_person_id = papf.person_id(+)
10424: AND ppe.object_type = 'PA_TASKS'
10425: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
10426: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
10427: AND ppe.carrying_out_organization_id = hou.organization_id (+)
10428: AND userenv('LANG') = hou.language (+)
10426: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
10427: AND ppe.carrying_out_organization_id = hou.organization_id (+)
10428: AND userenv('LANG') = hou.language (+)
10429: AND ppe.project_id = ppa.project_id
10430: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
10431: AND por.object_id_from1 = ppv2.element_version_id(+)
10432: AND ppe.proj_element_id = ppst.proj_element_id(+)
10433: AND pst.structure_type_id(+) = ppst.structure_type_id
10434: AND por.relationship_type = 'S'
10436: AND ppv.proj_element_id = pt.task_id (+)
10437: AND pt.work_type_id = pwt.work_type_id (+)
10438: AND pwt.language (+) = userenv('lang')
10439: AND tt.task_type_id = ppe.type_id
10440: AND tt.object_type = 'PA_TASKS'
10441: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
10442: AND pps3.STATUS_TYPE (+) = 'TASK'
10443: --AND pt.address_id = addr.address_id (+)
10444: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
10452: AND ppru.current_flag (+) = 'Y'
10453: AND ppru.structure_version_id(+) IS NULL
10454: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
10455: ----AND ppc.project_id (+) = ppru.project_id
10456: AND 'PA_TASKS' = ppru.object_type (+)
10457: ----AND ppc.object_id (+) = ppru.object_id
10458: ----AND ppc.date_computed (+) = ppru.as_of_date
10459: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
10460: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
10803: , PROGRESS_ROLLUP_ID
10804: )
10805: SELECT
10806: p_parent_project_id
10807: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10808: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10809: ,ppe.description
10810: ,ppe.object_type
10811: ,ppv.element_version_id
10804: )
10805: SELECT
10806: p_parent_project_id
10807: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10808: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10809: ,ppe.description
10810: ,ppe.object_type
10811: ,ppv.element_version_id
10812: ,ppe.proj_element_id
10821: ,por.relationship_type
10822: ,por.relationship_subtype
10823: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10824: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
10825: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10826: summary_element_flag -- Fix for Bug # 4490532.
10827: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10828: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
10829: ,PPS.PROJECT_STATUS_NAME
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
11171: ,pa_proj_elements ppeph
11178: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
11179: AND ppv.element_version_id = ppvsch.element_version_id (+)
11180: AND ppv.project_id = ppvsch.project_id (+)
11181: AND ppv.element_version_id = por.object_id_to1
11182: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
11183: AND ppe.manager_person_id = papf.person_id(+)
11184: AND ppe.object_type = 'PA_TASKS'
11185: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
11186: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
11180: AND ppv.project_id = ppvsch.project_id (+)
11181: AND ppv.element_version_id = por.object_id_to1
11182: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
11183: AND ppe.manager_person_id = papf.person_id(+)
11184: AND ppe.object_type = 'PA_TASKS'
11185: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
11186: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
11187: AND ppe.carrying_out_organization_id = hou.organization_id (+)
11188: AND userenv('LANG') = hou.language (+)
11186: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
11187: AND ppe.carrying_out_organization_id = hou.organization_id (+)
11188: AND userenv('LANG') = hou.language (+)
11189: AND ppe.project_id = ppa.project_id
11190: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
11191: AND por.object_id_from1 = ppv2.element_version_id(+)
11192: AND ppe.proj_element_id = ppst.proj_element_id(+)
11193: AND pst.structure_type_id(+) = ppst.structure_type_id
11194: AND por.relationship_type = 'S'
11196: AND ppv.proj_element_id = pt.task_id (+)
11197: AND pt.work_type_id = pwt.work_type_id (+)
11198: AND pwt.language (+) = userenv('lang')
11199: AND tt.task_type_id = ppe.type_id
11200: AND tt.object_type = 'PA_TASKS'
11201: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
11202: AND pps3.STATUS_TYPE (+) = 'TASK'
11203: --AND pt.address_id = addr.address_id (+)
11204: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
11211: AND ppru.structure_type (+) = 'WORKPLAN'
11212: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
11213: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
11214: ---AND ppc.project_id (+) = ppru.project_id
11215: AND 'PA_TASKS' = ppru.object_type (+)
11216: ---AND ppc.object_id (+) = ppru.object_id
11217: ---AND ppc.date_computed (+) = ppru.as_of_date
11218: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
11219: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
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
11614: ,ppe.object_type
11615: ,ppv.element_version_id
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
11614: ,ppe.object_type
11615: ,ppv.element_version_id
11616: ,ppe.proj_element_id
11625: ,por.relationship_type
11626: ,por.relationship_subtype
11627: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
11628: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
11629: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
11630: summary_element_flag -- Fix for Bug # 4490532.
11631: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
11632: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
11633: ,PPS.PROJECT_STATUS_NAME
12113: ,pa_project_statuses pps
12114: ----,pa_percent_completes ppc
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
12127: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
12128: AND ppv.element_version_id = ppvsch.element_version_id (+)
12129: AND ppv.project_id = ppvsch.project_id (+)
12130: AND ppv.element_version_id = por.object_id_to1
12131: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
12132: AND ppe.manager_person_id = papf.person_id(+)
12133: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
12134: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
12135: AND ppe.priority_code = fl3.lookup_code(+)
12136: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
12137: AND ppe.carrying_out_organization_id = hou.organization_id (+)
12138: AND userenv('LANG') = hou.language (+)
12139: AND ppe.project_id = ppa.project_id
12140: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
12141: AND por.object_id_from1 = ppv2.element_version_id(+)
12142: AND ppe.proj_element_id = ppst.proj_element_id(+)
12143: AND pst.structure_type_id(+) = ppst.structure_type_id
12144: AND por.relationship_type = 'S'
12164: AND ppru.structure_type (+) = 'WORKPLAN'
12165: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
12166: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
12167: ----AND ppc.project_id (+) = ppru.project_id
12168: AND 'PA_TASKS' = ppru.object_type (+)
12169: ----AND ppc.object_id (+)= ppru.object_id
12170: ----AND ppc.date_computed (+)= ppru.as_of_date
12171: ----AND ppc.structure_type (+)=ppru.structure_type
12172: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
12172: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
12173: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
12174: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
12175: AND tt.task_type_id = ppe.type_id
12176: AND tt.object_type = 'PA_TASKS'
12177: AND ppe.project_id <> 0
12178: AND pfxat.project_id (+)= ppv.project_id
12179: AND pfxat.project_element_id (+)=ppv.proj_element_id
12180: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
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
12442: ,ppe.object_type
12443: ,ppv.element_version_id
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
12442: ,ppe.object_type
12443: ,ppv.element_version_id
12444: ,ppe.proj_element_id
12453: ,por.relationship_type
12454: ,por.relationship_subtype
12455: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
12456: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
12457: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
12458: summary_element_flag -- Fix for Bug # 4490532.
12459: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
12460: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
12461: ,PPS.PROJECT_STATUS_NAME
12941: ,pa_project_statuses pps
12942: ----,pa_percent_completes ppc
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
12955: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
12956: AND ppv.element_version_id = ppvsch.element_version_id (+)
12957: AND ppv.project_id = ppvsch.project_id (+)
12958: AND ppv.element_version_id = por.object_id_to1
12959: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
12960: AND ppe.manager_person_id = papf.person_id(+)
12961: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
12962: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
12963: AND ppe.priority_code = fl3.lookup_code(+)
12964: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
12965: AND ppe.carrying_out_organization_id = hou.organization_id (+)
12966: AND userenv('LANG') = hou.language (+)
12967: AND ppe.project_id = ppa.project_id
12968: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
12969: AND por.object_id_from1 = ppv2.element_version_id(+)
12970: AND ppe.proj_element_id = ppst.proj_element_id(+)
12971: AND pst.structure_type_id(+) = ppst.structure_type_id
12972: AND por.relationship_type = 'S'
12992: AND ppru.structure_type (+) = 'WORKPLAN'
12993: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
12994: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
12995: ----AND ppc.project_id (+) = ppru.project_id
12996: AND 'PA_TASKS' = ppru.object_type (+)
12997: ----AND ppc.object_id (+)= ppru.object_id
12998: ----AND ppc.date_computed (+)= ppru.as_of_date
12999: ----AND ppc.structure_type (+)=ppru.structure_type
13000: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13000: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13001: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
13002: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
13003: AND tt.task_type_id = ppe.type_id
13004: AND tt.object_type = 'PA_TASKS'
13005: AND ppe.project_id <> 0
13006: AND pfxat.project_id (+)= ppv.project_id
13007: AND pfxat.project_element_id (+)=ppv.proj_element_id
13008: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
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
13271: ,ppe.object_type
13272: ,ppv.element_version_id
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
13271: ,ppe.object_type
13272: ,ppv.element_version_id
13273: ,ppe.proj_element_id
13282: ,por.relationship_type
13283: ,por.relationship_subtype
13284: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
13285: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
13286: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
13287: summary_element_flag -- Fix for Bug # 4490532.
13288: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
13289: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
13290: ,PPS.PROJECT_STATUS_NAME
13770: ,pa_project_statuses pps
13771: ----,pa_percent_completes ppc
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
13784: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
13785: AND ppv.element_version_id = ppvsch.element_version_id (+)
13786: AND ppv.project_id = ppvsch.project_id (+)
13787: AND ppv.element_version_id = por.object_id_to1
13788: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
13789: AND ppe.manager_person_id = papf.person_id(+)
13790: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
13791: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
13792: AND ppe.priority_code = fl3.lookup_code(+)
13793: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
13794: AND ppe.carrying_out_organization_id = hou.organization_id (+)
13795: AND userenv('LANG') = hou.language (+)
13796: AND ppe.project_id = ppa.project_id
13797: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
13798: AND por.object_id_from1 = ppv2.element_version_id(+)
13799: AND ppe.proj_element_id = ppst.proj_element_id(+)
13800: AND pst.structure_type_id(+) = ppst.structure_type_id
13801: AND por.relationship_type = 'S'
13821: AND ppru.structure_type (+) = 'WORKPLAN'
13822: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
13823: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
13824: ----AND ppc.project_id (+) = ppru.project_id
13825: AND 'PA_TASKS' = ppru.object_type (+)
13826: ----AND ppc.object_id (+)= ppru.object_id
13827: ----AND ppc.date_computed (+)= ppru.as_of_date
13828: ----AND ppc.structure_type (+)=ppru.structure_type
13829: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13829: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13830: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
13831: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
13832: AND tt.task_type_id = ppe.type_id
13833: AND tt.object_type = 'PA_TASKS'
13834: AND ppe.project_id <> 0
13835: AND pfxat.project_id (+)= ppv.project_id
13836: AND pfxat.project_element_id (+)=ppv.proj_element_id
13837: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
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
14235: ,ppe.object_type
14236: ,ppv.element_version_id
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
14235: ,ppe.object_type
14236: ,ppv.element_version_id
14237: ,ppe.proj_element_id
14246: ,por.relationship_type
14247: ,por.relationship_subtype
14248: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
14249: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
14250: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
14251: summary_element_flag -- Fix for Bug # 4490532.
14252: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
14253: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
14254: ,PPS.PROJECT_STATUS_NAME
14695: ,pa_project_statuses pps
14696: ----,pa_percent_completes ppc
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
14709: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
14710: AND ppv.element_version_id = ppvsch.element_version_id (+)
14711: AND ppv.project_id = ppvsch.project_id (+)
14712: AND ppv.element_version_id = por.object_id_to1
14713: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
14714: AND ppe.manager_person_id = papf.person_id(+)
14715: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
14716: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
14717: AND ppe.priority_code = fl3.lookup_code(+)
14718: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
14719: AND ppe.carrying_out_organization_id = hou.organization_id (+)
14720: AND userenv('LANG') = hou.language (+)
14721: AND ppe.project_id = ppa.project_id
14722: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
14723: AND por.object_id_from1 = ppv2.element_version_id(+)
14724: AND ppe.proj_element_id = ppst.proj_element_id(+)
14725: AND pst.structure_type_id(+) = ppst.structure_type_id
14726: AND por.relationship_type = 'S'
14747: AND ppru.structure_version_id is null
14748: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
14749: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
14750: ---AND ppc.project_id (+) = ppru.project_id
14751: AND 'PA_TASKS' = ppru.object_type (+)
14752: ---AND ppc.object_id (+)= ppru.object_id
14753: ---AND ppc.date_computed (+)= ppru.as_of_date
14754: ---AND ppc.structure_type (+)=ppru.structure_type
14755: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
14755: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
14756: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
14757: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
14758: AND tt.task_type_id = ppe.type_id
14759: AND tt.object_type = 'PA_TASKS'
14760: AND ppe.project_id <> 0
14761: AND pfxat.project_id (+)= ppv.project_id
14762: AND pfxat.project_element_id (+)=ppv.proj_element_id
14763: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
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
15032: ,ppe.object_type
15033: ,ppv.element_version_id
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
15032: ,ppe.object_type
15033: ,ppv.element_version_id
15034: ,ppe.proj_element_id
15043: ,por.relationship_type
15044: ,por.relationship_subtype
15045: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
15046: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
15047: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
15048: summary_element_flag -- Fix for Bug # 4490532.
15049: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
15050: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
15051: ,PPS.PROJECT_STATUS_NAME
15492: ,pa_project_statuses pps
15493: ----,pa_percent_completes ppc
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
15506: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
15507: AND ppv.element_version_id = ppvsch.element_version_id (+)
15508: AND ppv.project_id = ppvsch.project_id (+)
15509: AND ppv.element_version_id = por.object_id_to1
15510: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
15511: AND ppe.manager_person_id = papf.person_id(+)
15512: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
15513: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
15514: AND ppe.priority_code = fl3.lookup_code(+)
15515: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
15516: AND ppe.carrying_out_organization_id = hou.organization_id (+)
15517: AND userenv('LANG') = hou.language (+)
15518: AND ppe.project_id = ppa.project_id
15519: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
15520: AND por.object_id_from1 = ppv2.element_version_id(+)
15521: AND ppe.proj_element_id = ppst.proj_element_id(+)
15522: AND pst.structure_type_id(+) = ppst.structure_type_id
15523: AND por.relationship_type = 'S'
15544: AND ppru.structure_version_id is null
15545: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
15546: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
15547: ---AND ppc.project_id (+) = ppru.project_id
15548: AND 'PA_TASKS' = ppru.object_type (+)
15549: ---AND ppc.object_id (+)= ppru.object_id
15550: ---AND ppc.date_computed (+)= ppru.as_of_date
15551: ---AND ppc.structure_type (+)=ppru.structure_type
15552: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
15552: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
15553: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
15554: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
15555: AND tt.task_type_id = ppe.type_id
15556: AND tt.object_type = 'PA_TASKS'
15557: AND ppe.project_id <> 0
15558: AND pfxat.project_id (+)= ppv.project_id
15559: AND pfxat.project_element_id (+)=ppv.proj_element_id
15560: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
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
15830: ,ppe.object_type
15831: ,ppv.element_version_id
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
15830: ,ppe.object_type
15831: ,ppv.element_version_id
15832: ,ppe.proj_element_id
15841: ,por.relationship_type
15842: ,por.relationship_subtype
15843: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
15844: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
15845: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
15846: summary_element_flag -- Fix for Bug # 4490532.
15847: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
15848: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
15849: ,PPS.PROJECT_STATUS_NAME
16290: ,pa_project_statuses pps
16291: ----,pa_percent_completes ppc
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
16304: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
16305: AND ppv.element_version_id = ppvsch.element_version_id (+)
16306: AND ppv.project_id = ppvsch.project_id (+)
16307: AND ppv.element_version_id = por.object_id_to1
16308: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
16309: AND ppe.manager_person_id = papf.person_id(+)
16310: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
16311: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
16312: AND ppe.priority_code = fl3.lookup_code(+)
16313: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
16314: AND ppe.carrying_out_organization_id = hou.organization_id (+)
16315: AND userenv('LANG') = hou.language (+)
16316: AND ppe.project_id = ppa.project_id
16317: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
16318: AND por.object_id_from1 = ppv2.element_version_id(+)
16319: AND ppe.proj_element_id = ppst.proj_element_id(+)
16320: AND pst.structure_type_id(+) = ppst.structure_type_id
16321: AND por.relationship_type = 'S'
16342: AND ppru.structure_version_id is null
16343: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
16344: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
16345: ---AND ppc.project_id (+) = ppru.project_id
16346: AND 'PA_TASKS' = ppru.object_type (+)
16347: ---AND ppc.object_id (+)= ppru.object_id
16348: ---AND ppc.date_computed (+)= ppru.as_of_date
16349: ---AND ppc.structure_type (+)=ppru.structure_type
16350: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
16350: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
16351: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
16352: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
16353: AND tt.task_type_id = ppe.type_id
16354: AND tt.object_type = 'PA_TASKS'
16355: AND ppe.project_id <> 0
16356: AND pfxat.project_id (+)= ppv.project_id
16357: AND pfxat.project_element_id (+)=ppv.proj_element_id
16358: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id