VIEW: APPS.PA_STRUCT_TASKS_LITE_V

Source

View Text - Preformatted

SELECT decode(ppe.task_status,null,ppe.element_number,ppe.element_number||' ('||(select meaning from pa_lookups where lookup_type='PA_CHG_TASK_STATUSES' and lookup_code=ppe.task_status)||')') element_number ,ppv.element_version_id ,ppe.object_type ,por.object_id_from1 ,ppe.project_id ,ppv.parent_structure_version_id ,ppe.proj_element_id ,ppe.name ,ppv.display_sequence ,ppv.financial_task_flag ,ppv.wbs_number ,ppv.wbs_level ,ppv.task_unpub_ver_status_code ,ptt.prog_entry_enable_flag ,ppe.status_code FROM pa_proj_elements ppe ,pa_proj_element_versions ppv ,pa_object_relationships por ,pa_task_types ptt WHERE ppe.project_id = ppv.project_id and ppe.proj_element_id = ppv.proj_element_id and ppv.element_version_id = por.object_id_to1 and por.object_type_to = 'PA_TASKS' and ppe.object_type = ppv.object_type and ppe.object_type = 'PA_TASKS' and por.relationship_type = 'S' and (ppe.link_task_flag <> 'Y' or ppe.task_status is not null) and ppe.type_id = ptt.task_type_id and ptt.object_type = 'PA_TASKS' UNION ALL SELECT ppe.element_number ,ppv.element_version_id ,ppe.object_type ,to_number(null) object_id_from1 ,ppe.project_id ,ppv.parent_structure_version_id ,ppe.proj_element_id ,ppe.name ,ppv.display_sequence ,ppv.financial_task_flag ,ppv.wbs_number ,ppv.wbs_level ,ppv.task_unpub_ver_status_code ,'Y' , ppe.status_code FROM pa_proj_elements ppe ,pa_proj_element_versions ppv WHERE ppe.project_id = ppv.project_id and ppe.proj_element_id = ppv.proj_element_id and ppe.object_type = ppv.object_type and ppe.object_type = 'PA_STRUCTURES' and ppv.object_type = 'PA_STRUCTURES' and ppe.link_task_flag <> 'Y'

View Text - HTML Formatted

SELECT DECODE(PPE.TASK_STATUS
, NULL
, PPE.ELEMENT_NUMBER
, PPE.ELEMENT_NUMBER||' ('||(SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='PA_CHG_TASK_STATUSES'
AND LOOKUP_CODE=PPE.TASK_STATUS)||')') ELEMENT_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, POR.OBJECT_ID_FROM1
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPV.DISPLAY_SEQUENCE
, PPV.FINANCIAL_TASK_FLAG
, PPV.WBS_NUMBER
, PPV.WBS_LEVEL
, PPV.TASK_UNPUB_VER_STATUS_CODE
, PTT.PROG_ENTRY_ENABLE_FLAG
, PPE.STATUS_CODE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_OBJECT_RELATIONSHIPS POR
, PA_TASK_TYPES PTT
WHERE PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND POR.OBJECT_TYPE_TO = 'PA_TASKS'
AND PPE.OBJECT_TYPE = PPV.OBJECT_TYPE
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND POR.RELATIONSHIP_TYPE = 'S'
AND (PPE.LINK_TASK_FLAG <> 'Y' OR PPE.TASK_STATUS IS NOT NULL)
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID
AND PTT.OBJECT_TYPE = 'PA_TASKS' UNION ALL SELECT PPE.ELEMENT_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, TO_NUMBER(NULL) OBJECT_ID_FROM1
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPV.DISPLAY_SEQUENCE
, PPV.FINANCIAL_TASK_FLAG
, PPV.WBS_NUMBER
, PPV.WBS_LEVEL
, PPV.TASK_UNPUB_VER_STATUS_CODE
, 'Y'
, PPE.STATUS_CODE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
WHERE PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.OBJECT_TYPE = PPV.OBJECT_TYPE
AND PPE.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPV.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPE.LINK_TASK_FLAG <> 'Y'