View: PA_FIN_WP_TASKS_V

Product:	PA - Projects
Description:	PA_FIN_WP_TASKS_V selects the tasks in the workplan structure, financial structure, or a shared structure.
Implementation/DBA Data:	APPS.PA_FIN_WP_TASKS_V

View Text

SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
WHERE PPE.PARENT_STRUCTURE_ID = PPE2.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPE2.PROJECT_ID
AND PPE2.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.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND EXISTS ( SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE
WHERE PROJECT_ID = PPE2.PROJECT_ID
AND PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND STATUS_CODE = 'STRUCTURE_PUBLISHED') UNION SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
WHERE PPE.PARENT_STRUCTURE_ID = PPE2.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPE2.PROJECT_ID
AND PPE2.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.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN'
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND EXISTS ( SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE
WHERE PROJECT_ID = PPE2.PROJECT_ID
AND PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND STATUS_CODE = 'STRUCTURE_PUBLISHED')

Columns