View: PA_FIN_LATEST_PUB_TASKS_V

Product:	PA - Projects
Description:	PA_FIN_LATEST_PUB_TASKS_V selects the tasks in the latest published structure version and the financial structure version.
Implementation/DBA Data:	APPS.PA_FIN_LATEST_PUB_TASKS_V

View Text

SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPEVS.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
, PA_PROJECT_STATUSES PPS
WHERE PPEVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPEVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID
FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 2)
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN'
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = PPEVS.PROJECT_ID
AND PPEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PPEV.PROJECT_ID = PPE.PROJECT_ID
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPS.PROJECT_SYSTEM_STATUS_CODE <> 'CANCELLED'
AND PPE.LINK_TASK_FLAG <> 'Y' UNION SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPEVS.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPEV
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
, PA_PROJECT_STATUSES PPS
WHERE PPEVS.LATEST_EFF_PUBLISHED_FLAG = 'Y'
AND PPEVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID
FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 1)
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
AND PPEV.PROJECT_ID = PPEVS.PROJECT_ID
AND PPEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PPEV.PROJECT_ID = PPE.PROJECT_ID
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPS.PROJECT_SYSTEM_STATUS_CODE <> 'CANCELLED'
AND PPE.LINK_TASK_FLAG <> 'Y'

Columns