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

TABLE: ICX.ICX_REGIONS

Object Details
Object Name: ICX_REGIONS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_REGIONS
Subobject Name:
Status: VALID


ICX_REGIONS is a table which contains region information of a Self-Service Web Applications page.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_REGIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_REGION_ID
Columns
Name Datatype Length Mandatory Comments
REGION_ID NUMBER
Yes Unique identifier of region, ID is generated by ICX_REGIONS_S sequence
PARENT_REGION_ID NUMBER
Yes ID of this region's parent
SPLIT_MODE NUMBER

Defines which mode this region is split to, valid values are 0 and 1.
PORTLET_ALIGNMENT NUMBER

Alignment of portlets within the same region, valid values are 0 and 1.
HEIGHT NUMBER

Height of region
WIDTH NUMBER

width of region
WIDTH_RESTRICT NUMBER

it's in ICX code, but not being used for painting plugs of PHP.
PORTLET_FLOW NUMBER

Not being used, may use for future development
BORDER VARCHAR2 (30)
border width of region
NAVWIDGET_ID NUMBER

Not being used, may be used for future development
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column
Query Text

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


SELECT REGION_ID
,      PARENT_REGION_ID
,      SPLIT_MODE
,      PORTLET_ALIGNMENT
,      HEIGHT
,      WIDTH
,      WIDTH_RESTRICT
,      PORTLET_FLOW
,      BORDER
,      NAVWIDGET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_REGIONS;

Dependencies

[top of page]

ICX.ICX_REGIONS does not reference any database object

ICX.ICX_REGIONS is referenced by following:

SchemaAPPS
SynonymICX_REGIONS