VIEW: APPS.PA_DELIVERABLE_PROG_HIST_V

Source

View Text - Preformatted

SELECT ppa.project_id, ppa.name, ppa.segment1, ppa.long_name, decode( ppe.object_type, 'PA_STRUCTURES', ppvs.name , null) structure_version_name, decode( ppe.object_type, 'PA_STRUCTURES', to_char(ppvs.version_number ), null ) structure_version_number, ppev.parent_structure_version_id, decode( ppe.object_type, 'PA_TASKS', ppe.name , null) task_name, decode( ppe.object_type, 'PA_TASKS', ppe.element_number , null ) task_number, ppe.proj_element_id str_task_proj_element_id, ppev.element_version_id str_task_element_version_id, ppe.object_type str_task_object_type, delppe.object_type del_object_type, por.object_id_to1 del_element_version_id, por.object_id_to2 del_id, delppe.name del_name, delppe.element_number del_number, delppe.manager_person_id del_manager_id, null del_manager_name, delppe.status_code del_status_code, pps3.project_status_name del_status_name, pps3.project_system_status_code del_system_status_code, ppc.date_computed, ppc.percent_complete_id, ppc.completed_percentage, pps.project_status_code progress_status_code, pps.project_status_name progress_status_name, pps.PROJECT_SYSTEM_STATUS_CODE progress_system_status_code, pps.status_icon_ind, pps.status_icon_active_ind, ppvsch.scheduled_start_date, ppvsch.scheduled_finish_date, ppr.actual_start_date, ppr.actual_finish_date, ppr.base_percent_complete, ppr.eff_rollup_percent_comp, ppc.published_by_party_id, ppc.progress_comment, ppc.description, ppc.last_update_date, ppc.published_flag, ppc.current_flag, ppc.record_version_number percomp_record_version_number, ppr.record_version_number rollup_record_version_number, ppr.BASE_PROGRESS_STATUS_CODE, null base_progress_status_name, delppe.last_update_date del_last_update_date, ppvsch.last_update_date del_sch_last_update_date, 'Y' percent_comp_enable_flag, ppr.EFF_ROLLUP_PROG_STAT_CODE, null eff_rollup_status_name, null eff_rollup_status_icon_ind, delppe.PROGRESS_OUTDATED_FLAG, 'N' prog_entry_req_flag, ppr.STRUCTURE_TYPE, ppr.PROJ_ELEMENT_ID, ppr.STRUCTURE_VERSION_ID, ppr.TASK_WT_BASIS_CODE, pa_progress_utils.GET_NEXT_PROGRESS_CYCLE(ppe.project_id, ppe.proj_element_id, delppe.proj_element_id, delppe.object_type), pa_progress_utils.GET_PROG_DT_CLOSEST_TO_SYS_DT(ppe.project_id, ppe.proj_element_id, delppe.proj_element_id, delppe.object_type), ppr.percent_complete_id, ppc.STRUCTURE_TYPE, ppev.wbs_number, ppr.progress_rollup_id From pa_projects_all ppa, pa_proj_elements ppe, pa_proj_element_versions ppev, pa_proj_elements delppe, pa_proj_elem_ver_structure ppvs, pa_proj_elem_ver_schedule ppvsch, pa_object_relationships por, pa_percent_completes ppc, pa_progress_rollup ppr, pa_project_statuses pps, pa_project_statuses pps3, pa_task_types ptt, pa_task_types delptt WHERE ppa.project_id = ppvs.project_id and ppvs.latest_eff_published_flag = 'Y' and ppvs.project_id = ppe.project_id and ppe.link_task_flag = 'N' and ppe.object_type IN('PA_STRUCTURES', 'PA_TASKS') and ppe.project_id = ppev.project_id and ppe.proj_element_id = ppev.proj_element_id and ppe.object_type = ppev.object_type and ppvs.element_version_id = ppev.parent_structure_version_id and ppe.project_id = delppe.project_id and delppe.object_type = 'PA_DELIVERABLES' and delppe.proj_element_id = por.object_id_to2 and ppe.proj_element_id = por.object_id_from2 AND por.object_type_to(+) = 'PA_DELIVERABLES' AND por.relationship_type = 'A' AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE') and nvl(delppe.status_code,'X') = pps3.project_status_code(+) and ppa.project_id = ppvsch.project_id and ppvsch.element_version_id = por.object_id_to1 and delppe.project_id = ppc.project_id and delppe.proj_element_id = ppc.object_id and delppe.object_type = ppc.object_type and ppc.project_id = ppr.project_id(+) and ppc.object_id = ppr.object_id(+) and ppc.object_type = ppr.object_type(+) and ppr.current_flag(+) <> 'W' and ppc.published_flag = 'Y' and trunc(ppc.date_computed) = trunc(ppr.as_of_date(+)) and pps.project_status_code (+)= ppc.progress_status_code and ppc.structure_type = 'WORKPLAN' and ppr.structure_type(+) = ppc.structure_type and ppr.structure_version_id is null and ppe.type_id = ptt.task_type_id and delppe.type_id = delptt.task_type_id and ptt.object_type = 'PA_TASKS' and delptt.object_type = 'PA_DLVR_TYPES' and ptt.PROG_ENTRY_ENABLE_FLAG = 'Y' and delptt.PROG_ENTRY_ENABLE_FLAG = 'Y' union all SELECT ppa.project_id, ppa.name, ppa.segment1, ppa.long_name, decode( ppe.object_type, 'PA_STRUCTURES', ppvs.name , null) structure_version_name, decode( ppe.object_type, 'PA_STRUCTURES', to_char(ppvs.version_number ), null ) structure_version_number, ppev.parent_structure_version_id, decode( ppe.object_type, 'PA_TASKS', ppe.name , null) task_name, decode( ppe.object_type, 'PA_TASKS', ppe.element_number , null ) task_number, ppe.proj_element_id str_task_proj_element_id, ppev.element_version_id str_task_element_version_id, ppe.object_type str_task_object_type, delppe.object_type del_object_type, por.object_id_to1 del_element_version_id, por.object_id_to2 del_id, delppe.name del_name, delppe.element_number del_number, delppe.manager_person_id del_manager_id, null del_manager_name, delppe.status_code del_status_code, null del_status_name, null del_system_status_code, to_date(null) date_computed, to_number(null) percent_complete_id, to_number(null) completed_percentage, null progress_status_code, null progress_status_name, null progress_system_status_code, null status_icon_ind, null status_icon_active_ind, ppvsch.scheduled_start_date, ppvsch.scheduled_finish_date, to_date(null) actual_start_date, to_date(null) actual_finish_date, to_number(null) base_percent_complete, to_number(null) eff_rollup_percent_comp, to_number(null) published_by_party_id, null progress_comment, null description, to_date(null) last_update_date, null published_flag, null current_flag, to_number(null) percomp_record_version_number, to_number(null) rollup_record_version_number, null BASE_PROGRESS_STATUS_CODE, null base_progress_status_name, delppe.last_update_date del_last_update_date, ppvsch.last_update_date del_sch_last_update_date, 'Y' percent_comp_enable_flag, null EFF_ROLLUP_PROG_STAT_CODE, null eff_rollup_status_name, null eff_rollup_status_icon_ind, delppe.PROGRESS_OUTDATED_FLAG, 'N' prog_entry_req_flag, 'WORKPLAN', decode(ptt.base_percent_comp_deriv_code, 'DELIVERABLE' , ppe.proj_element_id, 0) PROJ_ELEMENT_ID, to_number(null) STRUCTURE_VERSION_ID, null TASK_WT_BASIS_CODE, to_date(null), to_date(null), to_number(null) percent_complete_id, 'WORKPLAN', ppev.wbs_number, null From pa_projects_all ppa, pa_proj_elements ppe, pa_proj_element_versions ppev, pa_proj_elements delppe, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst, pa_proj_elem_ver_schedule ppvsch, pa_object_relationships por, pa_task_types ptt, pa_task_types delptt WHERE ppa.project_id = ppvs.project_id and ppvs.latest_eff_published_flag = 'Y' and ppvs.proj_element_id = ppst.proj_element_id and ppst.structure_type_id = 1 and ppa.project_id = delppe.project_id and delppe.object_type = 'PA_DELIVERABLES' and por.object_id_to2 = delppe.proj_element_id AND por.object_type_to(+) = 'PA_DELIVERABLES' AND por.relationship_type = 'A' AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE') and ppvs.project_id = ppe.project_id and ppe.proj_element_id = por.object_id_from2 and ppe.link_task_flag = 'N' and ppe.object_type IN('PA_STRUCTURES', 'PA_TASKS') and ppe.project_id = ppev.project_id and ppe.proj_element_id = ppev.proj_element_id and ppe.object_type = ppev.object_type and ppvs.element_version_id = ppev.parent_structure_version_id and ppa.project_id = ppvsch.project_id and ppvsch.element_version_id = por.object_id_to1 and ppe.type_id = ptt.task_type_id and delppe.type_id = delptt.task_type_id and ptt.object_type = 'PA_TASKS' and delptt.object_type = 'PA_DLVR_TYPES' and ptt.PROG_ENTRY_ENABLE_FLAG = 'Y' and delptt.PROG_ENTRY_ENABLE_FLAG = 'Y'

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPVS.NAME
, NULL) STRUCTURE_VERSION_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, TO_CHAR(PPVS.VERSION_NUMBER )
, NULL ) STRUCTURE_VERSION_NUMBER
, PPEV.PARENT_STRUCTURE_VERSION_ID
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, NULL) TASK_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, NULL ) TASK_NUMBER
, PPE.PROJ_ELEMENT_ID STR_TASK_PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID STR_TASK_ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE STR_TASK_OBJECT_TYPE
, DELPPE.OBJECT_TYPE DEL_OBJECT_TYPE
, POR.OBJECT_ID_TO1 DEL_ELEMENT_VERSION_ID
, POR.OBJECT_ID_TO2 DEL_ID
, DELPPE.NAME DEL_NAME
, DELPPE.ELEMENT_NUMBER DEL_NUMBER
, DELPPE.MANAGER_PERSON_ID DEL_MANAGER_ID
, NULL DEL_MANAGER_NAME
, DELPPE.STATUS_CODE DEL_STATUS_CODE
, PPS3.PROJECT_STATUS_NAME DEL_STATUS_NAME
, PPS3.PROJECT_SYSTEM_STATUS_CODE DEL_SYSTEM_STATUS_CODE
, PPC.DATE_COMPUTED
, PPC.PERCENT_COMPLETE_ID
, PPC.COMPLETED_PERCENTAGE
, PPS.PROJECT_STATUS_CODE PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME PROGRESS_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE PROGRESS_SYSTEM_STATUS_CODE
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, PPR.ACTUAL_START_DATE
, PPR.ACTUAL_FINISH_DATE
, PPR.BASE_PERCENT_COMPLETE
, PPR.EFF_ROLLUP_PERCENT_COMP
, PPC.PUBLISHED_BY_PARTY_ID
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.LAST_UPDATE_DATE
, PPC.PUBLISHED_FLAG
, PPC.CURRENT_FLAG
, PPC.RECORD_VERSION_NUMBER PERCOMP_RECORD_VERSION_NUMBER
, PPR.RECORD_VERSION_NUMBER ROLLUP_RECORD_VERSION_NUMBER
, PPR.BASE_PROGRESS_STATUS_CODE
, NULL BASE_PROGRESS_STATUS_NAME
, DELPPE.LAST_UPDATE_DATE DEL_LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE DEL_SCH_LAST_UPDATE_DATE
, 'Y' PERCENT_COMP_ENABLE_FLAG
, PPR.EFF_ROLLUP_PROG_STAT_CODE
, NULL EFF_ROLLUP_STATUS_NAME
, NULL EFF_ROLLUP_STATUS_ICON_IND
, DELPPE.PROGRESS_OUTDATED_FLAG
, 'N' PROG_ENTRY_REQ_FLAG
, PPR.STRUCTURE_TYPE
, PPR.PROJ_ELEMENT_ID
, PPR.STRUCTURE_VERSION_ID
, PPR.TASK_WT_BASIS_CODE
, PA_PROGRESS_UTILS.GET_NEXT_PROGRESS_CYCLE(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, DELPPE.PROJ_ELEMENT_ID
, DELPPE.OBJECT_TYPE)
, PA_PROGRESS_UTILS.GET_PROG_DT_CLOSEST_TO_SYS_DT(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, DELPPE.PROJ_ELEMENT_ID
, DELPPE.OBJECT_TYPE)
, PPR.PERCENT_COMPLETE_ID
, PPC.STRUCTURE_TYPE
, PPEV.WBS_NUMBER
, PPR.PROGRESS_ROLLUP_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEMENTS DELPPE
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_OBJECT_RELATIONSHIPS POR
, PA_PERCENT_COMPLETES PPC
, PA_PROGRESS_ROLLUP PPR
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS3
, PA_TASK_TYPES PTT
, PA_TASK_TYPES DELPTT
WHERE PPA.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPVS.PROJECT_ID = PPE.PROJECT_ID
AND PPE.LINK_TASK_FLAG = 'N'
AND PPE.OBJECT_TYPE IN('PA_STRUCTURES'
, 'PA_TASKS')
AND PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.OBJECT_TYPE = PPEV.OBJECT_TYPE
AND PPVS.ELEMENT_VERSION_ID = PPEV.PARENT_STRUCTURE_VERSION_ID
AND PPE.PROJECT_ID = DELPPE.PROJECT_ID
AND DELPPE.OBJECT_TYPE = 'PA_DELIVERABLES'
AND DELPPE.PROJ_ELEMENT_ID = POR.OBJECT_ID_TO2
AND PPE.PROJ_ELEMENT_ID = POR.OBJECT_ID_FROM2
AND POR.OBJECT_TYPE_TO(+) = 'PA_DELIVERABLES'
AND POR.RELATIONSHIP_TYPE = 'A'
AND POR.RELATIONSHIP_SUBTYPE IN ('STRUCTURE_TO_DELIVERABLE'
, 'TASK_TO_DELIVERABLE')
AND NVL(DELPPE.STATUS_CODE
, 'X') = PPS3.PROJECT_STATUS_CODE(+)
AND PPA.PROJECT_ID = PPVSCH.PROJECT_ID
AND PPVSCH.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND DELPPE.PROJECT_ID = PPC.PROJECT_ID
AND DELPPE.PROJ_ELEMENT_ID = PPC.OBJECT_ID
AND DELPPE.OBJECT_TYPE = PPC.OBJECT_TYPE
AND PPC.PROJECT_ID = PPR.PROJECT_ID(+)
AND PPC.OBJECT_ID = PPR.OBJECT_ID(+)
AND PPC.OBJECT_TYPE = PPR.OBJECT_TYPE(+)
AND PPR.CURRENT_FLAG(+) <> 'W'
AND PPC.PUBLISHED_FLAG = 'Y'
AND TRUNC(PPC.DATE_COMPUTED) = TRUNC(PPR.AS_OF_DATE(+))
AND PPS.PROJECT_STATUS_CODE (+)= PPC.PROGRESS_STATUS_CODE
AND PPC.STRUCTURE_TYPE = 'WORKPLAN'
AND PPR.STRUCTURE_TYPE(+) = PPC.STRUCTURE_TYPE
AND PPR.STRUCTURE_VERSION_ID IS NULL
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID
AND DELPPE.TYPE_ID = DELPTT.TASK_TYPE_ID
AND PTT.OBJECT_TYPE = 'PA_TASKS'
AND DELPTT.OBJECT_TYPE = 'PA_DLVR_TYPES'
AND PTT.PROG_ENTRY_ENABLE_FLAG = 'Y'
AND DELPTT.PROG_ENTRY_ENABLE_FLAG = 'Y' UNION ALL SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.LONG_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, PPVS.NAME
, NULL) STRUCTURE_VERSION_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_STRUCTURES'
, TO_CHAR(PPVS.VERSION_NUMBER )
, NULL ) STRUCTURE_VERSION_NUMBER
, PPEV.PARENT_STRUCTURE_VERSION_ID
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.NAME
, NULL) TASK_NAME
, DECODE( PPE.OBJECT_TYPE
, 'PA_TASKS'
, PPE.ELEMENT_NUMBER
, NULL ) TASK_NUMBER
, PPE.PROJ_ELEMENT_ID STR_TASK_PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID STR_TASK_ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE STR_TASK_OBJECT_TYPE
, DELPPE.OBJECT_TYPE DEL_OBJECT_TYPE
, POR.OBJECT_ID_TO1 DEL_ELEMENT_VERSION_ID
, POR.OBJECT_ID_TO2 DEL_ID
, DELPPE.NAME DEL_NAME
, DELPPE.ELEMENT_NUMBER DEL_NUMBER
, DELPPE.MANAGER_PERSON_ID DEL_MANAGER_ID
, NULL DEL_MANAGER_NAME
, DELPPE.STATUS_CODE DEL_STATUS_CODE
, NULL DEL_STATUS_NAME
, NULL DEL_SYSTEM_STATUS_CODE
, TO_DATE(NULL) DATE_COMPUTED
, TO_NUMBER(NULL) PERCENT_COMPLETE_ID
, TO_NUMBER(NULL) COMPLETED_PERCENTAGE
, NULL PROGRESS_STATUS_CODE
, NULL PROGRESS_STATUS_NAME
, NULL PROGRESS_SYSTEM_STATUS_CODE
, NULL STATUS_ICON_IND
, NULL STATUS_ICON_ACTIVE_IND
, PPVSCH.SCHEDULED_START_DATE
, PPVSCH.SCHEDULED_FINISH_DATE
, TO_DATE(NULL) ACTUAL_START_DATE
, TO_DATE(NULL) ACTUAL_FINISH_DATE
, TO_NUMBER(NULL) BASE_PERCENT_COMPLETE
, TO_NUMBER(NULL) EFF_ROLLUP_PERCENT_COMP
, TO_NUMBER(NULL) PUBLISHED_BY_PARTY_ID
, NULL PROGRESS_COMMENT
, NULL DESCRIPTION
, TO_DATE(NULL) LAST_UPDATE_DATE
, NULL PUBLISHED_FLAG
, NULL CURRENT_FLAG
, TO_NUMBER(NULL) PERCOMP_RECORD_VERSION_NUMBER
, TO_NUMBER(NULL) ROLLUP_RECORD_VERSION_NUMBER
, NULL BASE_PROGRESS_STATUS_CODE
, NULL BASE_PROGRESS_STATUS_NAME
, DELPPE.LAST_UPDATE_DATE DEL_LAST_UPDATE_DATE
, PPVSCH.LAST_UPDATE_DATE DEL_SCH_LAST_UPDATE_DATE
, 'Y' PERCENT_COMP_ENABLE_FLAG
, NULL EFF_ROLLUP_PROG_STAT_CODE
, NULL EFF_ROLLUP_STATUS_NAME
, NULL EFF_ROLLUP_STATUS_ICON_IND
, DELPPE.PROGRESS_OUTDATED_FLAG
, 'N' PROG_ENTRY_REQ_FLAG
, 'WORKPLAN'
, DECODE(PTT.BASE_PERCENT_COMP_DERIV_CODE
, 'DELIVERABLE'
, PPE.PROJ_ELEMENT_ID
, 0) PROJ_ELEMENT_ID
, TO_NUMBER(NULL) STRUCTURE_VERSION_ID
, NULL TASK_WT_BASIS_CODE
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL) PERCENT_COMPLETE_ID
, 'WORKPLAN'
, PPEV.WBS_NUMBER
, NULL
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEMENTS DELPPE
, PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PA_OBJECT_RELATIONSHIPS POR
, PA_TASK_TYPES PTT
, PA_TASK_TYPES DELPTT
WHERE PPA.PROJECT_ID = PPVS.PROJECT_ID
AND PPVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = 1
AND PPA.PROJECT_ID = DELPPE.PROJECT_ID
AND DELPPE.OBJECT_TYPE = 'PA_DELIVERABLES'
AND POR.OBJECT_ID_TO2 = DELPPE.PROJ_ELEMENT_ID
AND POR.OBJECT_TYPE_TO(+) = 'PA_DELIVERABLES'
AND POR.RELATIONSHIP_TYPE = 'A'
AND POR.RELATIONSHIP_SUBTYPE IN ('STRUCTURE_TO_DELIVERABLE'
, 'TASK_TO_DELIVERABLE')
AND PPVS.PROJECT_ID = PPE.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = POR.OBJECT_ID_FROM2
AND PPE.LINK_TASK_FLAG = 'N'
AND PPE.OBJECT_TYPE IN('PA_STRUCTURES'
, 'PA_TASKS')
AND PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.OBJECT_TYPE = PPEV.OBJECT_TYPE
AND PPVS.ELEMENT_VERSION_ID = PPEV.PARENT_STRUCTURE_VERSION_ID
AND PPA.PROJECT_ID = PPVSCH.PROJECT_ID
AND PPVSCH.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID
AND DELPPE.TYPE_ID = DELPTT.TASK_TYPE_ID
AND PTT.OBJECT_TYPE = 'PA_TASKS'
AND DELPTT.OBJECT_TYPE = 'PA_DLVR_TYPES'
AND PTT.PROG_ENTRY_ENABLE_FLAG = 'Y'
AND DELPTT.PROG_ENTRY_ENABLE_FLAG = 'Y'