View: PA_PAGE_REGIONS_V

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

View Text

SELECT PPRV.OBJECT_ID
, PPRV.OBJECT_TYPE
, PPRV.PAGE_ID
, PPRV.PAGE_TYPE_CODE
, PPRV.VERSION_ID
, PPLR.REGION_SOURCE_TYPE
, PPLR.REGION_SOURCE_CODE
, PPLR.VIEW_REGION_CODE
, PPLR.VIEW_REGION_CODE
, ''
, PPLR.EDIT_REGION_CODE
, ''
, PPLR.DISPLAY_ORDER
, 0
, PPTR.DOCUMENT_SOURCE
, PPTR.PAGE_FUNCTION_NAME
, PPTR.SECURITY_FUNCTION_NAME
FROM PA_PAGE_LAYOUT_REGIONS PPLR
, PA_PROGRESS_REPORT_VERS PPRV
, PA_PAGE_TYPE_REGIONS PPTR
WHERE PPRV.PAGE_ID = PPLR.PAGE_ID
AND (PPLR.REGION_SOURCE_TYPE LIKE 'STD%' OR PPLR.REGION_SOURCE_TYPE = 'GANTT')
AND PPRV.PAGE_TYPE_CODE = 'PPR'
AND PPTR.PAGE_TYPE_CODE = PPRV.PAGE_TYPE_CODE
AND PPTR.REGION_SOURCE_TYPE = PPLR.REGION_SOURCE_TYPE
AND PPTR.VIEW_REGION_CODE = PPLR.VIEW_REGION_CODE UNION ALL SELECT PPRV.OBJECT_ID
, PPRV.OBJECT_TYPE
, PPRV.PAGE_ID
, PPRV.PAGE_TYPE_CODE
, PPRV.VERSION_ID
, PPLR.REGION_SOURCE_TYPE
, PPLR.REGION_SOURCE_CODE
, PPLR.REGION_SOURCE_CODE
, PPLR.VIEW_REGION_CODE
, FDFV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PPLR.EDIT_REGION_CODE
, FDFV.DESCRIPTIVE_FLEX_CONTEXT_NAME
, PPLR.DISPLAY_ORDER
, 0
, PPTR.DOCUMENT_SOURCE
, PPTR.PAGE_FUNCTION_NAME
, PPTR.SECURITY_FUNCTION_NAME
FROM PA_PAGE_LAYOUT_REGIONS PPLR
, PA_PROGRESS_REPORT_VERS PPRV
, FND_DESCR_FLEX_CONTEXTS_VL FDFV
, PA_PAGE_TYPE_REGIONS PPTR
WHERE PPRV.PAGE_ID = PPLR.PAGE_ID
AND PPLR.REGION_SOURCE_TYPE = 'DFF'
AND PPRV.PAGE_TYPE_CODE = 'PPR'
AND PPLR.REGION_SOURCE_CODE = FDFV.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FDFV.APPLICATION_ID = 275
AND FDFV.DESCRIPTIVE_FLEXFIELD_NAME = 'PA_STATUS_REPORT_DESC_FLEX'
AND FDFV.ENABLED_FLAG='Y'
AND FDFV.GLOBAL_FLAG <> 'Y'
AND PPTR.PAGE_TYPE_CODE = 'PPR'
AND PPTR.REGION_SOURCE_TYPE = 'DFF'
AND PPTR.REGION_SOURCE_CODE = PPLR.REGION_SOURCE_CODE UNION ALL SELECT PPRV.OBJECT_ID
, PPRV.OBJECT_TYPE
, PPRV.PAGE_ID
, PPRV.PAGE_TYPE_CODE
, PPRV.VERSION_ID
, PPLR.REGION_SOURCE_TYPE
, PPLR.REGION_SOURCE_CODE
, PPRT.VIEW_REGION_CODE
, PPRT.VIEW_REGION_CODE
, EPV.DISPLAY_NAME
, PPLR.EDIT_REGION_CODE
, EPV.DISPLAY_NAME
, PPLR.DISPLAY_ORDER
, 0
, PPRT.DOCUMENT_SOURCE
, PPRT.PAGE_FUNCTION_NAME
, PPRT.SECURITY_FUNCTION_NAME
FROM EGO_PAGES_V EPV
, PA_PAGE_TYPE_REGIONS PPRT
, PA_PAGE_LAYOUT_REGIONS PPLR
, PA_PROGRESS_REPORT_VERS PPRV
WHERE EPV.DATA_LEVEL_INT_NAME = 'PROJECT_LEVEL'
AND EPV.OBJECT_NAME = 'PA_PROJECTS'
AND PPRV.PAGE_ID = PPLR.PAGE_ID
AND PPLR.REGION_SOURCE_TYPE = 'EA'
AND PPLR.REGION_SOURCE_CODE = EPV.PAGE_ID
AND PPRV.PAGE_TYPE_CODE = 'PPR'
AND PPRT.PAGE_TYPE_CODE = PPRV.PAGE_TYPE_CODE
AND PPRT.REGION_SOURCE_TYPE = PPLR.REGION_SOURCE_TYPE
AND PPRT.VIEW_REGION_CODE = PPLR.VIEW_REGION_CODE
AND PA_EXT_ATTRIBUTE_UTILS.CHECK_OBJECT_PAGE_REGION('PA_PROJECTS'
, PPRV.OBJECT_ID
, PPLR.REGION_SOURCE_CODE)='T'

Columns