VIEW: APPS.PA_STRUCT_VERSIONS_LOV_AMG_V

Source

View Text - Preformatted

SELECT pevs.name ,pevs.version_number ,pevs.element_version_id ,lkp.meaning ,pevs.proj_element_id ,pevs.project_id ,pevs.status_code ,st.structure_type_class_code ,pevs.latest_eff_published_flag from pa_proj_elem_ver_structure pevs ,pa_proj_structure_types pst ,pa_structure_types st ,pa_lookups lkp WHERE lkp.lookup_type = 'PA_STRUCTURE_TYPE_CLASS' and lkp.lookup_code = st.structure_type_class_code and st.structure_type_id = pst.structure_type_id and pst.proj_element_id = pevs.proj_element_id

View Text - HTML Formatted

SELECT PEVS.NAME
, PEVS.VERSION_NUMBER
, PEVS.ELEMENT_VERSION_ID
, LKP.MEANING
, PEVS.PROJ_ELEMENT_ID
, PEVS.PROJECT_ID
, PEVS.STATUS_CODE
, ST.STRUCTURE_TYPE_CLASS_CODE
, PEVS.LATEST_EFF_PUBLISHED_FLAG
FROM PA_PROJ_ELEM_VER_STRUCTURE PEVS
, PA_PROJ_STRUCTURE_TYPES PST
, PA_STRUCTURE_TYPES ST
, PA_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS'
AND LKP.LOOKUP_CODE = ST.STRUCTURE_TYPE_CLASS_CODE
AND ST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PST.PROJ_ELEMENT_ID = PEVS.PROJ_ELEMENT_ID