Search Results document_source

Overview

PA_PAGE_REGIONS_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the region-level composition of Project Progress Report pages, resolving the layout definition of each report page into its constituent regions together with their sources, view and edit region codes, display sequencing, and the associated document source. The view consolidates three different region source patterns — standard/Gantt regions, descriptive flexfield (DFF) driven regions, and extension-defined regions — via a series of UNION ALL branches, yielding a single uniform rowset for any given progress report page.

Its primary role is as a metadata access layer for the Progress Report page-rendering and configuration framework. Rather than requiring callers to join PA_PAGE_LAYOUT_REGIONS, PA_PROGRESS_REPORT_VERS, and PA_PAGE_TYPE_REGIONS directly, the view pre-joins these and normalizes region properties into consistent column positions. The DOCUMENT_SOURCE column — a term frequently searched in this context — is projected from PA_PAGE_TYPE_REGIONS and identifies the source document type backing a given page region, making it a key discriminator when enumerating or filtering regions.

Underlying Base Objects

The documented base objects for this view are:

• PA_PAGE_LAYOUT_REGIONS (synonym) — the page layout region definitions, supplying region source type, source code, view region code, edit region code, and display order.
• PA_PROGRESS_REPORT_VERS (synonym) — the progress report version header, supplying object identity, page identity, page type code, and version.
• PA_PAGE_TYPE_REGIONS (synonym) — the page type to region mapping, supplying DOCUMENT_SOURCE, page function name, and security function name.
• FND_DESCR_FLEX_CONTEXTS_VL (view) — the descriptive flexfield context definitions, used exclusively in the DFF branch to resolve context names for page type PPR against application 275 and flexfield PA_STATUS_REPORT_DESC_FLEX.
• EGO_PAGES_V (view) and PA_EXT_ATTRIBUTE_UTILS (package) — referenced base objects supporting extension-driven region resolution.

Each branch joins PA_PAGE_LAYOUT_REGIONS to PA_PROGRESS_REPORT_VERS on PAGE_ID and constrains PAGE_TYPE_CODE to PPR. The standard branch filters REGION_SOURCE_TYPE to values beginning with STD or equal to GANTT; the DFF branch restricts to DFF and resolves context names through the flexfield view; the extension branch resolves region codes through the extension utilities.

Key Columns

• OBJECT_ID / OBJECT_TYPE — identity of the progress report object to which the page belongs.
• PAGE_ID / PAGE_TYPE_CODE / VERSION_ID — the page and its version; PAGE_TYPE_CODE is constrained to PPR.
• REGION_SOURCE_TYPE / REGION_SOURCE_CODE — classification and identifier of the region source (standard, Gantt, DFF, or extension).
• VIEW_REGION_CODE / EDIT_REGION_CODE — the region codes used when the region is rendered in view or edit mode. For DFF regions these are populated with the descriptive flexfield context name.
• DISPLAY_ORDER — sequencing value controlling region presentation order on the page.
• DOCUMENT_SOURCE — the document source associated with the page type region, supplied from PA_PAGE_TYPE_REGIONS; used to identify the originating document for the region.
• PAGE_FUNCTION_NAME / SECURITY_FUNCTION_NAME — the form function and security function governing access to the page region.

Common Use Cases and Queries

Typical uses include auditing region configuration for progress report pages, determining the view and edit region codes bound to a page version, and identifying the DOCUMENT_SOURCE and security function for a region. The following query lists all regions for a given page with their document source and ordering:

• SELECT page_id, version_id, region_source_type, region_source_code, view_region_code, edit_region_code, display_order, document_source FROM pa_page_regions_v WHERE page_id = :page_id ORDER BY display_order;
• SELECT DISTINCT document_source, page_function_name, security_function_name FROM pa_page_regions_v WHERE page_type_code = 'PPR';
• SELECT region_source_type, COUNT(*) FROM pa_page_regions_v GROUP BY region_source_type;

Because the view is read-only and pre-joined, it is suitable for custom reporting and integration extracts without additional join logic.