View: PA_STRUCT_TASK_WBS_V

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

View Text

SELECT A.PROJECT_ID
, B.PROJ_ELEMENT_ID
, B.ELEMENT_NUMBER
, B.NAME
, PA_PROJ_ELEMENTS_UTILS.GET_TOP_TASK_ID(C.ELEMENT_VERSION_ID)
, PA_PROJ_ELEMENTS_UTILS.GET_TOP_TASK_VER_ID(C.ELEMENT_VERSION_ID)
, PA_PROJ_ELEMENTS_UTILS.GET_TASK_LEVEL(C.PROJECT_ID
, C.PROJ_ELEMENT_ID)
, PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_ID(C.ELEMENT_VERSION_ID)
, PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_VERSION_ID(C.ELEMENT_VERSION_ID)
, B.PARENT_STRUCTURE_ID
, C.PARENT_STRUCTURE_VERSION_ID
, C.ELEMENT_VERSION_ID
, D.SCHEDULED_START_DATE
, D.SCHEDULED_FINISH_DATE
, E.START_DATE
, E.COMPLETION_DATE
, D.ACTUAL_START_DATE
, D.ACTUAL_FINISH_DATE
, D.ESTIMATED_START_DATE
, D.ESTIMATED_FINISH_DATE
, DECODE(E.TASK_NUMBER
, NULL
, 'N'
, 'Y')
FROM PA_PROJECTS_ALL A
, PA_PROJ_ELEMENTS B
, PA_PROJ_ELEMENT_VERSIONS C
, PA_PROJ_ELEM_VER_SCHEDULE D
, PA_TASKS E
WHERE A.PROJECT_ID = B.PROJECT_ID
AND B.PROJECT_ID = C.PROJECT_ID
AND B.PROJ_ELEMENT_ID = C.PROJ_ELEMENT_ID
AND C.PROJECT_ID = D.PROJECT_ID(+)
AND C.ELEMENT_VERSION_ID = D.ELEMENT_VERSION_ID(+)
AND B.PROJ_ELEMENT_ID = E.TASK_ID (+)
AND B.OBJECT_TYPE = 'PA_TASKS'

Columns