VIEW: APPS.PA_FIN_WP_TASKS_V

Source

View Text - Preformatted

SELECT ppe.name, ppe.element_number, ppe.proj_element_id, ppe.project_id, ppst.structure_type_id, pst.structure_type_class_code, pl.meaning FROM pa_proj_elements ppe, pa_proj_elements ppe2, pa_proj_structure_types ppst, pa_structure_types pst, pa_lookups pl WHERE ppe.parent_structure_id = ppe2.proj_element_id AND ppe.project_id = ppe2.project_id AND ppe2.proj_element_id in ( select proj_element_id from pa_proj_structure_types group by proj_element_id having count(proj_element_id) = 1) AND ppst.proj_element_id = ppe2.proj_element_id AND ppst.structure_type_id = pst.structure_type_id AND pl.lookup_code = pst.structure_type AND pl.lookup_type = 'PA_STRUCTURE_TYPE_CLASS' AND exists ( select 1 from pa_proj_elem_ver_structure where project_id = ppe2.project_id and proj_element_id = ppe2.proj_element_id and status_code = 'STRUCTURE_PUBLISHED') UNION SELECT ppe.name, ppe.element_number, ppe.proj_element_id, ppe.project_id, ppst.structure_type_id, pst.structure_type_class_code, pl.meaning FROM pa_proj_elements ppe, pa_proj_elements ppe2, pa_proj_structure_types ppst, pa_structure_types pst, pa_lookups pl WHERE ppe.parent_structure_id = ppe2.proj_element_id AND ppe.project_id = ppe2.project_id AND ppe2.proj_element_id in ( select proj_element_id from pa_proj_structure_types group by proj_element_id having count(proj_element_id) = 2) AND ppst.proj_element_id = ppe2.proj_element_id AND ppst.structure_type_id = pst.structure_type_id AND pst.structure_type_class_code = 'WORKPLAN' AND pl.lookup_code = pst.structure_type AND pl.lookup_type = 'PA_STRUCTURE_TYPE_CLASS' AND exists ( select 1 from pa_proj_elem_ver_structure where project_id = ppe2.project_id and proj_element_id = ppe2.proj_element_id and status_code = 'STRUCTURE_PUBLISHED')

View Text - HTML Formatted

SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
WHERE PPE.PARENT_STRUCTURE_ID = PPE2.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPE2.PROJECT_ID
AND PPE2.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID
FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 1)
AND PPST.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND EXISTS ( SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE
WHERE PROJECT_ID = PPE2.PROJECT_ID
AND PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND STATUS_CODE = 'STRUCTURE_PUBLISHED') UNION SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPST.STRUCTURE_TYPE_ID
, PST.STRUCTURE_TYPE_CLASS_CODE
, PL.MEANING
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_LOOKUPS PL
WHERE PPE.PARENT_STRUCTURE_ID = PPE2.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPE2.PROJECT_ID
AND PPE2.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID
FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 2)
AND PPST.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN'
AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE
AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND EXISTS ( SELECT 1
FROM PA_PROJ_ELEM_VER_STRUCTURE
WHERE PROJECT_ID = PPE2.PROJECT_ID
AND PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID
AND STATUS_CODE = 'STRUCTURE_PUBLISHED')