VIEW: APPS.PA_TASK_OLAP_V

Source

View Text - Preformatted

SELECT p.project_id , t.task_id , nvl(parent_task_id, e.proj_element_id ) parent_task_id from pa_tasks t , pa_projects_all p , pa_proj_element_versions e, pa_proj_structure_types pst WHERE p.project_id = t.project_id and p.project_id = e.project_id and e.object_type = 'PA_STRUCTURES' and e.proj_element_id = pst.proj_element_id and pst.structure_type_id = 6 union all select p.project_id ,e.proj_element_id task_id , 0 from pa_projects_all p , pa_proj_element_versions e, pa_proj_structure_types pst where p.project_id = e.project_id and e.object_type = 'PA_STRUCTURES' and e.proj_element_id = pst.proj_element_id and pst.structure_type_id = 6 union all select - 1, -1 , to_number(null) from dual union all select -1 , 0 , to_number(null) parent_element_id from dual union all select p.project_id , -1*t.task_id , t.task_id from pa_tasks t , pa_projects_all p , pa_proj_element_versions e, pa_proj_structure_types pst where p.project_id = t.project_id and p.project_id = e.project_id and e.object_type = 'PA_STRUCTURES' and e.proj_element_id = pst.proj_element_id and pst.structure_type_id = 6 union all select p.project_id ,-1*e.proj_element_id task_id , e.proj_element_id task_id from pa_projects_all p , pa_proj_element_versions e, pa_proj_structure_types pst where p.project_id = e.project_id and e.object_type = 'PA_STRUCTURES' and e.proj_element_id = pst.proj_element_id and pst.structure_type_id = 6

View Text - HTML Formatted

SELECT P.PROJECT_ID
, T.TASK_ID
, NVL(PARENT_TASK_ID
, E.PROJ_ELEMENT_ID ) PARENT_TASK_ID
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_PROJ_ELEMENT_VERSIONS E
, PA_PROJ_STRUCTURE_TYPES PST
WHERE P.PROJECT_ID = T.PROJECT_ID
AND P.PROJECT_ID = E.PROJECT_ID
AND E.OBJECT_TYPE = 'PA_STRUCTURES'
AND E.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_ID = 6 UNION ALL SELECT P.PROJECT_ID
, E.PROJ_ELEMENT_ID TASK_ID
, 0
FROM PA_PROJECTS_ALL P
, PA_PROJ_ELEMENT_VERSIONS E
, PA_PROJ_STRUCTURE_TYPES PST
WHERE P.PROJECT_ID = E.PROJECT_ID
AND E.OBJECT_TYPE = 'PA_STRUCTURES'
AND E.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_ID = 6 UNION ALL SELECT - 1
, -1
, TO_NUMBER(NULL)
FROM DUAL UNION ALL SELECT -1
, 0
, TO_NUMBER(NULL) PARENT_ELEMENT_ID
FROM DUAL UNION ALL SELECT P.PROJECT_ID
, -1*T.TASK_ID
, T.TASK_ID
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_PROJ_ELEMENT_VERSIONS E
, PA_PROJ_STRUCTURE_TYPES PST
WHERE P.PROJECT_ID = T.PROJECT_ID
AND P.PROJECT_ID = E.PROJECT_ID
AND E.OBJECT_TYPE = 'PA_STRUCTURES'
AND E.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_ID = 6 UNION ALL SELECT P.PROJECT_ID
, -1*E.PROJ_ELEMENT_ID TASK_ID
, E.PROJ_ELEMENT_ID TASK_ID
FROM PA_PROJECTS_ALL P
, PA_PROJ_ELEMENT_VERSIONS E
, PA_PROJ_STRUCTURE_TYPES PST
WHERE P.PROJECT_ID = E.PROJECT_ID
AND E.OBJECT_TYPE = 'PA_STRUCTURES'
AND E.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PST.STRUCTURE_TYPE_ID = 6