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_PAGE_REGIONS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'