VIEW: APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V

Source

View Text - Preformatted

SELECT ppe.proj_element_id, ppev.element_version_id, ppev.parent_structure_version_id, class.lookup_code, class.meaning, ptt.task_type, Ppe.name, ppe.element_number, ppe.description, Ppa.name, ppa.segment1, ppe.project_id, TO_CHAR(NULL), TO_CHAR(NULL), TO_NUMBER(NULL), Owner.party_name, owner.party_id, Status.project_status_name, status.status_icon_active_ind, status.project_system_status_code, Priority.meaning, TO_NUMBER(priority.predefined_flag), Ppevsch.scheduled_finish_date, ppevsch.scheduled_finish_date-TRUNC(SYSDATE), Progress.project_status_name, progress.status_icon_active_ind, Ppc.description, ppc.date_computed, ppc.completed_percentage, Ppevsch.actual_start_date, ppevsch.actual_finish_date, to_char(null) FROM pa_proj_elements ppe, pa_proj_element_versions ppev, Pa_proj_elem_ver_schedule ppevsch, pa_task_types ptt, Pa_projects_all ppa, hz_parties owner, Pa_percent_completes ppc, Pa_project_statuses status, pa_project_statuses progress, pa_lookups priority, pa_lookups class WHERE priority.lookup_type(+)='PA_TASK_PRIORITY_CODE' AND priority.lookup_code(+)=ppe.priority_code AND class.lookup_type='PA_OBJECTS' AND class.lookup_code='PA_TASKS' AND ptt.task_type_id(+) = ppe.type_id AND progress.status_type(+)='PROGRESS' AND progress.project_status_code(+) = ppc.progress_status_code AND status.status_type(+)='TASK' AND status.project_status_code(+) = ppe.status_code AND ppe.object_type='PA_TASKS' AND ppe.project_id = ppa.project_id AND ppev.proj_element_id=ppe.proj_element_id AND ppev.parent_structure_version_id=pa_project_structure_utils.get_latest_wp_version(ppe.project_id) AND ppevsch.element_version_id(+)=ppev.element_version_id AND owner.PERSON_IDENTIFIER = ppe.manager_person_id AND ppc.object_id(+)=ppe.proj_element_id AND ppc.object_type(+)='PA_TASKS' AND ppc.project_id(+)=ppe.project_id AND ppc.current_flag(+)='Y' AND ppc.current_flag(+) = 'Y' AND ppc.published_flag(+) = 'Y' AND ppc.structure_type(+) = 'WORKPLAN' AND nvl(ppa.template_flag, 'N') <> 'Y' UNION ALL SELECT ppe.proj_element_id, ppev.element_version_id, ppev.parent_structure_version_id, class.lookup_code, class.meaning, ptt.task_type, Ppe.name, ppe.element_number, ppe.description, Ppa.name, ppa.segment1, ppe.project_id, TO_CHAR(NULL), TO_CHAR(NULL), TO_NUMBER(NULL), Owner.party_name, owner.party_id, Status.project_status_name, status.status_icon_active_ind, status.project_system_status_code, TO_CHAR(NULL), TO_NUMBER(NULL), Ppevsch.scheduled_finish_date, ppevsch.scheduled_finish_date-TRUNC(SYSDATE), Progress.project_status_name, progress.status_icon_active_ind, Ppc.description, ppc.date_computed, ppc.completed_percentage, Ppevsch.actual_start_date, ppevsch.actual_finish_date, PA_DELIVERABLE_UTILS.GET_ASSOCIATED_TASKS(ppe.proj_element_id) FROM pa_proj_elements ppe, pa_proj_element_versions ppev, Pa_proj_elem_ver_schedule ppevsch, pa_task_types ptt, Pa_projects_all ppa, hz_parties owner, Pa_percent_completes ppc, Pa_project_statuses status, pa_project_statuses progress, pa_lookups class WHERE class.lookup_type='PA_OBJECTS' AND class.lookup_code='PA_DELIVERABLES' AND ptt.task_type_id = ppe.type_id AND status.status_type(+)='DELIVERABLE' AND status.project_status_code(+) = ppe.status_code AND ppe.object_type='PA_DELIVERABLES' AND ppe.project_id=ppa.project_id AND ppev.proj_element_id=ppe.proj_element_id AND ppev.project_id=ppe.project_id AND ppevsch.element_version_id=ppev.element_version_id AND ppevsch.project_id=ppev.project_id AND owner.PERSON_IDENTIFIER = ppe.manager_person_id AND ppc.object_id(+)=ppe.proj_element_id AND ppc.object_type(+)='PA_DELIVERABLES' AND ppc.project_id(+)=ppe.project_id AND progress.status_type(+)='PROGRESS' AND progress.project_status_code(+)=ppc.progress_status_code AND ppc.current_flag(+) = 'Y' AND ppc.published_flag(+) = 'Y' AND ppc.structure_type(+) = 'WORKPLAN' AND nvl(ppa.template_flag, 'N') <> 'Y' UNION ALL SELECT pci.ci_id, to_number(null), to_number(null), pcitb.ci_type_class_code, class.meaning, pcittl.name, Pcittl.short_name, pci.ci_number, pci.summary, Ppa.name, ppa.segment1, pci.project_id, DECODE(pci.object_type, 'PA_TASKS', pa_proj_elements_utils.get_element_name(pci.object_id), TO_CHAR(NULL)), DECODE(pci.object_type, 'PA_TASKS', Pa_proj_elements_utils.get_element_number(pci.object_id), TO_CHAR(NULL)), Pci.object_id, Owner.party_name, pci.owner_id, Status.project_status_name, status.status_icon_active_ind, status.project_system_status_code, Priority.meaning, TO_NUMBER(priority.predefined_flag), Date_required, date_required-TRUNC(SYSDATE), Progress.project_status_name, progress.status_icon_active_ind, Pci.status_overview, pci.progress_as_of_date, TO_NUMBER(NULL), TO_DATE(NULL), pci.date_closed, to_char(null) FROM pa_control_items pci, pa_ci_types_b pcitb, pa_ci_types_tl pcittl, Pa_projects_all ppa, hz_parties owner, Pa_project_statuses status, pa_project_statuses progress, pa_lookups priority, pa_lookups class WHERE priority.lookup_type(+)='PA_TASK_PRIORITY_CODE' AND priority.lookup_code(+)=pci.priority_code AND class.lookup_type='PA_CI_TYPE_CLASSES' AND class.lookup_code=pcitb.ci_type_class_code AND progress.status_type(+)='PROGRESS' AND progress.project_status_code = pci.progress_status_code AND status.status_type='CONTROL_ITEM' AND status.project_status_code = pci.status_code AND pci.ci_type_id = pcitb.ci_type_id AND pcitb.ci_type_id = pcittl.ci_type_id AND pcittl.language = userenv('lang') AND pci.project_id = ppa.project_id AND pci.owner_id = owner.party_id

View Text - HTML Formatted

SELECT PPE.PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID
, PPEV.PARENT_STRUCTURE_VERSION_ID
, CLASS.LOOKUP_CODE
, CLASS.MEANING
, PTT.TASK_TYPE
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.DESCRIPTION
, PPA.NAME
, PPA.SEGMENT1
, PPE.PROJECT_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, OWNER.PARTY_NAME
, OWNER.PARTY_ID
, STATUS.PROJECT_STATUS_NAME
, STATUS.STATUS_ICON_ACTIVE_IND
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, PRIORITY.MEANING
, TO_NUMBER(PRIORITY.PREDEFINED_FLAG)
, PPEVSCH.SCHEDULED_FINISH_DATE
, PPEVSCH.SCHEDULED_FINISH_DATE-TRUNC(SYSDATE)
, PROGRESS.PROJECT_STATUS_NAME
, PROGRESS.STATUS_ICON_ACTIVE_IND
, PPC.DESCRIPTION
, PPC.DATE_COMPUTED
, PPC.COMPLETED_PERCENTAGE
, PPEVSCH.ACTUAL_START_DATE
, PPEVSCH.ACTUAL_FINISH_DATE
, TO_CHAR(NULL)
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_SCHEDULE PPEVSCH
, PA_TASK_TYPES PTT
, PA_PROJECTS_ALL PPA
, HZ_PARTIES OWNER
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES STATUS
, PA_PROJECT_STATUSES PROGRESS
, PA_LOOKUPS PRIORITY
, PA_LOOKUPS CLASS
WHERE PRIORITY.LOOKUP_TYPE(+)='PA_TASK_PRIORITY_CODE'
AND PRIORITY.LOOKUP_CODE(+)=PPE.PRIORITY_CODE
AND CLASS.LOOKUP_TYPE='PA_OBJECTS'
AND CLASS.LOOKUP_CODE='PA_TASKS'
AND PTT.TASK_TYPE_ID(+) = PPE.TYPE_ID
AND PROGRESS.STATUS_TYPE(+)='PROGRESS'
AND PROGRESS.PROJECT_STATUS_CODE(+) = PPC.PROGRESS_STATUS_CODE
AND STATUS.STATUS_TYPE(+)='TASK'
AND STATUS.PROJECT_STATUS_CODE(+) = PPE.STATUS_CODE
AND PPE.OBJECT_TYPE='PA_TASKS'
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND PPEV.PROJ_ELEMENT_ID=PPE.PROJ_ELEMENT_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(PPE.PROJECT_ID)
AND PPEVSCH.ELEMENT_VERSION_ID(+)=PPEV.ELEMENT_VERSION_ID
AND OWNER.PERSON_IDENTIFIER = PPE.MANAGER_PERSON_ID
AND PPC.OBJECT_ID(+)=PPE.PROJ_ELEMENT_ID
AND PPC.OBJECT_TYPE(+)='PA_TASKS'
AND PPC.PROJECT_ID(+)=PPE.PROJECT_ID
AND PPC.CURRENT_FLAG(+)='Y'
AND PPC.CURRENT_FLAG(+) = 'Y'
AND PPC.PUBLISHED_FLAG(+) = 'Y'
AND PPC.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND NVL(PPA.TEMPLATE_FLAG
, 'N') <> 'Y' UNION ALL SELECT PPE.PROJ_ELEMENT_ID
, PPEV.ELEMENT_VERSION_ID
, PPEV.PARENT_STRUCTURE_VERSION_ID
, CLASS.LOOKUP_CODE
, CLASS.MEANING
, PTT.TASK_TYPE
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.DESCRIPTION
, PPA.NAME
, PPA.SEGMENT1
, PPE.PROJECT_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, OWNER.PARTY_NAME
, OWNER.PARTY_ID
, STATUS.PROJECT_STATUS_NAME
, STATUS.STATUS_ICON_ACTIVE_IND
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, PPEVSCH.SCHEDULED_FINISH_DATE
, PPEVSCH.SCHEDULED_FINISH_DATE-TRUNC(SYSDATE)
, PROGRESS.PROJECT_STATUS_NAME
, PROGRESS.STATUS_ICON_ACTIVE_IND
, PPC.DESCRIPTION
, PPC.DATE_COMPUTED
, PPC.COMPLETED_PERCENTAGE
, PPEVSCH.ACTUAL_START_DATE
, PPEVSCH.ACTUAL_FINISH_DATE
, PA_DELIVERABLE_UTILS.GET_ASSOCIATED_TASKS(PPE.PROJ_ELEMENT_ID)
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_SCHEDULE PPEVSCH
, PA_TASK_TYPES PTT
, PA_PROJECTS_ALL PPA
, HZ_PARTIES OWNER
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES STATUS
, PA_PROJECT_STATUSES PROGRESS
, PA_LOOKUPS CLASS
WHERE CLASS.LOOKUP_TYPE='PA_OBJECTS'
AND CLASS.LOOKUP_CODE='PA_DELIVERABLES'
AND PTT.TASK_TYPE_ID = PPE.TYPE_ID
AND STATUS.STATUS_TYPE(+)='DELIVERABLE'
AND STATUS.PROJECT_STATUS_CODE(+) = PPE.STATUS_CODE
AND PPE.OBJECT_TYPE='PA_DELIVERABLES'
AND PPE.PROJECT_ID=PPA.PROJECT_ID
AND PPEV.PROJ_ELEMENT_ID=PPE.PROJ_ELEMENT_ID
AND PPEV.PROJECT_ID=PPE.PROJECT_ID
AND PPEVSCH.ELEMENT_VERSION_ID=PPEV.ELEMENT_VERSION_ID
AND PPEVSCH.PROJECT_ID=PPEV.PROJECT_ID
AND OWNER.PERSON_IDENTIFIER = PPE.MANAGER_PERSON_ID
AND PPC.OBJECT_ID(+)=PPE.PROJ_ELEMENT_ID
AND PPC.OBJECT_TYPE(+)='PA_DELIVERABLES'
AND PPC.PROJECT_ID(+)=PPE.PROJECT_ID
AND PROGRESS.STATUS_TYPE(+)='PROGRESS'
AND PROGRESS.PROJECT_STATUS_CODE(+)=PPC.PROGRESS_STATUS_CODE
AND PPC.CURRENT_FLAG(+) = 'Y'
AND PPC.PUBLISHED_FLAG(+) = 'Y'
AND PPC.STRUCTURE_TYPE(+) = 'WORKPLAN'
AND NVL(PPA.TEMPLATE_FLAG
, 'N') <> 'Y' UNION ALL SELECT PCI.CI_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PCITB.CI_TYPE_CLASS_CODE
, CLASS.MEANING
, PCITTL.NAME
, PCITTL.SHORT_NAME
, PCI.CI_NUMBER
, PCI.SUMMARY
, PPA.NAME
, PPA.SEGMENT1
, PCI.PROJECT_ID
, DECODE(PCI.OBJECT_TYPE
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NAME(PCI.OBJECT_ID)
, TO_CHAR(NULL))
, DECODE(PCI.OBJECT_TYPE
, 'PA_TASKS'
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NUMBER(PCI.OBJECT_ID)
, TO_CHAR(NULL))
, PCI.OBJECT_ID
, OWNER.PARTY_NAME
, PCI.OWNER_ID
, STATUS.PROJECT_STATUS_NAME
, STATUS.STATUS_ICON_ACTIVE_IND
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, PRIORITY.MEANING
, TO_NUMBER(PRIORITY.PREDEFINED_FLAG)
, DATE_REQUIRED
, DATE_REQUIRED-TRUNC(SYSDATE)
, PROGRESS.PROJECT_STATUS_NAME
, PROGRESS.STATUS_ICON_ACTIVE_IND
, PCI.STATUS_OVERVIEW
, PCI.PROGRESS_AS_OF_DATE
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, PCI.DATE_CLOSED
, TO_CHAR(NULL)
FROM PA_CONTROL_ITEMS PCI
, PA_CI_TYPES_B PCITB
, PA_CI_TYPES_TL PCITTL
, PA_PROJECTS_ALL PPA
, HZ_PARTIES OWNER
, PA_PROJECT_STATUSES STATUS
, PA_PROJECT_STATUSES PROGRESS
, PA_LOOKUPS PRIORITY
, PA_LOOKUPS CLASS
WHERE PRIORITY.LOOKUP_TYPE(+)='PA_TASK_PRIORITY_CODE'
AND PRIORITY.LOOKUP_CODE(+)=PCI.PRIORITY_CODE
AND CLASS.LOOKUP_TYPE='PA_CI_TYPE_CLASSES'
AND CLASS.LOOKUP_CODE=PCITB.CI_TYPE_CLASS_CODE
AND PROGRESS.STATUS_TYPE(+)='PROGRESS'
AND PROGRESS.PROJECT_STATUS_CODE = PCI.PROGRESS_STATUS_CODE
AND STATUS.STATUS_TYPE='CONTROL_ITEM'
AND STATUS.PROJECT_STATUS_CODE = PCI.STATUS_CODE
AND PCI.CI_TYPE_ID = PCITB.CI_TYPE_ID
AND PCITB.CI_TYPE_ID = PCITTL.CI_TYPE_ID
AND PCITTL.LANGUAGE = USERENV('LANG')
AND PCI.PROJECT_ID = PPA.PROJECT_ID
AND PCI.OWNER_ID = OWNER.PARTY_ID