[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RT_CATEGORY_ID | NUMBER | Yes | Parent Category ID | |
CHILD | NUMBER | Yes | Child Category ID | |
TYPE | NUMBER | Not used | ||
NAME | VARCHAR2 | (128) | Not used | |
QUERY | VARCHAR2 | (500) | Not used | |
DESCRIPTION | VARCHAR2 | (500) | Not used | |
LANGUAGE | VARCHAR2 | (4) | Yes | Not used |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Not used |
SEQUENCE | NUMBER | Not used | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
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;
ICX.ICX_POR_TABLE_OF_CONTENTS_TL does not reference any database object
ICX.ICX_POR_TABLE_OF_CONTENTS_TL is referenced by following:
|
|
|