View: PA_STRUCT_PROJ_LOV_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_STRUCT_PROJ_LOV_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PST.STRUCTURE_TYPE
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

Columns