View: PA_STRUCT_TASK_LOV_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_STRUCT_TASK_LOV_V

View Text

SELECT PPEV.ELEMENT_VERSION_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJECT_ID
, -1
, PST.STRUCTURE_TYPE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE STR
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
WHERE PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPEV.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPEV.PARENT_STRUCTURE_VERSION_ID = STR.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = STR.PROJECT_ID
AND STR.CURRENT_WORKING_FLAG = 'Y'
AND PPE2.PROJECT_ID = STR.PROJECT_ID
AND PPE2.PROJ_ELEMENT_ID = STR.PROJ_ELEMENT_ID
AND PPE2.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND NOT EXISTS ( SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE STR2
WHERE STR2.PROJECT_ID = STR.PROJECT_ID
AND STR2.PROJ_ELEMENT_ID = STR.PROJ_ELEMENT_ID
AND STR2.STATUS_CODE = 'STRUCTURE_PUBLISHED' ) UNION SELECT PPEV.ELEMENT_VERSION_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJECT_ID
, -1
, PST.STRUCTURE_TYPE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE STR
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
WHERE PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPEV.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPEV.PARENT_STRUCTURE_VERSION_ID = STR.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = STR.PROJECT_ID
AND STR.STATUS_CODE = 'STRUCTURE_PUBLISHED'
AND STR.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPE2.PROJECT_ID = STR.PROJECT_ID
AND PPE2.PROJ_ELEMENT_ID = STR.PROJ_ELEMENT_ID
AND PPE2.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID UNION SELECT PPEV.ELEMENT_VERSION_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJECT_ID
, PPEV.PARENT_STRUCTURE_VERSION_ID
, PST.STRUCTURE_TYPE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENT_VERSIONS PPEV2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
WHERE PPE.PROJECT_ID = PPEV.PROJECT_ID
AND PPEV.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPEV.PROJ_ELEMENT_ID
AND PPE.LINK_TASK_FLAG <> 'Y'
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPEV2.ELEMENT_VERSION_ID
AND PPEV2.PROJECT_ID = PPE2.PROJECT_ID
AND PPEV2.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPE2.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID

Columns