VIEW: APPS.PA_LATEST_FIN_STRUC_VER_ID_V

Source

View Text - Preformatted

SELECT ppevs.element_version_id, ppevs.project_id from pa_proj_elements ppex, pa_proj_structure_types ppst, pa_structure_types pst, pa_proj_elem_ver_structure ppevs WHERE ppex.proj_element_id = ppst.proj_element_id and ppex.project_id = ppevs.project_id and ppex.proj_element_id = ppevs.proj_element_id and ppst.structure_type_id = pst.structure_type_id and pst.structure_type_class_code = 'FINANCIAL' and ((ppevs.status_code = 'STRUCTURE_PUBLISHED' and ( ppevs.process_code is null or ppevs.process_code = 'PRE') ))

View Text - HTML Formatted

SELECT PPEVS.ELEMENT_VERSION_ID
, PPEVS.PROJECT_ID
FROM PA_PROJ_ELEMENTS PPEX
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS
WHERE PPEX.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPEX.PROJECT_ID = PPEVS.PROJECT_ID
AND PPEX.PROJ_ELEMENT_ID = PPEVS.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.STRUCTURE_TYPE_CLASS_CODE = 'FINANCIAL'
AND ((PPEVS.STATUS_CODE = 'STRUCTURE_PUBLISHED'
AND ( PPEVS.PROCESS_CODE IS NULL OR PPEVS.PROCESS_CODE = 'PRE') ))