View: PA_PROJ_PAGE_REGIONS_V

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

View Text

SELECT PPT.ORG_ID
, PPA.PROJECT_ID
, 'PROJECT_TYPE'
, EPV.PAGE_ID
, EPV.CLASSIFICATION_CODE
, EPV.INTERNAL_NAME
, EPV.DISPLAY_NAME
, EPV.SEQUENCE
, EPV.DATA_LEVEL_INT_NAME
, EPV.DATA_LEVEL_DISP_NAME
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES PPT
, EGO_PAGES_V EPV
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND EPV.CLASSIFICATION_CODE = 'PROJECT_TYPE:'||PPT.PROJECT_TYPE_ID
AND PPA.ORG_ID = PPT.ORG_ID UNION ALL SELECT DISTINCT PPA.ORG_ID
, PPA.PROJECT_ID
, 'CLASS_CATEGORY'
, EPV.PAGE_ID
, EPV.CLASSIFICATION_CODE
, EPV.INTERNAL_NAME
, EPV.DISPLAY_NAME
, EPV.SEQUENCE
, EPV.DATA_LEVEL_INT_NAME
, EPV.DATA_LEVEL_DISP_NAME
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_CLASSES PPC
, PA_CLASS_CATEGORIES PCC
, EGO_PAGES_V EPV
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND EPV.CLASSIFICATION_CODE = 'CLASS_CATEGORY:'||PCC.CLASS_CATEGORY_ID UNION ALL SELECT PPA.ORG_ID
, PPA.PROJECT_ID
, 'CLASS_CODE'
, EPV.PAGE_ID
, EPV.CLASSIFICATION_CODE
, EPV.INTERNAL_NAME
, EPV.DISPLAY_NAME
, EPV.SEQUENCE
, EPV.DATA_LEVEL_INT_NAME
, EPV.DATA_LEVEL_DISP_NAME
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_CLASSES PPC
, PA_CLASS_CODES PCC
, EGO_PAGES_V EPV
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND PPC.CLASS_CODE = PCC.CLASS_CODE
AND EPV.CLASSIFICATION_CODE = 'CLASS_CODE:'||PCC.CLASS_CODE_ID

Columns