[Home] [Help] [Dependency Information]

TABLE: ICX.ICX_POR_TABLE_OF_CONTENTS_TL

Object Details

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

Stores the user-defined hierarchical relationship between navigational categories to create a more traditional hierarchical view of the catalog.
Despite its name it is not an MLS table. This table simply stores data in 2 columns (RT_CATEGORY_ID and CHILD_CATEGORY_ID).
Navigational categories may be parents of other navigational or genus categories but genus categories cannot be parents of navigational categories. Any category can only have 1 parent.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_TABLE_OF_CONTS_TL_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RT_CATEGORY_ID CHILD
ICX_POR_TABLE_OF_CONTS_TL_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CHILD

Columns

Query Text

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

SELECT RT_CATEGORY_ID
,      CHILD
,      TYPE
,      NAME
,      QUERY
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      SEQUENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ICX.ICX_POR_TABLE_OF_CONTENTS_TL;

Dependencies

[top of page]

ICX.ICX_POR_TABLE_OF_CONTENTS_TL does not reference any database object

ICX.ICX_POR_TABLE_OF_CONTENTS_TL is referenced by following:

ICX

ICX_POR_TABLE_OF_CONTENTS_TL#