eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_STRUCT_PROJ_LOV_V

Source

View Text - Preformatted


SELECT ppa.project_id, ppa.name, ppa.segment1, pst.structure_type, pa_project_parties_utils.GET_PROJECT_MANAGER(ppa.project_id), pa_project_parties_utils.GET_PROJECT_MANAGER_NAME(ppa.project_id) FROM pa_projects_all ppa, pa_proj_elements ppe, pa_proj_structure_types ppst, pa_structure_types pst WHERE ppa.project_id = ppe.project_id and ppa.template_flag = 'N' and ppe.object_type = 'PA_STRUCTURES' and ppe.proj_element_id = ppst.proj_element_id and ppst.structure_type_id = pst.structure_type_id

View Text - HTML Formatted

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PST.STRUCTURE_TYPE
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(PPA.PROJECT_ID)
, PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(PPA.PROJECT_ID)
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
WHERE PPA.PROJECT_ID = PPE.PROJECT_ID
AND PPA.TEMPLATE_FLAG = 'N'
AND PPE.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID