VIEW: APPS.PA_PROJ_PAGE_REGIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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