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: ICX.ICX_PAGE_PLUGS

Object Details

Object Name:	ICX_PAGE_PLUGS
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_PAGE_PLUGS
Subobject Name:
Status:	VALID

ICX_PAGE_PLUGS is a table which contains plug information of a page. Each page can be divided into multiple regions, and each regions may contain multiple plugs. This table also serves the purpose of containing information of page-region-plug.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_PAGE_PLUGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAGE_ID PLUG_ID
ICX_PAGE_PLUGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLUG_ID
ICX_PAGE_PLUGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLUG_ID	NUMBER		Yes	Unique identifier of plug, ID is generated by ICX_PAGE_PLUGS_S sequence.
PAGE_ID	NUMBER		Yes	ID of page which the plug is on
DISPLAY_SEQUENCE	NUMBER		Yes	Display sequence of plug within a page region
RESPONSIBILITY_APPLICATION_ID	NUMBER			Application ID of responsibility
RESPONSIBILITY_ID	NUMBER		Yes	ID of responsibility
SECURITY_GROUP_ID	NUMBER			security group identifier, in which security groups is used to partition data in a Service Bureau architecture
MENU_ID	NUMBER		Yes	Identifier of menu
ENTRY_SEQUENCE	NUMBER		Yes	Sequence number under this menu
DISPLAY_NAME	VARCHAR2	(100)		Display name of plug, this is customized by user
REGION_ID	NUMBER			Identifier of region which the plug resides in.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER			Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column

Query Text

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


SELECT PLUG_ID
,      PAGE_ID
,      DISPLAY_SEQUENCE
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      SECURITY_GROUP_ID
,      MENU_ID
,      ENTRY_SEQUENCE
,      DISPLAY_NAME
,      REGION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_PAGE_PLUGS;

Dependencies

[top of page]

ICX.ICX_PAGE_PLUGS does not reference any database object

ICX.ICX_PAGE_PLUGS is referenced by following:

APPS: ICX_PAGE_PLUGS