[Home] [Help]
1044: )
1045: SELECT
1046: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1047: p_parent_project_id
1048: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1049: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1050: ,ppe.description
1051: ,ppe.object_type
1052: ,ppv.element_version_id
1045: SELECT
1046: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1047: p_parent_project_id
1048: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1049: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1050: ,ppe.description
1051: ,ppe.object_type
1052: ,ppv.element_version_id
1053: ,ppe.proj_element_id
1068: ,por.relationship_type
1069: ,por.relationship_subtype
1070: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1071: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1072: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1073: summary_element_flag -- Fix for Bug # 4490532.
1074: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1075: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1076: ,PPS.PROJECT_STATUS_NAME
1523: ,pa_proj_workplan_attr ppwa
1524: ,pa_proj_element_versions ppev6
1525: ,pa_proj_progress_attr pppa
1526: ,pa_proj_element_versions ppv2
1527: ,pa_tasks pt
1528: ,pa_proj_elements ppe
1529: ,pa_proj_element_versions ppv
1530: ,pa_object_relationships por
1531: ,pa_proj_elements ppeph
1538: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
1539: AND ppv.element_version_id = ppvsch.element_version_id (+)
1540: AND ppv.project_id = ppvsch.project_id (+)
1541: AND ppv.element_version_id = por.object_id_to1
1542: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1543: AND ppe.manager_person_id = papf.person_id(+)
1544: AND ppe.object_type = 'PA_TASKS'
1545: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
1546: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1540: AND ppv.project_id = ppvsch.project_id (+)
1541: AND ppv.element_version_id = por.object_id_to1
1542: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
1543: AND ppe.manager_person_id = papf.person_id(+)
1544: AND ppe.object_type = 'PA_TASKS'
1545: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
1546: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1547: AND ppe.carrying_out_organization_id = hou.organization_id (+)
1548: AND userenv('LANG') = hou.language (+)
1546: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
1547: AND ppe.carrying_out_organization_id = hou.organization_id (+)
1548: AND userenv('LANG') = hou.language (+)
1549: AND ppe.project_id = ppa.project_id
1550: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
1551: AND por.object_id_from1 = ppv2.element_version_id(+)
1552: AND ppe.proj_element_id = ppst.proj_element_id(+)
1553: AND pst.structure_type_id(+) = ppst.structure_type_id
1554: AND por.relationship_type = 'S'
1556: AND ppv.proj_element_id = pt.task_id (+)
1557: AND pt.work_type_id = pwt.work_type_id (+)
1558: AND pwt.language (+) = userenv('lang')
1559: AND tt.task_type_id = ppe.type_id
1560: AND tt.object_type = 'PA_TASKS'
1561: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
1562: AND pps3.STATUS_TYPE (+) = 'TASK'
1563: --AND pt.address_id = addr.address_id (+)
1564: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
1578: ppr2.object_id = ppv.proj_element_id
1579: and ppr2.proj_element_id = ppv.proj_element_id
1580: and ppr2.object_version_id = ppv.element_version_id
1581: and ppr2.project_id = ppv.project_id
1582: and ppr2.object_type = 'PA_TASKS'
1583: and ppr2.structure_type = 'WORKPLAN'
1584: and ppr2.structure_version_id is null
1585: and ppr2.current_flag <> 'W')
1586: -- End fix for Bug # 4499065.
1586: -- End fix for Bug # 4499065.
1587: AND ppru.structure_version_id(+) IS NULL
1588: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
1589: ---AND ppc.project_id (+) = ppru.project_id
1590: AND 'PA_TASKS' = ppru.object_type (+)
1591: ---AND ppc.object_id (+) = ppru.object_id
1592: ---AND ppc.date_computed (+) = ppru.as_of_date
1593: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
1594: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
1857: )
1858: SELECT
1859: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1860: p_parent_project_id
1861: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1862: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1863: ,ppe.description
1864: ,ppe.object_type
1865: ,ppv.element_version_id
1858: SELECT
1859: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
1860: p_parent_project_id
1861: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
1862: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
1863: ,ppe.description
1864: ,ppe.object_type
1865: ,ppv.element_version_id
1866: ,ppe.proj_element_id
1881: ,por.relationship_type
1882: ,por.relationship_subtype
1883: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
1884: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
1885: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
1886: summary_element_flag -- Fix for Bug # 4490532.
1887: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
1888: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
1889: ,PPS.PROJECT_STATUS_NAME
2338: ,pa_proj_workplan_attr ppwa
2339: ,pa_proj_element_versions ppev6
2340: ,pa_proj_progress_attr pppa
2341: ,pa_proj_element_versions ppv2
2342: ,pa_tasks pt
2343: ,pa_proj_elements ppe
2344: ,pa_proj_element_versions ppv
2345: ,pa_object_relationships por
2346: ,pa_proj_elements ppeph
2353: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
2354: AND ppv.element_version_id = ppvsch.element_version_id (+)
2355: AND ppv.project_id = ppvsch.project_id (+)
2356: AND ppv.element_version_id = por.object_id_to1
2357: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2358: AND ppe.manager_person_id = papf.person_id(+)
2359: AND ppe.object_type = 'PA_TASKS'
2360: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2361: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2355: AND ppv.project_id = ppvsch.project_id (+)
2356: AND ppv.element_version_id = por.object_id_to1
2357: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
2358: AND ppe.manager_person_id = papf.person_id(+)
2359: AND ppe.object_type = 'PA_TASKS'
2360: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
2361: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2362: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2363: AND userenv('LANG') = hou.language (+)
2361: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
2362: AND ppe.carrying_out_organization_id = hou.organization_id (+)
2363: AND userenv('LANG') = hou.language (+)
2364: AND ppe.project_id = ppa.project_id
2365: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
2366: AND por.object_id_from1 = ppv2.element_version_id(+)
2367: AND ppe.proj_element_id = ppst.proj_element_id(+)
2368: AND pst.structure_type_id(+) = ppst.structure_type_id
2369: AND por.relationship_type = 'S'
2371: AND ppv.proj_element_id = pt.task_id (+)
2372: AND pt.work_type_id = pwt.work_type_id (+)
2373: AND pwt.language (+) = userenv('lang')
2374: AND tt.task_type_id = ppe.type_id
2375: AND tt.object_type = 'PA_TASKS'
2376: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
2377: AND pps3.STATUS_TYPE (+) = 'TASK'
2378: --AND pt.address_id = addr.address_id (+)
2379: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
2393: ppr2.object_id = ppv.proj_element_id
2394: and ppr2.proj_element_id = ppv.proj_element_id
2395: and ppr2.object_version_id = ppv.element_version_id
2396: and ppr2.project_id = ppv.project_id
2397: and ppr2.object_type = 'PA_TASKS'
2398: and ppr2.structure_type = 'WORKPLAN'
2399: and ppr2.structure_version_id is null
2400: and ppr2.current_flag <> 'W')
2401: -- End fix for Bug # 4499065.
2401: -- End fix for Bug # 4499065.
2402: AND ppru.structure_version_id(+) IS NULL
2403: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
2404: ---AND ppc.project_id (+) = ppru.project_id Bug 5580992
2405: AND 'PA_TASKS' = ppru.object_type (+)
2406: ---AND ppc.object_id (+) = ppru.object_id Bug 5580992
2407: ---AND ppc.date_computed (+) = ppru.as_of_date Bug 5580992
2408: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
2409: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
2449: INTO l_tmp_pc ,l_tmp_desc
2450: FROM pa_percent_completes ppc
2451: WHERE ppc.project_id=rec.project_id
2452: AND ppc.object_id = rec.proj_element_id
2453: AND ppc.object_type = 'PA_TASKS'
2454: AND ppc.date_computed = rec.as_of_date
2455: and ppc.current_flag = 'Y' -- Fix for Bug # 4190747.
2456: and ppc.structure_type = 'WORKPLAN' -- Fix for Bug # 4216980.
2457: and ppc.published_flag = 'Y'; -- Fix for Bug # 4190747.
2720: )
2721: SELECT
2722: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2723: p_parent_project_id
2724: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
2725: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
2726: ,ppe.description
2727: ,ppe.object_type
2728: ,ppv.element_version_id
2721: SELECT
2722: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
2723: p_parent_project_id
2724: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
2725: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
2726: ,ppe.description
2727: ,ppe.object_type
2728: ,ppv.element_version_id
2729: ,ppe.proj_element_id
2744: ,por.relationship_type
2745: ,por.relationship_subtype
2746: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
2747: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
2748: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
2749: summary_element_flag -- Fix for Bug # 4490532.
2750: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
2751: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
2752: ,PPS.PROJECT_STATUS_NAME
3196: ,pa_proj_workplan_attr ppwa
3197: ,pa_proj_element_versions ppev6
3198: ,pa_proj_progress_attr pppa
3199: ,pa_proj_element_versions ppv2
3200: ,pa_tasks pt
3201: ,pa_proj_elements ppe
3202: ,pa_proj_element_versions ppv
3203: ,pa_object_relationships por
3204: ,pa_proj_elements ppeph
3211: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
3212: AND ppv.element_version_id = ppvsch.element_version_id (+)
3213: AND ppv.project_id = ppvsch.project_id (+)
3214: AND ppv.element_version_id = por.object_id_to1
3215: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
3216: AND ppe.manager_person_id = papf.person_id(+)
3217: AND ppe.object_type = 'PA_TASKS'
3218: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
3219: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3213: AND ppv.project_id = ppvsch.project_id (+)
3214: AND ppv.element_version_id = por.object_id_to1
3215: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
3216: AND ppe.manager_person_id = papf.person_id(+)
3217: AND ppe.object_type = 'PA_TASKS'
3218: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
3219: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3220: AND ppe.carrying_out_organization_id = hou.organization_id (+)
3221: AND userenv('LANG') = hou.language (+)
3219: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
3220: AND ppe.carrying_out_organization_id = hou.organization_id (+)
3221: AND userenv('LANG') = hou.language (+)
3222: AND ppe.project_id = ppa.project_id
3223: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
3224: AND por.object_id_from1 = ppv2.element_version_id(+)
3225: AND ppe.proj_element_id = ppst.proj_element_id(+)
3226: AND pst.structure_type_id(+) = ppst.structure_type_id
3227: AND por.relationship_type = 'S'
3229: AND ppv.proj_element_id = pt.task_id (+)
3230: AND pt.work_type_id = pwt.work_type_id (+)
3231: AND pwt.language (+) = userenv('lang')
3232: AND tt.task_type_id = ppe.type_id
3233: AND tt.object_type = 'PA_TASKS'
3234: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
3235: AND pps3.STATUS_TYPE (+) = 'TASK'
3236: --AND pt.address_id = addr.address_id (+)
3237: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
3251: ppr2.object_id = ppv.proj_element_id
3252: and ppr2.proj_element_id = ppv.proj_element_id
3253: and ppr2.object_version_id = ppv.element_version_id
3254: and ppr2.project_id = ppv.project_id
3255: and ppr2.object_type = 'PA_TASKS'
3256: and ppr2.structure_type = 'WORKPLAN'
3257: and ppr2.structure_version_id is null
3258: and ppr2.current_flag <> 'W')
3259: -- End fix for Bug # 4499065.
3259: -- End fix for Bug # 4499065.
3260: AND ppru.structure_version_id(+) IS NULL
3261: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
3262: ---AND ppc.project_id (+) = ppru.project_id
3263: AND 'PA_TASKS' = ppru.object_type (+)
3264: ---AND ppc.object_id (+) = ppru.object_id
3265: ---AND ppc.date_computed (+) = ppru.as_of_date
3266: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
3267: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
3659: )
3660: SELECT
3661: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3662: p_parent_project_id
3663: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3664: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
3665: ,ppe.description
3666: ,ppe.object_type
3667: ,ppv.element_version_id
3660: SELECT
3661: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
3662: p_parent_project_id
3663: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
3664: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
3665: ,ppe.description
3666: ,ppe.object_type
3667: ,ppv.element_version_id
3668: ,ppe.proj_element_id
3683: ,por.relationship_type
3684: ,por.relationship_subtype
3685: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
3686: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
3687: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
3688: summary_element_flag -- Fix for Bug # 4490532.
3689: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
3690: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
3691: ,PPS.PROJECT_STATUS_NAME
4167: ,pa_proj_workplan_attr ppwa
4168: ,pa_proj_element_versions ppev6
4169: ,pa_proj_progress_attr pppa
4170: ,pa_proj_element_versions ppv2
4171: ,pa_tasks pt
4172: ,pa_proj_elements ppe
4173: ,pa_proj_element_versions ppv
4174: ,pa_object_relationships por
4175: ,pa_proj_elements ppeph
4182: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
4183: AND ppv.element_version_id = ppvsch.element_version_id (+)
4184: AND ppv.project_id = ppvsch.project_id (+)
4185: AND ppv.element_version_id = por.object_id_to1
4186: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4187: AND ppe.manager_person_id = papf.person_id(+)
4188: AND ppe.object_type = 'PA_TASKS'
4189: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4190: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4184: AND ppv.project_id = ppvsch.project_id (+)
4185: AND ppv.element_version_id = por.object_id_to1
4186: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
4187: AND ppe.manager_person_id = papf.person_id(+)
4188: AND ppe.object_type = 'PA_TASKS'
4189: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
4190: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4191: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4192: AND userenv('LANG') = hou.language (+)
4190: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
4191: AND ppe.carrying_out_organization_id = hou.organization_id (+)
4192: AND userenv('LANG') = hou.language (+)
4193: AND ppe.project_id = ppa.project_id
4194: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
4195: AND por.object_id_from1 = ppv2.element_version_id(+)
4196: AND ppe.proj_element_id = ppst.proj_element_id(+)
4197: AND pst.structure_type_id(+) = ppst.structure_type_id
4198: AND por.relationship_type = 'S'
4200: AND ppv.proj_element_id = pt.task_id (+)
4201: AND pt.work_type_id = pwt.work_type_id (+)
4202: AND pwt.language (+) = userenv('lang')
4203: AND tt.task_type_id = ppe.type_id
4204: AND tt.object_type = 'PA_TASKS'
4205: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
4206: AND pps3.STATUS_TYPE (+) = 'TASK'
4207: --AND pt.address_id = addr.address_id (+)
4208: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
4215: AND ppru.structure_type (+) = 'WORKPLAN'
4216: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
4217: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
4218: ---AND ppc.project_id (+) = ppru.project_id
4219: AND 'PA_TASKS' = ppru.object_type (+)
4220: ---AND ppc.object_id (+) = ppru.object_id
4221: ---AND ppc.date_computed (+) = ppru.as_of_date
4222: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
4223: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
4484: )
4485: SELECT
4486: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4487: p_parent_project_id
4488: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
4489: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
4490: ,ppe.description
4491: ,ppe.object_type
4492: ,ppv.element_version_id
4485: SELECT
4486: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
4487: p_parent_project_id
4488: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
4489: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
4490: ,ppe.description
4491: ,ppe.object_type
4492: ,ppv.element_version_id
4493: ,ppe.proj_element_id
4508: ,por.relationship_type
4509: ,por.relationship_subtype
4510: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
4511: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
4512: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
4513: summary_element_flag -- Fix for Bug # 4490532.
4514: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
4515: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
4516: ,PPS.PROJECT_STATUS_NAME
4992: ,pa_proj_workplan_attr ppwa
4993: ,pa_proj_element_versions ppev6
4994: ,pa_proj_progress_attr pppa
4995: ,pa_proj_element_versions ppv2
4996: ,pa_tasks pt
4997: ,pa_proj_elements ppe
4998: ,pa_proj_element_versions ppv
4999: ,pa_object_relationships por
5000: ,pa_proj_elements ppeph
5007: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
5008: AND ppv.element_version_id = ppvsch.element_version_id (+)
5009: AND ppv.project_id = ppvsch.project_id (+)
5010: AND ppv.element_version_id = por.object_id_to1
5011: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5012: AND ppe.manager_person_id = papf.person_id(+)
5013: AND ppe.object_type = 'PA_TASKS'
5014: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
5015: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5009: AND ppv.project_id = ppvsch.project_id (+)
5010: AND ppv.element_version_id = por.object_id_to1
5011: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5012: AND ppe.manager_person_id = papf.person_id(+)
5013: AND ppe.object_type = 'PA_TASKS'
5014: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
5015: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5016: AND ppe.carrying_out_organization_id = hou.organization_id (+)
5017: AND userenv('LANG') = hou.language (+)
5015: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5016: AND ppe.carrying_out_organization_id = hou.organization_id (+)
5017: AND userenv('LANG') = hou.language (+)
5018: AND ppe.project_id = ppa.project_id
5019: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
5020: AND por.object_id_from1 = ppv2.element_version_id(+)
5021: AND ppe.proj_element_id = ppst.proj_element_id(+)
5022: AND pst.structure_type_id(+) = ppst.structure_type_id
5023: AND por.relationship_type = 'S'
5025: AND ppv.proj_element_id = pt.task_id (+)
5026: AND pt.work_type_id = pwt.work_type_id (+)
5027: AND pwt.language (+) = userenv('lang')
5028: AND tt.task_type_id = ppe.type_id
5029: AND tt.object_type = 'PA_TASKS'
5030: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
5031: AND pps3.STATUS_TYPE (+) = 'TASK'
5032: --AND pt.address_id = addr.address_id (+)
5033: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
5040: AND ppru.structure_type (+) = 'WORKPLAN'
5041: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
5042: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
5043: ---AND ppc.project_id (+) = ppru.project_id
5044: AND 'PA_TASKS' = ppru.object_type (+)
5045: ---AND ppc.object_id (+) = ppru.object_id
5046: ---AND ppc.date_computed (+) = ppru.as_of_date
5047: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
5048: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
5310: )
5311: SELECT
5312: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5313: p_parent_project_id
5314: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
5315: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
5316: ,ppe.description
5317: ,ppe.object_type
5318: ,ppv.element_version_id
5311: SELECT
5312: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/ -- Fix for Bug # 4162534.
5313: p_parent_project_id
5314: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
5315: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
5316: ,ppe.description
5317: ,ppe.object_type
5318: ,ppv.element_version_id
5319: ,ppe.proj_element_id
5334: ,por.relationship_type
5335: ,por.relationship_subtype
5336: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
5337: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
5338: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
5339: summary_element_flag -- Fix for Bug # 4490532.
5340: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
5341: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
5342: ,PPS.PROJECT_STATUS_NAME
5818: ,pa_proj_workplan_attr ppwa
5819: ,pa_proj_element_versions ppev6
5820: ,pa_proj_progress_attr pppa
5821: ,pa_proj_element_versions ppv2
5822: ,pa_tasks pt
5823: ,pa_proj_elements ppe
5824: ,pa_proj_element_versions ppv
5825: ,pa_object_relationships por
5826: ,pa_proj_elements ppeph
5833: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
5834: AND ppv.element_version_id = ppvsch.element_version_id (+)
5835: AND ppv.project_id = ppvsch.project_id (+)
5836: AND ppv.element_version_id = por.object_id_to1
5837: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5838: AND ppe.manager_person_id = papf.person_id(+)
5839: AND ppe.object_type = 'PA_TASKS'
5840: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
5841: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5835: AND ppv.project_id = ppvsch.project_id (+)
5836: AND ppv.element_version_id = por.object_id_to1
5837: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
5838: AND ppe.manager_person_id = papf.person_id(+)
5839: AND ppe.object_type = 'PA_TASKS'
5840: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
5841: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5842: AND ppe.carrying_out_organization_id = hou.organization_id (+)
5843: AND userenv('LANG') = hou.language (+)
5841: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
5842: AND ppe.carrying_out_organization_id = hou.organization_id (+)
5843: AND userenv('LANG') = hou.language (+)
5844: AND ppe.project_id = ppa.project_id
5845: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
5846: AND por.object_id_from1 = ppv2.element_version_id(+)
5847: AND ppe.proj_element_id = ppst.proj_element_id(+)
5848: AND pst.structure_type_id(+) = ppst.structure_type_id
5849: AND por.relationship_type = 'S'
5851: AND ppv.proj_element_id = pt.task_id (+)
5852: AND pt.work_type_id = pwt.work_type_id (+)
5853: AND pwt.language (+) = userenv('lang')
5854: AND tt.task_type_id = ppe.type_id
5855: AND tt.object_type = 'PA_TASKS'
5856: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
5857: AND pps3.STATUS_TYPE (+) = 'TASK'
5858: --AND pt.address_id = addr.address_id (+)
5859: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
5866: AND ppru.structure_type (+) = 'WORKPLAN'
5867: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
5868: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
5869: ---AND ppc.project_id (+) = ppru.project_id
5870: AND 'PA_TASKS' = ppru.object_type (+)
5871: ---AND ppc.object_id (+) = ppru.object_id
5872: ---AND ppc.date_computed (+) = ppru.as_of_date
5873: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
5874: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
5984: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
5985: WHERE ppes.project_id = ppevs.project_id
5986: AND ppes.proj_element_id = ppevs.proj_element_id
5987: AND ppes.link_task_flag = 'Y'
5988: AND ppes.object_type = 'PA_TASKS'
5989: AND ppes.project_id= p_project_id
5990: AND ppevs.parent_structure_version_id = p_structure_version_id)
5991: order by display_sequence --bug 4448499
5992: ;
5999: SELECT a.display_sequence
6000: FROM pa_structures_tasks_tmp a,
6001: pa_object_relationships b
6002: WHERE b.object_id_to1=c_subproj_struc_ver_id
6003: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6004: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
6005: AND b.relationship_type = 'S'
6006: AND a.element_version_id = b.object_id_from1;
6007:
6000: FROM pa_structures_tasks_tmp a,
6001: pa_object_relationships b
6002: WHERE b.object_id_to1=c_subproj_struc_ver_id
6003: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6004: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
6005: AND b.relationship_type = 'S'
6006: AND a.element_version_id = b.object_id_from1;
6007:
6008: l_immediate_parent_proj_id NUMBER;
6076: , pa_proj_element_versions ppevs
6077: WHERE ppes.project_id = ppevs.project_id
6078: AND ppes.proj_element_id = ppevs.proj_element_id
6079: AND ppes.link_task_flag = 'Y'
6080: AND ppes.object_type = 'PA_TASKS'
6081: AND ppes.project_id= p_project_id
6082: AND ppevs.parent_structure_version_id = p_structure_version_id));
6083:
6084:
6761: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
6762: WHERE ppes.project_id = ppevs.project_id
6763: AND ppes.proj_element_id = ppevs.proj_element_id
6764: AND ppes.link_task_flag = 'Y'
6765: AND ppes.object_type = 'PA_TASKS'
6766: AND ppes.project_id= p_project_id
6767: AND ppevs.parent_structure_version_id = p_structure_version_id
6768: )
6769: AND por.relationship_type in ( 'LW' )
7251: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
7252: WHERE ppes.project_id = ppevs.project_id
7253: AND ppes.proj_element_id = ppevs.proj_element_id
7254: AND ppes.link_task_flag = 'Y'
7255: AND ppes.object_type = 'PA_TASKS'
7256: AND ppes.project_id= p_project_id
7257: AND ppevs.parent_structure_version_id = p_structure_version_id
7258: )
7259: AND por.relationship_type in ( 'LW' )
7713: , PROGRESS_ROLLUP_ID
7714: )
7715: SELECT
7716: p_parent_project_id
7717: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
7718: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
7719: ,ppe.description
7720: ,ppe.object_type
7721: ,ppv.element_version_id
7714: )
7715: SELECT
7716: p_parent_project_id
7717: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
7718: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
7719: ,ppe.description
7720: ,ppe.object_type
7721: ,ppv.element_version_id
7722: ,ppe.proj_element_id
7731: ,por.relationship_type
7732: ,por.relationship_subtype
7733: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
7734: ,decode(ppe.object_type , 'PA_STRUCTURES', 'Y'
7735: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
7736: summary_element_flag -- Fix for Bug # 4490532.
7737: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
7738: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
7739: ,PPS.PROJECT_STATUS_NAME
8073: ,pa_proj_workplan_attr ppwa
8074: ,pa_proj_element_versions ppev6
8075: ,pa_proj_progress_attr pppa
8076: ,pa_proj_element_versions ppv2
8077: ,pa_tasks pt
8078: ,pa_proj_elements ppe
8079: ,pa_proj_element_versions ppv
8080: ,pa_object_relationships por
8081: ,pa_proj_elements ppeph
8088: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
8089: AND ppv.element_version_id = ppvsch.element_version_id (+)
8090: AND ppv.project_id = ppvsch.project_id (+)
8091: AND ppv.element_version_id = por.object_id_to1
8092: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
8093: AND ppe.manager_person_id = papf.person_id(+)
8094: AND ppe.object_type = 'PA_TASKS'
8095: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
8096: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8090: AND ppv.project_id = ppvsch.project_id (+)
8091: AND ppv.element_version_id = por.object_id_to1
8092: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
8093: AND ppe.manager_person_id = papf.person_id(+)
8094: AND ppe.object_type = 'PA_TASKS'
8095: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
8096: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8097: AND ppe.carrying_out_organization_id = hou.organization_id (+)
8098: AND userenv('LANG') = hou.language (+)
8096: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8097: AND ppe.carrying_out_organization_id = hou.organization_id (+)
8098: AND userenv('LANG') = hou.language (+)
8099: AND ppe.project_id = ppa.project_id
8100: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8101: AND por.object_id_from1 = ppv2.element_version_id(+)
8102: AND ppe.proj_element_id = ppst.proj_element_id(+)
8103: AND pst.structure_type_id(+) = ppst.structure_type_id
8104: AND por.relationship_type = 'S'
8106: AND ppv.proj_element_id = pt.task_id (+)
8107: AND pt.work_type_id = pwt.work_type_id (+)
8108: AND pwt.language (+) = userenv('lang')
8109: AND tt.task_type_id = ppe.type_id
8110: AND tt.object_type = 'PA_TASKS'
8111: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
8112: AND pps3.STATUS_TYPE (+) = 'TASK'
8113: --AND pt.address_id = addr.address_id (+)
8114: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
8122: AND ppru.current_flag (+) = 'Y'
8123: AND ppru.structure_version_id(+) IS NULL
8124: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
8125: ----AND ppc.project_id (+) = ppru.project_id
8126: AND 'PA_TASKS' = ppru.object_type (+)
8127: ----AND ppc.object_id (+) = ppru.object_id
8128: ----AND ppc.date_computed (+) = ppru.as_of_date
8129: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
8130: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
8473: , PROGRESS_ROLLUP_ID
8474: )
8475: SELECT
8476: p_parent_project_id
8477: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
8478: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
8479: ,ppe.description
8480: ,ppe.object_type
8481: ,ppv.element_version_id
8474: )
8475: SELECT
8476: p_parent_project_id
8477: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
8478: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
8479: ,ppe.description
8480: ,ppe.object_type
8481: ,ppv.element_version_id
8482: ,ppe.proj_element_id
8491: ,por.relationship_type
8492: ,por.relationship_subtype
8493: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
8494: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
8495: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
8496: summary_element_flag -- Fix for Bug # 4490532.
8497: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
8498: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code)
8499: ,PPS.PROJECT_STATUS_NAME
8833: ,pa_proj_workplan_attr ppwa
8834: ,pa_proj_element_versions ppev6
8835: ,pa_proj_progress_attr pppa
8836: ,pa_proj_element_versions ppv2
8837: ,pa_tasks pt
8838: ,pa_proj_elements ppe
8839: ,pa_proj_element_versions ppv
8840: ,pa_object_relationships por
8841: ,pa_proj_elements ppeph
8848: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
8849: AND ppv.element_version_id = ppvsch.element_version_id (+)
8850: AND ppv.project_id = ppvsch.project_id (+)
8851: AND ppv.element_version_id = por.object_id_to1
8852: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
8853: AND ppe.manager_person_id = papf.person_id(+)
8854: AND ppe.object_type = 'PA_TASKS'
8855: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
8856: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8850: AND ppv.project_id = ppvsch.project_id (+)
8851: AND ppv.element_version_id = por.object_id_to1
8852: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
8853: AND ppe.manager_person_id = papf.person_id(+)
8854: AND ppe.object_type = 'PA_TASKS'
8855: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
8856: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8857: AND ppe.carrying_out_organization_id = hou.organization_id (+)
8858: AND userenv('LANG') = hou.language (+)
8856: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
8857: AND ppe.carrying_out_organization_id = hou.organization_id (+)
8858: AND userenv('LANG') = hou.language (+)
8859: AND ppe.project_id = ppa.project_id
8860: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8861: AND por.object_id_from1 = ppv2.element_version_id(+)
8862: AND ppe.proj_element_id = ppst.proj_element_id(+)
8863: AND pst.structure_type_id(+) = ppst.structure_type_id
8864: AND por.relationship_type = 'S'
8866: AND ppv.proj_element_id = pt.task_id (+)
8867: AND pt.work_type_id = pwt.work_type_id (+)
8868: AND pwt.language (+) = userenv('lang')
8869: AND tt.task_type_id = ppe.type_id
8870: AND tt.object_type = 'PA_TASKS'
8871: AND ppe.status_code = pps3.PROJECT_STATUS_CODE (+)
8872: AND pps3.STATUS_TYPE (+) = 'TASK'
8873: --AND pt.address_id = addr.address_id (+)
8874: AND pt.ADDRESS_ID = S.CUST_ACCT_SITE_ID(+)
8881: AND ppru.structure_type (+) = 'WORKPLAN'
8882: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
8883: AND NVL(ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code) = pps.PROJECT_STATUS_CODE(+)
8884: ---AND ppc.project_id (+) = ppru.project_id
8885: AND 'PA_TASKS' = ppru.object_type (+)
8886: ---AND ppc.object_id (+) = ppru.object_id
8887: ---AND ppc.date_computed (+) = ppru.as_of_date
8888: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
8889: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
9276: )
9277: SELECT
9278: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
9279: p_parent_project_id
9280: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
9281: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
9282: ,ppe.description
9283: ,ppe.object_type
9284: ,ppv.element_version_id
9277: SELECT
9278: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
9279: p_parent_project_id
9280: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
9281: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
9282: ,ppe.description
9283: ,ppe.object_type
9284: ,ppv.element_version_id
9285: ,ppe.proj_element_id
9294: ,por.relationship_type
9295: ,por.relationship_subtype
9296: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
9297: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
9298: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
9299: summary_element_flag -- Fix for Bug # 4490532.
9300: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
9301: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
9302: ,PPS.PROJECT_STATUS_NAME
9782: ,pa_project_statuses pps
9783: ----,pa_percent_completes ppc
9784: ,pa_project_statuses pps5
9785: ,pa_task_types tt
9786: ,pa_tasks pt
9787: ,pa_proj_elements ppe
9788: ,pa_proj_element_versions ppv
9789: ,pa_object_relationships por
9790: ,pji_fm_xbs_accum_tmp1 pfxat
9796: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
9797: AND ppv.element_version_id = ppvsch.element_version_id (+)
9798: AND ppv.project_id = ppvsch.project_id (+)
9799: AND ppv.element_version_id = por.object_id_to1
9800: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
9801: AND ppe.manager_person_id = papf.person_id(+)
9802: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
9803: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
9804: AND ppe.priority_code = fl3.lookup_code(+)
9805: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
9806: AND ppe.carrying_out_organization_id = hou.organization_id (+)
9807: AND userenv('LANG') = hou.language (+)
9808: AND ppe.project_id = ppa.project_id
9809: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
9810: AND por.object_id_from1 = ppv2.element_version_id(+)
9811: AND ppe.proj_element_id = ppst.proj_element_id(+)
9812: AND pst.structure_type_id(+) = ppst.structure_type_id
9813: AND por.relationship_type = 'S'
9833: AND ppru.structure_type (+) = 'WORKPLAN'
9834: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
9835: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
9836: ----AND ppc.project_id (+) = ppru.project_id
9837: AND 'PA_TASKS' = ppru.object_type (+)
9838: ----AND ppc.object_id (+)= ppru.object_id
9839: ----AND ppc.date_computed (+)= ppru.as_of_date
9840: ----AND ppc.structure_type (+)=ppru.structure_type
9841: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
9841: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
9842: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
9843: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
9844: AND tt.task_type_id = ppe.type_id
9845: AND tt.object_type = 'PA_TASKS'
9846: AND ppe.project_id <> 0
9847: AND pfxat.project_id (+)= ppv.project_id
9848: AND pfxat.project_element_id (+)=ppv.proj_element_id
9849: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
10103: )
10104: SELECT
10105: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10106: p_parent_project_id
10107: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10108: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10109: ,ppe.description
10110: ,ppe.object_type
10111: ,ppv.element_version_id
10104: SELECT
10105: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10106: p_parent_project_id
10107: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10108: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10109: ,ppe.description
10110: ,ppe.object_type
10111: ,ppv.element_version_id
10112: ,ppe.proj_element_id
10121: ,por.relationship_type
10122: ,por.relationship_subtype
10123: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10124: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
10125: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10126: summary_element_flag -- Fix for Bug # 4490532.
10127: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10128: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
10129: ,PPS.PROJECT_STATUS_NAME
10609: ,pa_project_statuses pps
10610: ----,pa_percent_completes ppc
10611: ,pa_project_statuses pps5
10612: ,pa_task_types tt
10613: ,pa_tasks pt
10614: ,pa_proj_elements ppe
10615: ,pa_proj_element_versions ppv
10616: ,pa_object_relationships por
10617: ,pji_fm_xbs_accum_tmp1 pfxat
10623: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
10624: AND ppv.element_version_id = ppvsch.element_version_id (+)
10625: AND ppv.project_id = ppvsch.project_id (+)
10626: AND ppv.element_version_id = por.object_id_to1
10627: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
10628: AND ppe.manager_person_id = papf.person_id(+)
10629: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
10630: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
10631: AND ppe.priority_code = fl3.lookup_code(+)
10632: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
10633: AND ppe.carrying_out_organization_id = hou.organization_id (+)
10634: AND userenv('LANG') = hou.language (+)
10635: AND ppe.project_id = ppa.project_id
10636: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
10637: AND por.object_id_from1 = ppv2.element_version_id(+)
10638: AND ppe.proj_element_id = ppst.proj_element_id(+)
10639: AND pst.structure_type_id(+) = ppst.structure_type_id
10640: AND por.relationship_type = 'S'
10660: AND ppru.structure_type (+) = 'WORKPLAN'
10661: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
10662: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
10663: ----AND ppc.project_id (+) = ppru.project_id
10664: AND 'PA_TASKS' = ppru.object_type (+)
10665: ----AND ppc.object_id (+)= ppru.object_id
10666: ----AND ppc.date_computed (+)= ppru.as_of_date
10667: ----AND ppc.structure_type (+)=ppru.structure_type
10668: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
10668: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
10669: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
10670: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
10671: AND tt.task_type_id = ppe.type_id
10672: AND tt.object_type = 'PA_TASKS'
10673: AND ppe.project_id <> 0
10674: AND pfxat.project_id (+)= ppv.project_id
10675: AND pfxat.project_element_id (+)=ppv.proj_element_id
10676: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
10931: )
10932: SELECT
10933: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10934: p_parent_project_id
10935: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10936: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10937: ,ppe.description
10938: ,ppe.object_type
10939: ,ppv.element_version_id
10932: SELECT
10933: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
10934: p_parent_project_id
10935: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
10936: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
10937: ,ppe.description
10938: ,ppe.object_type
10939: ,ppv.element_version_id
10940: ,ppe.proj_element_id
10949: ,por.relationship_type
10950: ,por.relationship_subtype
10951: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
10952: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
10953: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
10954: summary_element_flag -- Fix for Bug # 4490532.
10955: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
10956: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
10957: ,PPS.PROJECT_STATUS_NAME
11437: ,pa_project_statuses pps
11438: ----,pa_percent_completes ppc
11439: ,pa_project_statuses pps5
11440: ,pa_task_types tt
11441: ,pa_tasks pt
11442: ,pa_proj_elements ppe
11443: ,pa_proj_element_versions ppv
11444: ,pa_object_relationships por
11445: ,pji_fm_xbs_accum_tmp1 pfxat
11451: AND ppvs.status_code <> 'STRUCTURE_PUBLISHED'
11452: AND ppv.element_version_id = ppvsch.element_version_id (+)
11453: AND ppv.project_id = ppvsch.project_id (+)
11454: AND ppv.element_version_id = por.object_id_to1
11455: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
11456: AND ppe.manager_person_id = papf.person_id(+)
11457: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
11458: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
11459: AND ppe.priority_code = fl3.lookup_code(+)
11460: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
11461: AND ppe.carrying_out_organization_id = hou.organization_id (+)
11462: AND userenv('LANG') = hou.language (+)
11463: AND ppe.project_id = ppa.project_id
11464: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
11465: AND por.object_id_from1 = ppv2.element_version_id(+)
11466: AND ppe.proj_element_id = ppst.proj_element_id(+)
11467: AND pst.structure_type_id(+) = ppst.structure_type_id
11468: AND por.relationship_type = 'S'
11488: AND ppru.structure_type (+) = 'WORKPLAN'
11489: AND ppv.parent_structure_version_id = ppru.structure_version_id (+)
11490: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
11491: ----AND ppc.project_id (+) = ppru.project_id
11492: AND 'PA_TASKS' = ppru.object_type (+)
11493: ----AND ppc.object_id (+)= ppru.object_id
11494: ----AND ppc.date_computed (+)= ppru.as_of_date
11495: ----AND ppc.structure_type (+)=ppru.structure_type
11496: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
11496: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
11497: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
11498: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
11499: AND tt.task_type_id = ppe.type_id
11500: AND tt.object_type = 'PA_TASKS'
11501: AND ppe.project_id <> 0
11502: AND pfxat.project_id (+)= ppv.project_id
11503: AND pfxat.project_element_id (+)=ppv.proj_element_id
11504: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
11894: )
11895: SELECT
11896: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
11897: p_parent_project_id
11898: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
11899: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
11900: ,ppe.description
11901: ,ppe.object_type
11902: ,ppv.element_version_id
11895: SELECT
11896: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
11897: p_parent_project_id
11898: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
11899: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
11900: ,ppe.description
11901: ,ppe.object_type
11902: ,ppv.element_version_id
11903: ,ppe.proj_element_id
11912: ,por.relationship_type
11913: ,por.relationship_subtype
11914: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
11915: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
11916: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
11917: summary_element_flag -- Fix for Bug # 4490532.
11918: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
11919: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
11920: ,PPS.PROJECT_STATUS_NAME
12361: ,pa_project_statuses pps
12362: ----,pa_percent_completes ppc
12363: ,pa_project_statuses pps5
12364: ,pa_task_types tt
12365: ,pa_tasks pt
12366: ,pa_proj_elements ppe
12367: ,pa_proj_element_versions ppv
12368: ,pa_object_relationships por
12369: ,pji_fm_xbs_accum_tmp1 pfxat
12375: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
12376: AND ppv.element_version_id = ppvsch.element_version_id (+)
12377: AND ppv.project_id = ppvsch.project_id (+)
12378: AND ppv.element_version_id = por.object_id_to1
12379: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
12380: AND ppe.manager_person_id = papf.person_id(+)
12381: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
12382: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
12383: AND ppe.priority_code = fl3.lookup_code(+)
12384: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
12385: AND ppe.carrying_out_organization_id = hou.organization_id (+)
12386: AND userenv('LANG') = hou.language (+)
12387: AND ppe.project_id = ppa.project_id
12388: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
12389: AND por.object_id_from1 = ppv2.element_version_id(+)
12390: AND ppe.proj_element_id = ppst.proj_element_id(+)
12391: AND pst.structure_type_id(+) = ppst.structure_type_id
12392: AND por.relationship_type = 'S'
12413: AND ppru.structure_version_id is null
12414: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
12415: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
12416: ---AND ppc.project_id (+) = ppru.project_id
12417: AND 'PA_TASKS' = ppru.object_type (+)
12418: ---AND ppc.object_id (+)= ppru.object_id
12419: ---AND ppc.date_computed (+)= ppru.as_of_date
12420: ---AND ppc.structure_type (+)=ppru.structure_type
12421: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
12421: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
12422: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
12423: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
12424: AND tt.task_type_id = ppe.type_id
12425: AND tt.object_type = 'PA_TASKS'
12426: AND ppe.project_id <> 0
12427: AND pfxat.project_id (+)= ppv.project_id
12428: AND pfxat.project_element_id (+)=ppv.proj_element_id
12429: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
12690: )
12691: SELECT
12692: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
12693: p_parent_project_id
12694: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
12695: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
12696: ,ppe.description
12697: ,ppe.object_type
12698: ,ppv.element_version_id
12691: SELECT
12692: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
12693: p_parent_project_id
12694: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
12695: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
12696: ,ppe.description
12697: ,ppe.object_type
12698: ,ppv.element_version_id
12699: ,ppe.proj_element_id
12708: ,por.relationship_type
12709: ,por.relationship_subtype
12710: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
12711: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
12712: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
12713: summary_element_flag -- Fix for Bug # 4490532.
12714: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
12715: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
12716: ,PPS.PROJECT_STATUS_NAME
13157: ,pa_project_statuses pps
13158: ----,pa_percent_completes ppc
13159: ,pa_project_statuses pps5
13160: ,pa_task_types tt
13161: ,pa_tasks pt
13162: ,pa_proj_elements ppe
13163: ,pa_proj_element_versions ppv
13164: ,pa_object_relationships por
13165: ,pji_fm_xbs_accum_tmp1 pfxat
13171: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
13172: AND ppv.element_version_id = ppvsch.element_version_id (+)
13173: AND ppv.project_id = ppvsch.project_id (+)
13174: AND ppv.element_version_id = por.object_id_to1
13175: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
13176: AND ppe.manager_person_id = papf.person_id(+)
13177: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
13178: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
13179: AND ppe.priority_code = fl3.lookup_code(+)
13180: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
13181: AND ppe.carrying_out_organization_id = hou.organization_id (+)
13182: AND userenv('LANG') = hou.language (+)
13183: AND ppe.project_id = ppa.project_id
13184: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
13185: AND por.object_id_from1 = ppv2.element_version_id(+)
13186: AND ppe.proj_element_id = ppst.proj_element_id(+)
13187: AND pst.structure_type_id(+) = ppst.structure_type_id
13188: AND por.relationship_type = 'S'
13209: AND ppru.structure_version_id is null
13210: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
13211: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
13212: ---AND ppc.project_id (+) = ppru.project_id
13213: AND 'PA_TASKS' = ppru.object_type (+)
13214: ---AND ppc.object_id (+)= ppru.object_id
13215: ---AND ppc.date_computed (+)= ppru.as_of_date
13216: ---AND ppc.structure_type (+)=ppru.structure_type
13217: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13217: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
13218: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
13219: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
13220: AND tt.task_type_id = ppe.type_id
13221: AND tt.object_type = 'PA_TASKS'
13222: AND ppe.project_id <> 0
13223: AND pfxat.project_id (+)= ppv.project_id
13224: AND pfxat.project_element_id (+)=ppv.proj_element_id
13225: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id
13487: )
13488: SELECT
13489: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
13490: p_parent_project_id
13491: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
13492: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
13493: ,ppe.description
13494: ,ppe.object_type
13495: ,ppv.element_version_id
13488: SELECT
13489: /*+ INDEX(pji_fm_xbs_accum_tmp1 pji_fm_xbs_accum_tmp1_n1)*/
13490: p_parent_project_id
13491: ,decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) )
13492: ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name )
13493: ,ppe.description
13494: ,ppe.object_type
13495: ,ppv.element_version_id
13496: ,ppe.proj_element_id
13505: ,por.relationship_type
13506: ,por.relationship_subtype
13507: -- ,decode(ppv.prg_group, null -- Fix for Bug # 4490532.
13508: ,decode(ppe.object_type, 'PA_STRUCTURES', 'Y'
13509: , 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ppv.element_version_id))
13510: summary_element_flag -- Fix for Bug # 4490532.
13511: -- , 'Y') -- Fix for Bug # 4279419. -- Fix for Bug # 4490532.
13512: ,NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code )
13513: ,PPS.PROJECT_STATUS_NAME
13954: ,pa_project_statuses pps
13955: ----,pa_percent_completes ppc
13956: ,pa_project_statuses pps5
13957: ,pa_task_types tt
13958: ,pa_tasks pt
13959: ,pa_proj_elements ppe
13960: ,pa_proj_element_versions ppv
13961: ,pa_object_relationships por
13962: ,pji_fm_xbs_accum_tmp1 pfxat
13968: AND ppvs.status_code = 'STRUCTURE_PUBLISHED'
13969: AND ppv.element_version_id = ppvsch.element_version_id (+)
13970: AND ppv.project_id = ppvsch.project_id (+)
13971: AND ppv.element_version_id = por.object_id_to1
13972: AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
13973: AND ppe.manager_person_id = papf.person_id(+)
13974: AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+)
13975: AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+)
13976: AND ppe.priority_code = fl3.lookup_code(+)
13977: AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE'
13978: AND ppe.carrying_out_organization_id = hou.organization_id (+)
13979: AND userenv('LANG') = hou.language (+)
13980: AND ppe.project_id = ppa.project_id
13981: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
13982: AND por.object_id_from1 = ppv2.element_version_id(+)
13983: AND ppe.proj_element_id = ppst.proj_element_id(+)
13984: AND pst.structure_type_id(+) = ppst.structure_type_id
13985: AND por.relationship_type = 'S'
14006: AND ppru.structure_version_id is null
14007: AND NVL( ppru.current_flag (+), 'N' ) = 'Y'
14008: AND NVL( ppru.PROGRESS_STATUS_CODE, ppru.eff_rollup_prog_stat_code ) = pps.PROJECT_STATUS_CODE(+)
14009: ---AND ppc.project_id (+) = ppru.project_id
14010: AND 'PA_TASKS' = ppru.object_type (+)
14011: ---AND ppc.object_id (+)= ppru.object_id
14012: ---AND ppc.date_computed (+)= ppru.as_of_date
14013: ---AND ppc.structure_type (+)=ppru.structure_type
14014: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
14014: AND PPE.PHASE_VERSION_ID = PPV5.ELEMENT_VERSION_ID (+)
14015: AND PPV5.PROJ_ELEMENT_ID = PPE5.PROJ_ELEMENT_ID (+)
14016: AND PPE5.PHASE_CODE = PPS5.PROJECT_STATUS_CODE (+)
14017: AND tt.task_type_id = ppe.type_id
14018: AND tt.object_type = 'PA_TASKS'
14019: AND ppe.project_id <> 0
14020: AND pfxat.project_id (+)= ppv.project_id
14021: AND pfxat.project_element_id (+)=ppv.proj_element_id
14022: AND pfxat.struct_version_id (+)=ppv.parent_structure_version_id