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_TYPE_REGIONS

Object Details

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

This table contains all the regions that can be included in a page layout.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PAGE_TYPE_REGIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	PAGE_TYPE_CODE REGION_SOURCE_TYPE REGION_SOURCE_CODE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PAGE_TYPE_CODE	VARCHAR2	(30)	Yes	Type 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
MANDATORY_FLAG	VARCHAR2	(1)		Specifies whether this section is mandatory for the page type
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
DEFAULT_REGION_POSITION	VARCHAR2	(1)		Indicates the default column the region will be positioned in a muti column page layouts. L - Left R - Right C - Center
PLACEHOLDER_REGION_FLAG	VARCHAR2	(1)		Indicates the region is a place holder region, which can be replaced at object level
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 the XML document path of the region or the Descriptive Flexfield context code
REGION_STYLE	VARCHAR2	(30)		Region style for the user configurable sections
START_DATE_ACTIVE	DATE		Yes	Effective start date for the region.
END_DATE_ACTIVE	DATE			Effective end date for the region.
DOCUMENT_SOURCE	VARCHAR2	(250)		Document source of the region.
PAGE_FUNCTION_NAME	VARCHAR2	(430)		Function name of the page for the regions shown as links
SECURITY_FUNCTION_NAME	VARCHAR2	(430)		Security function name for the region
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT PAGE_TYPE_CODE
,      VIEW_REGION_CODE
,      EDIT_REGION_CODE
,      DISPLAY_ORDER
,      MANDATORY_FLAG
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEFAULT_REGION_POSITION
,      PLACEHOLDER_REGION_FLAG
,      REGION_SOURCE_TYPE
,      REGION_SOURCE_CODE
,      REGION_STYLE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DOCUMENT_SOURCE
,      PAGE_FUNCTION_NAME
,      SECURITY_FUNCTION_NAME
,      ZD_EDITION_NAME
FROM PA.PA_PAGE_TYPE_REGIONS;

Dependencies

[top of page]

PA.PA_PAGE_TYPE_REGIONS does not reference any database object

PA.PA_PAGE_TYPE_REGIONS is referenced by following:

PA: PA_PAGE_TYPE_REGIONS#