[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PA.PA_PAGE_LAYOUT_REGIONS does not reference any database object
PA.PA_PAGE_LAYOUT_REGIONS is referenced by following:
|
|
|