VIEW: APPS.PA_STRUCT_TASK_WBS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'