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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_PAGE_LAYOUT_REGIONS

Object Details

Object Name:	PA_PAGE_LAYOUT_REGIONS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PAGE_LAYOUT_REGIONS
Subobject Name:
Status:	VALID

This table contains all regions that are included in a page layout.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PAGE_LAYOUT_REGIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	PAGE_ID REGION_SOURCE_TYPE REGION_SOURCE_CODE
PA_PAGE_LAYOUT_REGIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	REGION_SOURCE_CODE REGION_SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PAGE_ID	NUMBER	(15)	Yes	Identifier of the page
VIEW_REGION_CODE	VARCHAR2	(250)	Yes	XML document path of the view only region
EDIT_REGION_CODE	VARCHAR2	(250)		XML document path of the editable region
DISPLAY_ORDER	NUMBER			The order in which the regions appear on the page
RECORD_VERSION_NUMBER	NUMBER		Yes	Number used for record locking in self-service applications
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REGION_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of the region. For example, STD (Standard)for Oracle seeded regions, or DFF (Descriptive Flexfield) for user-defined regions.
REGION_SOURCE_CODE	VARCHAR2	(250)	Yes	Depending on the Region_Source_Type, either theXML document path of the region or the Descriptive Flexfield context code
REGION_STYLE	VARCHAR2	(30)		Indicates style of the region

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAGE_ID
,      VIEW_REGION_CODE
,      EDIT_REGION_CODE
,      DISPLAY_ORDER
,      RECORD_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REGION_SOURCE_TYPE
,      REGION_SOURCE_CODE
,      REGION_STYLE
FROM PA.PA_PAGE_LAYOUT_REGIONS;

Dependencies

[top of page]

PA.PA_PAGE_LAYOUT_REGIONS does not reference any database object

PA.PA_PAGE_LAYOUT_REGIONS is referenced by following:

APPS: PA_PAGE_LAYOUT_REGIONS