VIEW: APPS.PA_STRUCTURE_VERSION_NAMES_V

Source

View Text - Preformatted

SELECT pevs.name ,pevs.version_number ,pevs.element_version_id ,ppe.proj_element_id ,ppe.name ,ppe.project_id ,pevs.published_date ,pevs.status_code FROM pa_proj_elem_ver_structure pevs, pa_proj_elements ppe WHERE pevs.proj_element_id = ppe.proj_element_id and pevs.project_id = ppe.project_id AND pevs.project_id <> 0

View Text - HTML Formatted

SELECT PEVS.NAME
, PEVS.VERSION_NUMBER
, PEVS.ELEMENT_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPE.PROJECT_ID
, PEVS.PUBLISHED_DATE
, PEVS.STATUS_CODE
FROM PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_PROJ_ELEMENTS PPE
WHERE PEVS.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PEVS.PROJECT_ID = PPE.PROJECT_ID
AND PEVS.PROJECT_ID <> 0