VIEW: APPS.PA_LATEST_PUB_STRUC_TASKS_V

Source

View Text - Preformatted

SELECT decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) ) ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name ) ,ppe.description ,ppe.object_type ,ppv.element_version_id ,ppe.proj_element_id ,ppe.project_id ,ppv.display_sequence ,ppvsch.milestone_flag ,fl1.meaning ,ppvsch.critical_flag ,fl2.meaning ,por.object_id_from1 ,por.object_type_from ,por.relationship_type ,por.relationship_subtype ,decode( ppe.object_type , 'PA_STRUCTURES', 'Y', 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( ppv.element_version_id ) ) ,ppc.PROGRESS_STATUS_CODE ,PPS.PROJECT_STATUS_NAME ,ppc.PROGRESS_COMMENT ,ppvsch.scheduled_start_date ,ppvsch.scheduled_finish_date ,ppe.manager_person_id ,papf.FULL_NAME ,ppv.parent_structure_version_id ,ppv.wbs_level ,ppv.wbs_number ,ppe.record_version_number ,ppv.record_version_number ,ppvsch.record_version_number ,pps.status_icon_active_ind ,ppc.percent_complete_id ,pps.status_icon_ind ,ppe.status_code ,pps2.project_status_name ,pps2.PROJECT_SYSTEM_STATUS_CODE ,ppe.priority_code ,fl3.meaning ,ppe.carrying_out_organization_id ,hou.name ,ppe.inc_proj_progress_flag ,ppvsch.estimated_start_date ,ppvsch.estimated_finish_date ,ppvsch.actual_start_date ,ppvsch.actual_finish_date ,ppc.COMPLETED_PERCENTAGE ,por.object_relationship_id ,por.record_version_number ,ppvsch.pev_schedule_id ,ppa.segment1 ,ppa.name ,ppv2.proj_element_id ,pst.structure_type ,pst.structure_type_class_code ,ppc.DATE_COMPUTED ,ppe.BASELINE_START_DATE ,ppe.BASELINE_finish_DATE ,ppvsch.WQ_PLANNED_QUANTITY ,ppvsch.PLANNED_effort ,pt.start_date ,pt.completion_date ,pt.SERVICE_TYPE_CODE ,pt.WORK_TYPE_ID , decode(tt.WQ_ENABLE_FLAG, 'Y', decode(pppa.WQ_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , decode(tt.PERCENT_COMP_ENABLE_FLAG, 'Y', decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , decode(tt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , tt.INITIAL_PROGRESS_STATUS_CODE , tt.BASE_PERCENT_COMP_DERIV_CODE , NULL , ppe.WQ_ITEM_CODE , ppe.WQ_UOM_CODE , ppe.WQ_ACTUAL_ENTRY_CODE , ppe.TASK_PROGRESS_ENTRY_PAGE_ID , ppe.PROGRESS_OUTDATED_FLAG , ppe.last_update_date , ppvsch.last_update_date , ppe.rowid ,tt.INITIAL_STATUS_CODE ,tt.PROG_ENTRY_ENABLE_FLAG ,tt.PROG_ENTRY_REQ_FLAG FROM pa_proj_elements ppe ,pa_proj_element_versions ppv ,pa_proj_elem_ver_structure ppvs ,pa_proj_elem_ver_schedule ppvsch ,pa_object_relationships por ,per_all_people_f papf ,fnd_lookups fl1 ,fnd_lookups fl2 ,pa_project_statuses pps2 ,pa_lookups fl3 ,hr_all_organization_units_tl hou ,pa_projects_all ppa ,pa_proj_element_versions ppv2 ,pa_proj_structure_types ppst ,pa_structure_types pst ,pa_proj_elem_ver_structure ppvs2 ,pa_tasks pt ,pa_proj_progress_attr pppa ,pa_task_types tt ,pa_percent_completes ppc ,pa_project_statuses pps WHERE ppe.proj_element_id = ppv.proj_element_id AND ppe.link_task_flag <> 'Y' AND ppv.element_version_id = ppvs.element_version_id (+) AND ppv.project_id = ppvs.project_id (+) AND ppv.element_version_id = ppvsch.element_version_id (+) AND ppv.project_id = ppvsch.project_id (+) AND ppv.element_version_id = por.object_id_to1 AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS') AND ppe.manager_person_id = papf.person_id(+) AND NVL( ppvsch.milestone_flag, 'N' ) = fl1.lookup_code AND NVL( ppvsch.critical_flag, 'N' ) = fl2.lookup_code AND fl1.lookup_type = 'YES_NO' AND fl2.lookup_type = 'YES_NO' AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+) AND ppe.priority_code = fl3.lookup_code(+) AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE' AND ppe.carrying_out_organization_id = hou.organization_id (+) AND userenv('LANG') = hou.language(+) AND ppe.project_id = ppa.project_id AND por.object_id_from1 = ppv2.element_version_id(+) AND por.relationship_type (+) = 'S' AND ppvs2.project_id = ppv.project_id AND ppvs2.element_version_id = ppv.parent_structure_version_id AND ppvs2.latest_eff_published_flag = 'Y' AND pst.structure_type_id = ppst.structure_type_id AND ppst.proj_element_id = ppvs2.proj_element_id AND ppe.proj_element_id = pt.task_id (+) AND ppe.project_id = pt.project_id(+) AND pppa.project_id (+) = ppvs2.project_id AND pppa.object_type (+) = 'PA_STRUCTURES' AND pppa.object_id (+) = ppvs2.proj_element_id AND ppe.type_code = tt.task_type_id (+) AND tt.object_type(+) = 'PA_TASKS' AND ppe.project_id = ppc.project_id(+) AND ppe.proj_element_id = ppc.object_id(+) AND ppe.object_type = ppc.object_type(+) AND NVL( ppc.current_flag(+), 'N' ) = 'Y' AND ppc.progress_status_code = pps.PROJECT_STATUS_CODE(+) AND ppe.project_id <> 0 AND ppc.structure_type(+)='WORKPLAN' AND pst.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN' UNION SELECT decode( ppe.object_type, 'PA_TASKS', ppe.element_number, 'PA_STRUCTURES', to_char( ppvs.version_number ) ) ,decode( ppe.object_type, 'PA_TASKS', ppe.name, 'PA_STRUCTURES', ppvs.name ) ,ppe.description ,ppe.object_type ,ppv.element_version_id ,ppe.proj_element_id ,ppe.project_id ,ppv.display_sequence ,ppvsch.milestone_flag ,fl1.meaning ,ppvsch.critical_flag ,fl2.meaning ,por.object_id_from1 ,por.object_type_from ,por.relationship_type ,por.relationship_subtype ,decode( ppe.object_type , 'PA_STRUCTURES', 'Y', 'PA_TASKS', PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( ppv.element_version_id ) ) ,ppc.PROGRESS_STATUS_CODE ,PPS.PROJECT_STATUS_NAME ,ppc.PROGRESS_COMMENT ,ppvsch.scheduled_start_date ,ppvsch.scheduled_finish_date ,ppe.manager_person_id ,papf.FULL_NAME ,ppv.parent_structure_version_id ,ppv.wbs_level ,ppv.wbs_number ,ppe.record_version_number ,ppv.record_version_number ,ppvsch.record_version_number ,pps.status_icon_active_ind ,ppc.percent_complete_id ,pps.status_icon_ind ,ppe.status_code ,pps2.project_status_name ,pps2.PROJECT_SYSTEM_STATUS_CODE ,ppe.priority_code ,fl3.meaning ,ppe.carrying_out_organization_id ,hou.name ,ppe.inc_proj_progress_flag ,ppvsch.estimated_start_date ,ppvsch.estimated_finish_date ,ppvsch.actual_start_date ,ppvsch.actual_finish_date ,ppc.COMPLETED_PERCENTAGE ,por.object_relationship_id ,por.record_version_number ,ppvsch.pev_schedule_id ,ppa.segment1 ,ppa.name ,ppv2.proj_element_id ,pst.structure_type ,pst.structure_type_class_code ,ppc.DATE_COMPUTED ,ppe.BASELINE_START_DATE ,ppe.BASELINE_finish_DATE ,ppvsch.WQ_PLANNED_QUANTITY ,ppvsch.PLANNED_effort ,pt.start_date ,pt.completion_date ,pt.SERVICE_TYPE_CODE ,pt.WORK_TYPE_ID , decode(tt.WQ_ENABLE_FLAG, 'Y', decode(pppa.WQ_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , decode(tt.PERCENT_COMP_ENABLE_FLAG, 'Y', decode(pppa.PERCENT_COMP_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , decode(tt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', decode(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N') , tt.INITIAL_PROGRESS_STATUS_CODE , tt.BASE_PERCENT_COMP_DERIV_CODE , NULL , ppe.WQ_ITEM_CODE , ppe.WQ_UOM_CODE , ppe.WQ_ACTUAL_ENTRY_CODE , ppe.TASK_PROGRESS_ENTRY_PAGE_ID , ppe.PROGRESS_OUTDATED_FLAG , ppe.last_update_date , ppvsch.last_update_date , ppe.rowid ,tt.INITIAL_STATUS_CODE ,tt.PROG_ENTRY_ENABLE_FLAG ,tt.PROG_ENTRY_REQ_FLAG FROM pa_proj_elements ppe ,pa_proj_element_versions ppv ,pa_proj_elem_ver_structure ppvs ,pa_proj_elem_ver_schedule ppvsch ,pa_object_relationships por ,per_all_people_f papf ,fnd_lookups fl1 ,fnd_lookups fl2 ,pa_project_statuses pps2 ,pa_lookups fl3 ,hr_all_organization_units_tl hou ,pa_projects_all ppa ,pa_proj_element_versions ppv2 ,pa_proj_structure_types ppst ,pa_structure_types pst ,pa_proj_elem_ver_structure ppvs2 ,pa_tasks pt ,pa_proj_progress_attr pppa ,pa_task_types tt ,pa_percent_completes ppc ,pa_project_statuses pps WHERE ppe.proj_element_id = ppv.proj_element_id AND ppe.link_task_flag <> 'Y' AND ppv.element_version_id = ppvs.element_version_id (+) AND ppv.project_id = ppvs.project_id (+) AND ppv.element_version_id = ppvsch.element_version_id (+) AND ppv.project_id = ppvsch.project_id (+) AND ppv.element_version_id = por.object_id_to1 AND por.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS') AND ppe.manager_person_id = papf.person_id(+) AND NVL( ppvsch.milestone_flag, 'N' ) = fl1.lookup_code AND NVL( ppvsch.critical_flag, 'N' ) = fl2.lookup_code AND fl1.lookup_type = 'YES_NO' AND fl2.lookup_type = 'YES_NO' AND SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) AND ppe.status_code = pps2.PROJECT_STATUS_CODE(+) AND ppe.priority_code = fl3.lookup_code(+) AND fl3.lookup_type(+) = 'PA_TASK_PRIORITY_CODE' AND ppe.carrying_out_organization_id = hou.organization_id (+) AND userenv('LANG') = hou.language (+) AND ppe.project_id = ppa.project_id AND por.object_id_from1 = ppv2.element_version_id(+) AND por.relationship_type (+) = 'S' AND ppvs2.project_id = ppv.project_id AND ppvs2.element_version_id = ppv.parent_structure_version_id AND ppvs2.latest_eff_published_flag = 'Y' AND pst.structure_type_id = ppst.structure_type_id AND ppst.proj_element_id = ppvs2.proj_element_id AND ppe.proj_element_id = pt.task_id (+) AND ppe.project_id = pt.project_id(+) AND pppa.project_id (+) = ppvs2.project_id AND pppa.object_type (+) = 'PA_STRUCTURES' AND pppa.object_id (+) = ppvs2.proj_element_id AND ppe.type_code = tt.task_type_id (+) AND tt.object_type(+) = 'PA_TASKS' AND ppe.project_id = ppc.project_id(+) AND ppe.proj_element_id = ppc.object_id(+) AND ppe.object_type = ppc.object_type(+) AND NVL( ppc.current_flag(+), 'N' ) = 'Y' AND ppc.progress_status_code = pps.PROJECT_STATUS_CODE(+) AND ppe.project_id <> 0 AND ppc.structure_type(+) = 'FINANCIAL' AND pst.STRUCTURE_TYPE_CLASS_CODE = 'FINANCIAL'

View Text - HTML Formatted

SELECT DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, 'PA_STRUCTURES'
, TO_CHAR( PPVS.VERSION_NUMBER ) )
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, 'PA_STRUCTURES'
, PPVS.NAME )
, PPE.DESCRIPTION
, PPE.OBJECT_TYPE
, PPV.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.DISPLAY_SEQUENCE
, PPVSCH.MILESTONE_FLAG
, FL1.MEANING
, PPVSCH.CRITICAL_FLAG
, FL2.MEANING
, POR.OBJECT_ID_FROM1
, POR.OBJECT_TYPE_FROM
, POR.RELATIONSHIP_TYPE
, POR.RELATIONSHIP_SUBTYPE
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE( PPV.ELEMENT_VERSION_ID ) )
, PPC.PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPC.PROGRESS_COMMENT
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPV.WBS_LEVEL
, PPV.WBS_NUMBER
, PPE.RECORD_VERSION_NUMBER
, PPV.RECORD_VERSION_NUMBER
, PPVSCH.RECORD_VERSION_NUMBER
, PPS.STATUS_ICON_ACTIVE_IND
, PPC.PERCENT_COMPLETE_ID
, PPS.STATUS_ICON_IND
, PPE.STATUS_CODE
, PPS2.PROJECT_STATUS_NAME
, PPS2.PROJECT_SYSTEM_STATUS_CODE
, PPE.PRIORITY_CODE
, FL3.MEANING
, PPE.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPE.INC_PROJ_PROGRESS_FLAG
, PPVSCH.ESTIMATED_START_DATE
, PPVSCH.ESTIMATED_FINISH_DATE
, PPVSCH.ACTUAL_START_DATE
, PPVSCH.ACTUAL_FINISH_DATE
, PPC.COMPLETED_PERCENTAGE
, POR.OBJECT_RELATIONSHIP_ID
, POR.RECORD_VERSION_NUMBER
, PPVSCH.PEV_SCHEDULE_ID
, PPA.SEGMENT1
, PPA.NAME
, PPV2.PROJ_ELEMENT_ID
, PST.STRUCTURE_TYPE
, PST.STRUCTURE_TYPE_CLASS_CODE
, PPC.DATE_COMPUTED
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPVSCH.WQ_PLANNED_QUANTITY
, PPVSCH.PLANNED_EFFORT
, PT.START_DATE
, PT.COMPLETION_DATE
, PT.SERVICE_TYPE_CODE
, PT.WORK_TYPE_ID
, DECODE(TT.WQ_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.WQ_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, DECODE(TT.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, DECODE(TT.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, TT.INITIAL_PROGRESS_STATUS_CODE
, TT.BASE_PERCENT_COMP_DERIV_CODE
, NULL
, PPE.WQ_ITEM_CODE
, PPE.WQ_UOM_CODE
, PPE.WQ_ACTUAL_ENTRY_CODE
, PPE.TASK_PROGRESS_ENTRY_PAGE_ID
, PPE.PROGRESS_OUTDATED_FLAG
, PPE.LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE
, PPE.ROWID
, TT.INITIAL_STATUS_CODE
, TT.PROG_ENTRY_ENABLE_FLAG
, TT.PROG_ENTRY_REQ_FLAG
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_OBJECT_RELATIONSHIPS POR
, PER_ALL_PEOPLE_F PAPF
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, PA_PROJECT_STATUSES PPS2
, PA_LOOKUPS FL3
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_PROJ_ELEM_VER_STRUCTURE PPVS2
, PA_TASKS PT
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_TASK_TYPES TT
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES PPS
WHERE PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPV.ELEMENT_VERSION_ID = PPVS.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVS.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = PPVSCH.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVSCH.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND POR.OBJECT_TYPE_TO IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND NVL( PPVSCH.MILESTONE_FLAG
, 'N' ) = FL1.LOOKUP_CODE
AND NVL( PPVSCH.CRITICAL_FLAG
, 'N' ) = FL2.LOOKUP_CODE
AND FL1.LOOKUP_TYPE = 'YES_NO'
AND FL2.LOOKUP_TYPE = 'YES_NO'
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.STATUS_CODE = PPS2.PROJECT_STATUS_CODE(+)
AND PPE.PRIORITY_CODE = FL3.LOOKUP_CODE(+)
AND FL3.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PPE.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND USERENV('LANG') = HOU.LANGUAGE(+)
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND POR.OBJECT_ID_FROM1 = PPV2.ELEMENT_VERSION_ID(+)
AND POR.RELATIONSHIP_TYPE (+) = 'S'
AND PPVS2.PROJECT_ID = PPV.PROJECT_ID
AND PPVS2.ELEMENT_VERSION_ID = PPV.PARENT_STRUCTURE_VERSION_ID
AND PPVS2.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PPST.PROJ_ELEMENT_ID = PPVS2.PROJ_ELEMENT_ID
AND PPE.PROJ_ELEMENT_ID = PT.TASK_ID (+)
AND PPE.PROJECT_ID = PT.PROJECT_ID(+)
AND PPPA.PROJECT_ID (+) = PPVS2.PROJECT_ID
AND PPPA.OBJECT_TYPE (+) = 'PA_STRUCTURES'
AND PPPA.OBJECT_ID (+) = PPVS2.PROJ_ELEMENT_ID
AND PPE.TYPE_CODE = TT.TASK_TYPE_ID (+)
AND TT.OBJECT_TYPE(+) = 'PA_TASKS'
AND PPE.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND PPE.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND NVL( PPC.CURRENT_FLAG(+)
, 'N' ) = 'Y'
AND PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPE.PROJECT_ID <> 0
AND PPC.STRUCTURE_TYPE(+)='WORKPLAN'
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN' UNION SELECT DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, 'PA_STRUCTURES'
, TO_CHAR( PPVS.VERSION_NUMBER ) )
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, 'PA_STRUCTURES'
, PPVS.NAME )
, PPE.DESCRIPTION
, PPE.OBJECT_TYPE
, PPV.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPV.DISPLAY_SEQUENCE
, PPVSCH.MILESTONE_FLAG
, FL1.MEANING
, PPVSCH.CRITICAL_FLAG
, FL2.MEANING
, POR.OBJECT_ID_FROM1
, POR.OBJECT_TYPE_FROM
, POR.RELATIONSHIP_TYPE
, POR.RELATIONSHIP_SUBTYPE
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, 'Y'
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE( PPV.ELEMENT_VERSION_ID ) )
, PPC.PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPC.PROGRESS_COMMENT
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPV.WBS_LEVEL
, PPV.WBS_NUMBER
, PPE.RECORD_VERSION_NUMBER
, PPV.RECORD_VERSION_NUMBER
, PPVSCH.RECORD_VERSION_NUMBER
, PPS.STATUS_ICON_ACTIVE_IND
, PPC.PERCENT_COMPLETE_ID
, PPS.STATUS_ICON_IND
, PPE.STATUS_CODE
, PPS2.PROJECT_STATUS_NAME
, PPS2.PROJECT_SYSTEM_STATUS_CODE
, PPE.PRIORITY_CODE
, FL3.MEANING
, PPE.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPE.INC_PROJ_PROGRESS_FLAG
, PPVSCH.ESTIMATED_START_DATE
, PPVSCH.ESTIMATED_FINISH_DATE
, PPVSCH.ACTUAL_START_DATE
, PPVSCH.ACTUAL_FINISH_DATE
, PPC.COMPLETED_PERCENTAGE
, POR.OBJECT_RELATIONSHIP_ID
, POR.RECORD_VERSION_NUMBER
, PPVSCH.PEV_SCHEDULE_ID
, PPA.SEGMENT1
, PPA.NAME
, PPV2.PROJ_ELEMENT_ID
, PST.STRUCTURE_TYPE
, PST.STRUCTURE_TYPE_CLASS_CODE
, PPC.DATE_COMPUTED
, PPE.BASELINE_START_DATE
, PPE.BASELINE_FINISH_DATE
, PPVSCH.WQ_PLANNED_QUANTITY
, PPVSCH.PLANNED_EFFORT
, PT.START_DATE
, PT.COMPLETION_DATE
, PT.SERVICE_TYPE_CODE
, PT.WORK_TYPE_ID
, DECODE(TT.WQ_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.WQ_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, DECODE(TT.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.PERCENT_COMP_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, DECODE(TT.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, DECODE(PPPA.REMAIN_EFFORT_ENABLE_FLAG
, 'Y'
, 'Y'
, 'N')
, 'N')
, TT.INITIAL_PROGRESS_STATUS_CODE
, TT.BASE_PERCENT_COMP_DERIV_CODE
, NULL
, PPE.WQ_ITEM_CODE
, PPE.WQ_UOM_CODE
, PPE.WQ_ACTUAL_ENTRY_CODE
, PPE.TASK_PROGRESS_ENTRY_PAGE_ID
, PPE.PROGRESS_OUTDATED_FLAG
, PPE.LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE
, PPE.ROWID
, TT.INITIAL_STATUS_CODE
, TT.PROG_ENTRY_ENABLE_FLAG
, TT.PROG_ENTRY_REQ_FLAG
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_OBJECT_RELATIONSHIPS POR
, PER_ALL_PEOPLE_F PAPF
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, PA_PROJECT_STATUSES PPS2
, PA_LOOKUPS FL3
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_PROJ_ELEM_VER_STRUCTURE PPVS2
, PA_TASKS PT
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_TASK_TYPES TT
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES PPS
WHERE PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPV.ELEMENT_VERSION_ID = PPVS.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVS.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = PPVSCH.ELEMENT_VERSION_ID (+)
AND PPV.PROJECT_ID = PPVSCH.PROJECT_ID (+)
AND PPV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND POR.OBJECT_TYPE_TO IN ('PA_STRUCTURES'
, 'PA_TASKS')
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND NVL( PPVSCH.MILESTONE_FLAG
, 'N' ) = FL1.LOOKUP_CODE
AND NVL( PPVSCH.CRITICAL_FLAG
, 'N' ) = FL2.LOOKUP_CODE
AND FL1.LOOKUP_TYPE = 'YES_NO'
AND FL2.LOOKUP_TYPE = 'YES_NO'
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PPE.STATUS_CODE = PPS2.PROJECT_STATUS_CODE(+)
AND PPE.PRIORITY_CODE = FL3.LOOKUP_CODE(+)
AND FL3.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PPE.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID (+)
AND USERENV('LANG') = HOU.LANGUAGE (+)
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND POR.OBJECT_ID_FROM1 = PPV2.ELEMENT_VERSION_ID(+)
AND POR.RELATIONSHIP_TYPE (+) = 'S'
AND PPVS2.PROJECT_ID = PPV.PROJECT_ID
AND PPVS2.ELEMENT_VERSION_ID = PPV.PARENT_STRUCTURE_VERSION_ID
AND PPVS2.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PST.STRUCTURE_TYPE_ID = PPST.STRUCTURE_TYPE_ID
AND PPST.PROJ_ELEMENT_ID = PPVS2.PROJ_ELEMENT_ID
AND PPE.PROJ_ELEMENT_ID = PT.TASK_ID (+)
AND PPE.PROJECT_ID = PT.PROJECT_ID(+)
AND PPPA.PROJECT_ID (+) = PPVS2.PROJECT_ID
AND PPPA.OBJECT_TYPE (+) = 'PA_STRUCTURES'
AND PPPA.OBJECT_ID (+) = PPVS2.PROJ_ELEMENT_ID
AND PPE.TYPE_CODE = TT.TASK_TYPE_ID (+)
AND TT.OBJECT_TYPE(+) = 'PA_TASKS'
AND PPE.PROJECT_ID = PPC.PROJECT_ID(+)
AND PPE.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND PPE.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND NVL( PPC.CURRENT_FLAG(+)
, 'N' ) = 'Y'
AND PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPE.PROJECT_ID <> 0
AND PPC.STRUCTURE_TYPE(+) = 'FINANCIAL'
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'FINANCIAL'