VIEW: APPS.PA_TASK_NAMES_V

Source

View Text - Preformatted

SELECT ppe.name ,ppe.element_number ,ppv.display_sequence ,ppv.element_version_id ,ppv.parent_structure_version_id ,ppevs.name ,ppv2.proj_element_id ,ppe.project_id FROM pa_proj_elements ppe ,pa_proj_element_versions ppv ,pa_proj_element_versions ppv2 ,pa_proj_elem_ver_structure ppevs WHERE ppe.object_type = 'PA_TASKS' AND ppe.proj_element_id = ppv.proj_element_id AND ppe.project_id = ppv.project_id AND ppv.parent_structure_version_id = ppv2.element_version_id AND ppv.project_id = ppv2.project_id AND ppv.parent_structure_version_id = ppevs.element_version_id AND ppv.project_id = ppevs.project_id AND nvl(ppe.link_task_flag, 'N') <> 'Y' AND ppe.project_id <> 0

View Text - HTML Formatted

SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPV.DISPLAY_SEQUENCE
, PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPEVS.NAME
, PPV2.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS
WHERE PPE.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPV.PARENT_STRUCTURE_VERSION_ID = PPV2.ELEMENT_VERSION_ID
AND PPV.PROJECT_ID = PPV2.PROJECT_ID
AND PPV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
AND PPV.PROJECT_ID = PPEVS.PROJECT_ID
AND NVL(PPE.LINK_TASK_FLAG
, 'N') <> 'Y'
AND PPE.PROJECT_ID <> 0