[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PAGE_TYPE_REGIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PAGE_TYPE_CODE
REGION_SOURCE_TYPE REGION_SOURCE_CODE |
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 |
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
FROM PA.PA_PAGE_TYPE_REGIONS;
PA.PA_PAGE_TYPE_REGIONS does not reference any database object
PA.PA_PAGE_TYPE_REGIONS is referenced by following:
|
|
|