VIEW: APPS.PA_STRUCTURE_NAMES_V

Source

View Text - Preformatted

SELECT ppe.name ,ppe.element_number ,ppe.proj_element_id ,ppe.project_id ,ppa.name ,pst.structure_type_id ,lu1.meaning ,lu1.lookup_code ,lu2.meaning ,lu2.lookup_code ,st.structure_type FROM pa_proj_elements ppe, pa_proj_structure_types pst, pa_projects_all ppa, fnd_lookups lu1, fnd_lookups lu2, pa_structure_types st WHERE ppe.object_type = 'PA_STRUCTURES' AND ppe.proj_element_id = pst.proj_element_id AND ppe.project_id = ppa.project_id AND lu1.lookup_type = 'YES_NO' AND lu2.lookup_type = 'YES_NO' AND lu1.lookup_code = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(pst.proj_element_id,'WORKPLAN') AND lu2.lookup_code = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(pst.proj_element_id,'FINANCIAL') AND st.structure_type_id = pst.structure_type_id AND ppe.project_id <> 0

View Text - HTML Formatted

SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPE.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
, PPA.NAME
, PST.STRUCTURE_TYPE_ID
, LU1.MEANING
, LU1.LOOKUP_CODE
, LU2.MEANING
, LU2.LOOKUP_CODE
, ST.STRUCTURE_TYPE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_STRUCTURE_TYPES PST
, PA_PROJECTS_ALL PPA
, FND_LOOKUPS LU1
, FND_LOOKUPS LU2
, PA_STRUCTURE_TYPES ST
WHERE PPE.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPE.PROJ_ELEMENT_ID = PST.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPA.PROJECT_ID
AND LU1.LOOKUP_TYPE = 'YES_NO'
AND LU2.LOOKUP_TYPE = 'YES_NO'
AND LU1.LOOKUP_CODE = PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(PST.PROJ_ELEMENT_ID
, 'WORKPLAN')
AND LU2.LOOKUP_CODE = PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(PST.PROJ_ELEMENT_ID
, 'FINANCIAL')
AND ST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND PPE.PROJECT_ID <> 0