View: PA_LAUNCH_PAGE_OBJECTS_V

Product:	PA - Projects
Description:	PA_LAUNCH_PAGE_OBJECTS_V gives the consolidated list of objects
Implementation/DBA Data:	APPS.PA_LAUNCH_PAGE_OBJECTS_V

View Text

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)
, PAPF.FULL_NAME
, PAPF.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)
, PPC.PERCENT_COMPLETE_ID
, PPR.PROGRESS_ROLLUP_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
, PER_ALL_PEOPLE_F PAPF
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES STATUS
, PA_PROJECT_STATUSES PROGRESS
, PA_LOOKUPS PRIORITY
, PA_LOOKUPS CLASS
, PA_PROGRESS_ROLLUP PPR
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 PPR.PROJECT_ID (+)=PPC.PROJECT_ID
AND PPR.OBJECT_ID (+)=PPC.OBJECT_ID
AND PPR.OBJECT_TYPE (+)=PPC.OBJECT_TYPE
AND PPR.CURRENT_FLAG (+)= 'Y' AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN' AND PPR.STRUCTURE_VERSION_ID(+) IS NULL
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE(+)
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'
AND PPE.LINK_TASK_FLAG = 'N' 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)
, PAPF.FULL_NAME
, PAPF.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)
, PPC.PERCENT_COMPLETE_ID
, PPR.PROGRESS_ROLLUP_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
, PER_ALL_PEOPLE_F PAPF
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES STATUS
, PA_PROJECT_STATUSES PROGRESS
, PA_LOOKUPS CLASS
, PA_PROGRESS_ROLLUP PPR
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 PPR.PROJECT_ID (+)=PPC.PROJECT_ID
AND PPR.OBJECT_ID (+)=PPC.OBJECT_ID
AND PPR.OBJECT_TYPE (+)=PPC.OBJECT_TYPE
AND PPR.CURRENT_FLAG (+)= 'Y' AND PPR.STRUCTURE_TYPE(+) = 'WORKPLAN' AND PPR.STRUCTURE_VERSION_ID(+) IS NULL
AND PPE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE(+)
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)
, TO_NUMBER(NULL)
, TO_NUMBER(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(+)

Columns