VIEW: APPS.PA_STRUCT_TASKS_AMG_V

Source

View Text - Preformatted

SELECT PEV.ROWID , PE.proj_element_id , PE.project_id , PE.element_number , PEV.creation_date , PEV.created_by , PEV.last_update_date , PEV.last_updated_by , TASK.LAST_UPDATE_LOGIN , nvl(PE.name,TASK.TASK_NAME) , nvl(PE.name, TASK.LONG_TASK_NAME) , TASK.TOP_TASK_ID , PEV.wbs_level , TASK.READY_TO_BILL_FLAG , TASK.READY_TO_DISTRIBUTE_FLAG , nvl(PE.parent_structure_id,TASK.PARENT_TASK_ID) , nvl(PE.description, TASK.DESCRIPTION) , PE.carrying_out_organization_id , TASK.SERVICE_TYPE_CODE , nvl(PE.manager_person_id,TASK.TASK_MANAGER_PERSON_ID) , TASK.CHARGEABLE_FLAG , TASK.BILLABLE_FLAG , TASK.LIMIT_TO_TXN_CONTROLS_FLAG , TASK.START_DATE , TASK.COMPLETION_DATE , TASK.ADDRESS_ID , TASK.LABOR_BILL_RATE_ORG_ID , TASK.LABOR_STD_BILL_RATE_SCHDL , TASK.LABOR_SCHEDULE_FIXED_DATE , TASK.LABOR_SCHEDULE_DISCOUNT , TASK.NON_LABOR_BILL_RATE_ORG_ID , TASK.NON_LABOR_STD_BILL_RATE_SCHDL , TASK.NON_LABOR_SCHEDULE_FIXED_DATE , TASK.NON_LABOR_SCHEDULE_DISCOUNT , TASK.LABOR_COST_MULTIPLIER_NAME , nvl(PE.request_id,TASK.REQUEST_ID) , nvl(PE.program_application_id, TASK.PROGRAM_APPLICATION_ID) , nvl(PE.program_id, TASK.PROGRAM_ID) , nvl(PE.program_update_date, TASK.PROGRAM_UPDATE_DATE) , nvl(PEV.attribute_category, TASK.ATTRIBUTE_CATEGORY) , nvl(PEV.attribute1, TASK.ATTRIBUTE1) , nvl(PEV.attribute2, TASK.ATTRIBUTE2) , nvl(PEV.attribute3, TASK.ATTRIBUTE3) , nvl(PEV.attribute4, TASK.ATTRIBUTE4) , nvl(PEV.attribute5, TASK.ATTRIBUTE5) , nvl(PEV.attribute6, TASK.ATTRIBUTE6) , nvl(PEV.attribute7, TASK.ATTRIBUTE7) , nvl(PEV.attribute8, TASK.ATTRIBUTE8) , nvl(PEV.attribute9, TASK.ATTRIBUTE9) , nvl(PEV.attribute10,TASK.ATTRIBUTE10) , TASK.COST_IND_RATE_SCH_ID , TASK.REV_IND_RATE_SCH_ID , TASK.INV_IND_RATE_SCH_ID , TASK.COST_IND_SCH_FIXED_DATE , TASK.REV_IND_SCH_FIXED_DATE , TASK.INV_IND_SCH_FIXED_DATE , TASK.LABOR_SCH_TYPE , TASK.NON_LABOR_SCH_TYPE , nvl(PE.pm_source_reference,TASK.PM_TASK_REFERENCE) , nvl(PE.pm_source_code, TASK.PM_PRODUCT_CODE) ,decode(pa_task_utils.check_child_exists(task.task_id),1,'+',0,' ') ,nvl(PES.actual_start_date, TASK.ACTUAL_START_DATE) ,nvl(PES.actual_finish_date, TASK.ACTUAL_FINISH_DATE) ,nvl(PES.early_start_date, TASK.EARLY_START_DATE) ,nvl(PES.early_finish_date, TASK.EARLY_FINISH_DATE) ,nvl(PES.late_start_date, TASK.LATE_START_DATE) ,nvl(PES.late_finish_date, TASK.LATE_FINISH_DATE) ,nvl(PES.scheduled_start_date, TASK.SCHEDULED_START_DATE) ,nvl(PES.scheduled_finish_date, TASK.SCHEDULED_FINISH_DATE) ,PE.priority_code ,PEV.display_sequence ,PEV.wbs_number ,PE.wq_item_code ,PE.wq_uom_code ,PE.wq_actual_entry_code ,PES.wq_planned_quantity ,PE.type_id ,PES.milestone_flag ,PES.critical_flag ,PE.status_code ,PEV.element_version_id ,PEV.parent_structure_version_id ,TASK.work_type_id ,(nvl(pxpv.labor_effort,0)+nvl(pxpv.equipment_effort,0)) ,PAPF.FULL_NAME ,TT.TASK_TYPE ,PWT.NAME ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export(PEV.element_version_id, ',') Dependencies ,pa_proj_elements_utils.convert_hr_to_days(pes.duration) ,pes.Constraint_Date ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',pes.constraint_type_code ) Constraint_Type ,pes.constraint_type_code ,pes.Free_Slack ,pes.Total_Slack ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export2(PEV.element_version_id, ',') Predecessors ,pes.level_assignments_flag ,pes.effort_driven_flag ,pev.financial_task_flag ,pes.def_sch_tool_tsk_type_code ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.element_version_id,PE.project_id) ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.element_version_id,PE.project_id) ,null ,null ,stype.structure_type ,ext_sch_duration ,ext_act_duration ,ext_remain_duration ,PEV.task_unpub_ver_status_code ,to_number(null) ,to_number(null) FROM PA_TASKS TASK ,pa_proj_elements PE ,pa_proj_structure_types typ ,pa_structure_types stype ,pa_proj_element_versions PEV ,pa_proj_elem_ver_schedule PES ,pa_task_types TT ,pa_work_types_vl PWT ,per_all_people_f PAPF ,pji_xbs_plans_prj_v pxpv WHERE PE.proj_element_id = TASK.task_id(+) and pe.Object_type = 'PA_TASKS' and PE.proj_element_id = PEV.proj_element_id and pe.link_task_flag = 'N' and PEV.element_version_id = PES.element_version_id(+) and PEV.project_id = PES.project_id (+) and PEV.proj_element_id = PES.proj_element_id (+) and pe.project_id = PEV.project_id and TASK.work_type_id = PWT.work_type_id(+) and PE.type_id = TT.task_type_id and TT.object_type = 'PA_TASKS' and PE.manager_person_id = PAPF.PERSON_ID(+) and SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) and pev.project_id = pxpv.project_id(+) and pev.proj_element_id = pxpv.proj_element_id(+) and pev.parent_structure_version_id = pxpv.structure_version_id(+) and stype.structure_type_id = typ.structure_type_id and pe.parent_structure_id = typ.proj_element_id and ( stype.structure_type = 'WORKPLAN' and (pxpv.structure_type(+) = 'WORKPLAN') and not exists ( select /*+ index(ppr2,PA_PROGRESS_ROLLUP_U2) */ 1 from pa_progress_rollup ppr2 where ppr2.project_id = pev.project_id and ppr2.proj_element_id = pev.proj_element_id and ppr2.object_version_id = pev.element_version_id and ppr2.object_id = pev.proj_element_id and ppr2.structure_type ='WORKPLAN' and ppr2.object_type = 'PA_TASKS' and ppr2.structure_version_id = pev.parent_structure_version_id ) ) UNION ALL SELECT PEV.ROWID , PE.proj_element_id , PE.project_id , PE.element_number , PEV.creation_date , PEV.created_by , PEV.last_update_date , PEV.last_updated_by , TASK.LAST_UPDATE_LOGIN , nvl(PE.name,TASK.TASK_NAME) , nvl(PE.name, TASK.LONG_TASK_NAME) , TASK.TOP_TASK_ID , PEV.wbs_level , TASK.READY_TO_BILL_FLAG , TASK.READY_TO_DISTRIBUTE_FLAG , nvl(PE.parent_structure_id,TASK.PARENT_TASK_ID) , nvl(PE.description, TASK.DESCRIPTION) , PE.carrying_out_organization_id , TASK.SERVICE_TYPE_CODE , nvl(PE.manager_person_id,TASK.TASK_MANAGER_PERSON_ID) , TASK.CHARGEABLE_FLAG , TASK.BILLABLE_FLAG , TASK.LIMIT_TO_TXN_CONTROLS_FLAG , TASK.START_DATE , TASK.COMPLETION_DATE , TASK.ADDRESS_ID , TASK.LABOR_BILL_RATE_ORG_ID , TASK.LABOR_STD_BILL_RATE_SCHDL , TASK.LABOR_SCHEDULE_FIXED_DATE , TASK.LABOR_SCHEDULE_DISCOUNT , TASK.NON_LABOR_BILL_RATE_ORG_ID , TASK.NON_LABOR_STD_BILL_RATE_SCHDL , TASK.NON_LABOR_SCHEDULE_FIXED_DATE , TASK.NON_LABOR_SCHEDULE_DISCOUNT , TASK.LABOR_COST_MULTIPLIER_NAME , nvl(PE.request_id,TASK.REQUEST_ID) , nvl(PE.program_application_id, TASK.PROGRAM_APPLICATION_ID) , nvl(PE.program_id, TASK.PROGRAM_ID) , nvl(PE.program_update_date, TASK.PROGRAM_UPDATE_DATE) , nvl(PEV.attribute_category, TASK.ATTRIBUTE_CATEGORY) , nvl(PEV.attribute1, TASK.ATTRIBUTE1) , nvl(PEV.attribute2, TASK.ATTRIBUTE2) , nvl(PEV.attribute3, TASK.ATTRIBUTE3) , nvl(PEV.attribute4, TASK.ATTRIBUTE4) , nvl(PEV.attribute5, TASK.ATTRIBUTE5) , nvl(PEV.attribute6, TASK.ATTRIBUTE6) , nvl(PEV.attribute7, TASK.ATTRIBUTE7) , nvl(PEV.attribute8, TASK.ATTRIBUTE8) , nvl(PEV.attribute9, TASK.ATTRIBUTE9) , nvl(PEV.attribute10,TASK.ATTRIBUTE10) , TASK.COST_IND_RATE_SCH_ID , TASK.REV_IND_RATE_SCH_ID , TASK.INV_IND_RATE_SCH_ID , TASK.COST_IND_SCH_FIXED_DATE , TASK.REV_IND_SCH_FIXED_DATE , TASK.INV_IND_SCH_FIXED_DATE , TASK.LABOR_SCH_TYPE , TASK.NON_LABOR_SCH_TYPE , nvl(PE.pm_source_reference,TASK.PM_TASK_REFERENCE) , nvl(PE.pm_source_code, TASK.PM_PRODUCT_CODE) ,decode(pa_task_utils.check_child_exists(task.task_id),1,'+',0,' ') ,nvl(PES.actual_start_date, TASK.ACTUAL_START_DATE) ,nvl(PES.actual_finish_date, TASK.ACTUAL_FINISH_DATE) ,nvl(PES.early_start_date, TASK.EARLY_START_DATE) ,nvl(PES.early_finish_date, TASK.EARLY_FINISH_DATE) ,nvl(PES.late_start_date, TASK.LATE_START_DATE) ,nvl(PES.late_finish_date, TASK.LATE_FINISH_DATE) ,nvl(PES.scheduled_start_date, TASK.SCHEDULED_START_DATE) ,nvl(PES.scheduled_finish_date, TASK.SCHEDULED_FINISH_DATE) ,PE.priority_code ,PEV.display_sequence ,PEV.wbs_number ,PE.wq_item_code ,PE.wq_uom_code ,PE.wq_actual_entry_code ,PES.wq_planned_quantity ,PE.type_id ,PES.milestone_flag ,PES.critical_flag ,PE.status_code ,PEV.element_version_id ,PEV.parent_structure_version_id ,TASK.work_type_id ,null ,PAPF.FULL_NAME ,TT.TASK_TYPE ,PWT.NAME ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export(PEV.element_version_id, ',') Dependencies ,pa_proj_elements_utils.convert_hr_to_days(pes.duration) ,pes.Constraint_Date ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',pes.constraint_type_code ) Constraint_Type ,pes.constraint_type_code ,pes.Free_Slack ,pes.Total_Slack ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export2(PEV.element_version_id, ',') Predecessors ,pes.level_assignments_flag ,pes.effort_driven_flag ,pev.financial_task_flag ,pes.def_sch_tool_tsk_type_code ,null ,null ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_IDS(PEV.element_version_id,PE.project_id) ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_NAMES(PEV.element_version_id,PE.project_id) ,stype.structure_type ,ext_sch_duration ,ext_act_duration ,ext_remain_duration ,PEV.task_unpub_ver_status_code ,to_number(null) ,to_number(null) FROM PA_TASKS TASK ,pa_proj_elements PE ,pa_proj_structure_types typ ,pa_structure_types stype ,pa_proj_element_versions PEV ,pa_proj_elem_ver_schedule PES ,pa_task_types TT ,pa_work_types_vl PWT ,per_all_people_f PAPF where PE.proj_element_id = TASK.task_id(+) and pe.Object_type = 'PA_TASKS' and PE.proj_element_id = PEV.proj_element_id and pe.link_task_flag = 'N' and PEV.element_version_id = PES.element_version_id(+) and PEV.project_id = PES.project_id (+) and PEV.proj_element_id = PES.proj_element_id (+) and pe.project_id = PEV.project_id and TASK.work_type_id = PWT.work_type_id(+) and PE.type_id = TT.task_type_id and TT.object_type = 'PA_TASKS' and PE.manager_person_id = PAPF.PERSON_ID(+) and SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) and stype.structure_type_id = typ.structure_type_id and pe.parent_structure_id = typ.proj_element_id and stype.structure_type = 'FINANCIAL' UNION ALL SELECT PEV.ROWID , PE.proj_element_id , PE.project_id , PE.element_number , PEV.creation_date , PEV.created_by , PEV.last_update_date , PEV.last_updated_by , TASK.LAST_UPDATE_LOGIN , nvl(PE.name,TASK.TASK_NAME) , nvl(PE.name, TASK.LONG_TASK_NAME) , TASK.TOP_TASK_ID , PEV.wbs_level , TASK.READY_TO_BILL_FLAG , TASK.READY_TO_DISTRIBUTE_FLAG , nvl(PE.parent_structure_id,TASK.PARENT_TASK_ID) , nvl(PE.description, TASK.DESCRIPTION) , PE.carrying_out_organization_id , TASK.SERVICE_TYPE_CODE , nvl(PE.manager_person_id,TASK.TASK_MANAGER_PERSON_ID) , TASK.CHARGEABLE_FLAG , TASK.BILLABLE_FLAG , TASK.LIMIT_TO_TXN_CONTROLS_FLAG , TASK.START_DATE , TASK.COMPLETION_DATE , TASK.ADDRESS_ID , TASK.LABOR_BILL_RATE_ORG_ID , TASK.LABOR_STD_BILL_RATE_SCHDL , TASK.LABOR_SCHEDULE_FIXED_DATE , TASK.LABOR_SCHEDULE_DISCOUNT , TASK.NON_LABOR_BILL_RATE_ORG_ID , TASK.NON_LABOR_STD_BILL_RATE_SCHDL , TASK.NON_LABOR_SCHEDULE_FIXED_DATE , TASK.NON_LABOR_SCHEDULE_DISCOUNT , TASK.LABOR_COST_MULTIPLIER_NAME , nvl(PE.request_id,TASK.REQUEST_ID) , nvl(PE.program_application_id, TASK.PROGRAM_APPLICATION_ID) , nvl(PE.program_id, TASK.PROGRAM_ID) , nvl(PE.program_update_date, TASK.PROGRAM_UPDATE_DATE) , nvl(PEV.attribute_category, TASK.ATTRIBUTE_CATEGORY) , nvl(PEV.attribute1, TASK.ATTRIBUTE1) , nvl(PEV.attribute2, TASK.ATTRIBUTE2) , nvl(PEV.attribute3, TASK.ATTRIBUTE3) , nvl(PEV.attribute4, TASK.ATTRIBUTE4) , nvl(PEV.attribute5, TASK.ATTRIBUTE5) , nvl(PEV.attribute6, TASK.ATTRIBUTE6) , nvl(PEV.attribute7, TASK.ATTRIBUTE7) , nvl(PEV.attribute8, TASK.ATTRIBUTE8) , nvl(PEV.attribute9, TASK.ATTRIBUTE9) , nvl(PEV.attribute10,TASK.ATTRIBUTE10) , TASK.COST_IND_RATE_SCH_ID , TASK.REV_IND_RATE_SCH_ID , TASK.INV_IND_RATE_SCH_ID , TASK.COST_IND_SCH_FIXED_DATE , TASK.REV_IND_SCH_FIXED_DATE , TASK.INV_IND_SCH_FIXED_DATE , TASK.LABOR_SCH_TYPE , TASK.NON_LABOR_SCH_TYPE , nvl(PE.pm_source_reference,TASK.PM_TASK_REFERENCE) , nvl(PE.pm_source_code, TASK.PM_PRODUCT_CODE) ,decode(pa_task_utils.check_child_exists(task.task_id),1,'+',0,' ') ,nvl(PES.actual_start_date, TASK.ACTUAL_START_DATE) ,nvl(PES.actual_finish_date, TASK.ACTUAL_FINISH_DATE) ,nvl(PES.early_start_date, TASK.EARLY_START_DATE) ,nvl(PES.early_finish_date, TASK.EARLY_FINISH_DATE) ,nvl(PES.late_start_date, TASK.LATE_START_DATE) ,nvl(PES.late_finish_date, TASK.LATE_FINISH_DATE) ,nvl(PES.scheduled_start_date, TASK.SCHEDULED_START_DATE) ,nvl(PES.scheduled_finish_date, TASK.SCHEDULED_FINISH_DATE) ,PE.priority_code ,PEV.display_sequence ,PEV.wbs_number ,PE.wq_item_code ,PE.wq_uom_code ,PE.wq_actual_entry_code ,PES.wq_planned_quantity ,PE.type_id ,PES.milestone_flag ,PES.critical_flag ,PE.status_code ,PEV.element_version_id ,PEV.parent_structure_version_id ,TASK.work_type_id ,(nvl(pxpv.labor_effort,0)+nvl(pxpv.equipment_effort,0)) ,PAPF.FULL_NAME ,TT.TASK_TYPE ,PWT.NAME ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export(PEV.element_version_id, ',') Dependencies ,pa_proj_elements_utils.convert_hr_to_days(pes.duration) ,pes.Constraint_Date ,PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE',pes.constraint_type_code ) Constraint_Type ,pes.constraint_type_code ,pes.Free_Slack ,pes.Total_Slack ,PA_PROJ_TASK_STRUC_PUB.Parse_Predecessor_Export2(PEV.element_version_id, ',') Predecessors ,pes.level_assignments_flag ,pes.effort_driven_flag ,pev.financial_task_flag ,pes.def_sch_tool_tsk_type_code ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.element_version_id,PE.project_id) ,PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.element_version_id,PE.project_id) ,null ,null ,NVL( pxpv.structure_type, stype.structure_type ) ,ext_sch_duration ,ext_act_duration ,ext_remain_duration ,PEV.task_unpub_ver_status_code ,nvl (ppr.completed_percentage, nvl(ppr.base_percent_complete, ppr.eff_rollup_percent_comp)) percent_complete ,pxpv.etc_labor_hrs etc_effort FROM PA_TASKS TASK ,pa_proj_elements PE ,pa_proj_structure_types typ ,pa_structure_types stype ,pa_proj_element_versions PEV ,pa_proj_elem_ver_schedule PES ,pa_task_types TT ,pa_work_types_vl PWT ,per_all_people_f PAPF ,pji_xbs_plans_prj_v pxpv ,pa_progress_rollup ppr where PE.proj_element_id = TASK.task_id(+) and pe.Object_type = 'PA_TASKS' and PE.proj_element_id = PEV.proj_element_id and pe.link_task_flag = 'N' and PEV.element_version_id = PES.element_version_id(+) and PEV.project_id = PES.project_id (+) and PEV.proj_element_id = PES.proj_element_id (+) and pe.project_id = PEV.project_id and TASK.work_type_id = PWT.work_type_id(+) and PE.type_id = TT.task_type_id and TT.object_type = 'PA_TASKS' and PE.manager_person_id = PAPF.PERSON_ID(+) and SYSDATE BETWEEN papf.effective_start_date(+) AND papf.effective_end_date (+) and pev.project_id = pxpv.project_id(+) and pev.proj_element_id = pxpv.proj_element_id(+) and pev.parent_structure_version_id = pxpv.structure_version_id(+) and stype.structure_type = 'WORKPLAN' and pxpv.structure_type(+)= 'WORKPLAN' and stype.structure_type_id = typ.structure_type_id and pe.parent_structure_id = typ.proj_element_id and ppr.object_id = PEV.proj_element_id and ppr.proj_element_id = PEV.proj_element_id and ppr.object_type = 'PA_TASKS' and ppr.project_id = PEV.project_id and ppr.structure_type = 'WORKPLAN' and ppr.structure_version_id = pev.parent_structure_version_id

View Text - HTML Formatted

SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, (NVL(PXPV.LABOR_EFFORT
, 0)+NVL(PXPV.EQUIPMENT_EFFORT
, 0))
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, NULL
, NULL
, STYPE.STRUCTURE_TYPE
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
, PJI_XBS_PLANS_PRJ_V PXPV
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PXPV.PROJECT_ID(+)
AND PEV.PROJ_ELEMENT_ID = PXPV.PROJ_ELEMENT_ID(+)
AND PEV.PARENT_STRUCTURE_VERSION_ID = PXPV.STRUCTURE_VERSION_ID(+)
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND ( STYPE.STRUCTURE_TYPE = 'WORKPLAN'
AND (PXPV.STRUCTURE_TYPE(+) = 'WORKPLAN')
AND NOT EXISTS ( SELECT /*+ INDEX(PPR2
, PA_PROGRESS_ROLLUP_U2) */ 1
FROM PA_PROGRESS_ROLLUP PPR2
WHERE PPR2.PROJECT_ID = PEV.PROJECT_ID
AND PPR2.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPR2.OBJECT_VERSION_ID = PEV.ELEMENT_VERSION_ID
AND PPR2.OBJECT_ID = PEV.PROJ_ELEMENT_ID
AND PPR2.STRUCTURE_TYPE ='WORKPLAN'
AND PPR2.OBJECT_TYPE = 'PA_TASKS'
AND PPR2.STRUCTURE_VERSION_ID = PEV.PARENT_STRUCTURE_VERSION_ID ) ) UNION ALL SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, NULL
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, NULL
, NULL
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_IDS(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_WKP_TASK_NAMES(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, STYPE.STRUCTURE_TYPE
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND STYPE.STRUCTURE_TYPE = 'FINANCIAL' UNION ALL SELECT PEV.ROWID
, PE.PROJ_ELEMENT_ID
, PE.PROJECT_ID
, PE.ELEMENT_NUMBER
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATE_DATE
, PEV.LAST_UPDATED_BY
, TASK.LAST_UPDATE_LOGIN
, NVL(PE.NAME
, TASK.TASK_NAME)
, NVL(PE.NAME
, TASK.LONG_TASK_NAME)
, TASK.TOP_TASK_ID
, PEV.WBS_LEVEL
, TASK.READY_TO_BILL_FLAG
, TASK.READY_TO_DISTRIBUTE_FLAG
, NVL(PE.PARENT_STRUCTURE_ID
, TASK.PARENT_TASK_ID)
, NVL(PE.DESCRIPTION
, TASK.DESCRIPTION)
, PE.CARRYING_OUT_ORGANIZATION_ID
, TASK.SERVICE_TYPE_CODE
, NVL(PE.MANAGER_PERSON_ID
, TASK.TASK_MANAGER_PERSON_ID)
, TASK.CHARGEABLE_FLAG
, TASK.BILLABLE_FLAG
, TASK.LIMIT_TO_TXN_CONTROLS_FLAG
, TASK.START_DATE
, TASK.COMPLETION_DATE
, TASK.ADDRESS_ID
, TASK.LABOR_BILL_RATE_ORG_ID
, TASK.LABOR_STD_BILL_RATE_SCHDL
, TASK.LABOR_SCHEDULE_FIXED_DATE
, TASK.LABOR_SCHEDULE_DISCOUNT
, TASK.NON_LABOR_BILL_RATE_ORG_ID
, TASK.NON_LABOR_STD_BILL_RATE_SCHDL
, TASK.NON_LABOR_SCHEDULE_FIXED_DATE
, TASK.NON_LABOR_SCHEDULE_DISCOUNT
, TASK.LABOR_COST_MULTIPLIER_NAME
, NVL(PE.REQUEST_ID
, TASK.REQUEST_ID)
, NVL(PE.PROGRAM_APPLICATION_ID
, TASK.PROGRAM_APPLICATION_ID)
, NVL(PE.PROGRAM_ID
, TASK.PROGRAM_ID)
, NVL(PE.PROGRAM_UPDATE_DATE
, TASK.PROGRAM_UPDATE_DATE)
, NVL(PEV.ATTRIBUTE_CATEGORY
, TASK.ATTRIBUTE_CATEGORY)
, NVL(PEV.ATTRIBUTE1
, TASK.ATTRIBUTE1)
, NVL(PEV.ATTRIBUTE2
, TASK.ATTRIBUTE2)
, NVL(PEV.ATTRIBUTE3
, TASK.ATTRIBUTE3)
, NVL(PEV.ATTRIBUTE4
, TASK.ATTRIBUTE4)
, NVL(PEV.ATTRIBUTE5
, TASK.ATTRIBUTE5)
, NVL(PEV.ATTRIBUTE6
, TASK.ATTRIBUTE6)
, NVL(PEV.ATTRIBUTE7
, TASK.ATTRIBUTE7)
, NVL(PEV.ATTRIBUTE8
, TASK.ATTRIBUTE8)
, NVL(PEV.ATTRIBUTE9
, TASK.ATTRIBUTE9)
, NVL(PEV.ATTRIBUTE10
, TASK.ATTRIBUTE10)
, TASK.COST_IND_RATE_SCH_ID
, TASK.REV_IND_RATE_SCH_ID
, TASK.INV_IND_RATE_SCH_ID
, TASK.COST_IND_SCH_FIXED_DATE
, TASK.REV_IND_SCH_FIXED_DATE
, TASK.INV_IND_SCH_FIXED_DATE
, TASK.LABOR_SCH_TYPE
, TASK.NON_LABOR_SCH_TYPE
, NVL(PE.PM_SOURCE_REFERENCE
, TASK.PM_TASK_REFERENCE)
, NVL(PE.PM_SOURCE_CODE
, TASK.PM_PRODUCT_CODE)
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK.TASK_ID)
, 1
, '+'
, 0
, ' ')
, NVL(PES.ACTUAL_START_DATE
, TASK.ACTUAL_START_DATE)
, NVL(PES.ACTUAL_FINISH_DATE
, TASK.ACTUAL_FINISH_DATE)
, NVL(PES.EARLY_START_DATE
, TASK.EARLY_START_DATE)
, NVL(PES.EARLY_FINISH_DATE
, TASK.EARLY_FINISH_DATE)
, NVL(PES.LATE_START_DATE
, TASK.LATE_START_DATE)
, NVL(PES.LATE_FINISH_DATE
, TASK.LATE_FINISH_DATE)
, NVL(PES.SCHEDULED_START_DATE
, TASK.SCHEDULED_START_DATE)
, NVL(PES.SCHEDULED_FINISH_DATE
, TASK.SCHEDULED_FINISH_DATE)
, PE.PRIORITY_CODE
, PEV.DISPLAY_SEQUENCE
, PEV.WBS_NUMBER
, PE.WQ_ITEM_CODE
, PE.WQ_UOM_CODE
, PE.WQ_ACTUAL_ENTRY_CODE
, PES.WQ_PLANNED_QUANTITY
, PE.TYPE_ID
, PES.MILESTONE_FLAG
, PES.CRITICAL_FLAG
, PE.STATUS_CODE
, PEV.ELEMENT_VERSION_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, TASK.WORK_TYPE_ID
, (NVL(PXPV.LABOR_EFFORT
, 0)+NVL(PXPV.EQUIPMENT_EFFORT
, 0))
, PAPF.FULL_NAME
, TT.TASK_TYPE
, PWT.NAME
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT(PEV.ELEMENT_VERSION_ID
, '
, ') DEPENDENCIES
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PES.DURATION)
, PES.CONSTRAINT_DATE
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING ( 'PA_SCHEDULE_CONSTRAINT_TYPE'
, PES.CONSTRAINT_TYPE_CODE ) CONSTRAINT_TYPE
, PES.CONSTRAINT_TYPE_CODE
, PES.FREE_SLACK
, PES.TOTAL_SLACK
, PA_PROJ_TASK_STRUC_PUB.PARSE_PREDECESSOR_EXPORT2(PEV.ELEMENT_VERSION_ID
, '
, ') PREDECESSORS
, PES.LEVEL_ASSIGNMENTS_FLAG
, PES.EFFORT_DRIVEN_FLAG
, PEV.FINANCIAL_TASK_FLAG
, PES.DEF_SCH_TOOL_TSK_TYPE_CODE
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_ID_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, PA_PROJ_STRUC_MAPPING_UTILS.GET_MAPPED_FIN_TASK_NAME_AMG(PEV.ELEMENT_VERSION_ID
, PE.PROJECT_ID)
, NULL
, NULL
, NVL( PXPV.STRUCTURE_TYPE
, STYPE.STRUCTURE_TYPE )
, EXT_SCH_DURATION
, EXT_ACT_DURATION
, EXT_REMAIN_DURATION
, PEV.TASK_UNPUB_VER_STATUS_CODE
, NVL (PPR.COMPLETED_PERCENTAGE
, NVL(PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP)) PERCENT_COMPLETE
, PXPV.ETC_LABOR_HRS ETC_EFFORT
FROM PA_TASKS TASK
, PA_PROJ_ELEMENTS PE
, PA_PROJ_STRUCTURE_TYPES TYP
, PA_STRUCTURE_TYPES STYPE
, PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE PES
, PA_TASK_TYPES TT
, PA_WORK_TYPES_VL PWT
, PER_ALL_PEOPLE_F PAPF
, PJI_XBS_PLANS_PRJ_V PXPV
, PA_PROGRESS_ROLLUP PPR
WHERE PE.PROJ_ELEMENT_ID = TASK.TASK_ID(+)
AND PE.OBJECT_TYPE = 'PA_TASKS'
AND PE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PE.LINK_TASK_FLAG = 'N'
AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID(+)
AND PEV.PROJECT_ID = PES.PROJECT_ID (+)
AND PEV.PROJ_ELEMENT_ID = PES.PROJ_ELEMENT_ID (+)
AND PE.PROJECT_ID = PEV.PROJECT_ID
AND TASK.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND PE.TYPE_ID = TT.TASK_TYPE_ID
AND TT.OBJECT_TYPE = 'PA_TASKS'
AND PE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND PEV.PROJECT_ID = PXPV.PROJECT_ID(+)
AND PEV.PROJ_ELEMENT_ID = PXPV.PROJ_ELEMENT_ID(+)
AND PEV.PARENT_STRUCTURE_VERSION_ID = PXPV.STRUCTURE_VERSION_ID(+)
AND STYPE.STRUCTURE_TYPE = 'WORKPLAN'
AND PXPV.STRUCTURE_TYPE(+)= 'WORKPLAN'
AND STYPE.STRUCTURE_TYPE_ID = TYP.STRUCTURE_TYPE_ID
AND PE.PARENT_STRUCTURE_ID = TYP.PROJ_ELEMENT_ID
AND PPR.OBJECT_ID = PEV.PROJ_ELEMENT_ID
AND PPR.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPR.OBJECT_TYPE = 'PA_TASKS'
AND PPR.PROJECT_ID = PEV.PROJECT_ID
AND PPR.STRUCTURE_TYPE = 'WORKPLAN'
AND PPR.STRUCTURE_VERSION_ID = PEV.PARENT_STRUCTURE_VERSION_ID