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_CAT_CATEGORIES_TL

Object Details

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

Categories are used to classify items into groups of related items.This table uses a flattened version of the base table/translation table structure usually used to support multilingual data. This approach was chosen because the number and relative size of the translatable columns closely matches or exceeds that of the non-translatable columns
There are 4 types of categories stored in this table:
1. Root category - A special type of seeded Browsing Category - This is the topmost category in the hierarchy (TYPE = 0)
2. Navigational or Browsing Categories (TYPE = 1)
3. Genus or Item Categories (TYPE = 2)
4. Requisition Templates - Requisition Templates from Core Purchasing are stored as categories with the key as <"ReqTemplate name">_tmpl (TYPE = 3)
Categories are uniquely identified by the KEY and LANGUAGE. This value can not be modified once it is created. ITEM_COUNT tells us the number of items the category contains.
REBUILD_FLAG Indicates whether the Oracle Text Index should be rebuilt due to changes in the Category Definition. Typically this is set when a category definition is changed.
Attribute SECTION_MAP, stores a bitmap to indicate whether a particular section tag is assigned already. Also used to derive STORED_IN_TABLE and STORED_IN_COLUMN.
If category id is 0,
If the n-th bit is 1 and 1<=n<=100, it means TEXT_BASE_ATTRIBUTEn column in ICX_CAT_ITEMS_TLP is already assigned to an existing text base attribute.
If the n-th bit is 1 and 100 If the n-th bit is 1 and 200 If category id > 0,
If the n-th bit is 1 and 1<=n<=50, it means TEXT_CAT_ATTRIBUTEn column in ICX_CAT_EXT_ITEMS_TLP is already assigned to an existing text category attribute.
If the n-th bit is 1 and 50 If the n-th bit is 1 and 100 Every time a new attribute is created, the section_map of the corresponding category will be updated and one of the bits will be flipped from 0 to 1.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_CATEGORIES_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RT_CATEGORY_ID LANGUAGE ZD_EDITION_NAME
ICX_CAT_CATEGORIES_TL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	KEY TYPE LANGUAGE ZD_EDITION_NAME
ICX_CAT_CATEGORIES_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_NAME TYPE LANGUAGE
ICX_CAT_CATEGORIES_TL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER_CATEGORY_NAME TYPE LANGUAGE
ICX_CAT_CATEGORIES_TL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER_KEY TYPE LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
RT_CATEGORY_ID	NUMBER		Yes	Internal identifier for a category.
LANGUAGE	VARCHAR2	(4)	Yes	Defined language for the row
SOURCE_LANG	VARCHAR2	(4)	Yes	Source language for the row
CATEGORY_NAME	VARCHAR2	(250)	Yes	Name of the Category
DESCRIPTION	VARCHAR2	(2000)		Description for the Category
TYPE	NUMBER		Yes	Type of the category - Root, Navigational, Genus or Req. Template. Possible values are 0, 1,2, and 3 respectively.
KEY	VARCHAR2	(250)	Yes	Unique key for the Category
TITLE	VARCHAR2	(500)		Data Source of the Category. Stores the value "Oracle" for extracted categories and null for bulkloaded categories.
ITEM_COUNT	NUMBER			Number of items in this category
CREATED_BY	NUMBER		Yes	Standard Who column: the user who created this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE		Yes	Standard Who column: date when this record was created
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column: date when this record was last updated
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.)
REQUEST_ID	NUMBER			Concurrent Request Id through which category was created. Stores null for categories created/edited online.
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column: the application that owns the concurrent program that created or updated this record. (References FND_CONCURRENT_PROGRAMS.application_id.)
PROGRAM_ID	NUMBER			Standard Who column: the concurrent program that created or updated this record. (References FND_CONCURRENT_PROGRAMS.concurrent_program_id.)
PROGRAM_UPDATE_DATE	DATE			Standard Who column: the date when this record was created or updated by a concurrent program
UPPER_CATEGORY_NAME	VARCHAR2	(250)	Yes	Category name in upper case
BATCH_JOB_NUM	NUMBER			Concurrent Request Id through which category was created. Stores null for categories created/edited online.
REBUILD_FLAG	VARCHAR2	(1)		Indicates whether the Oracle Text Index should be rebuilt due to changes in the Category Definition.
UPPER_KEY	VARCHAR2	(250)	Yes	Category Key in Upper Case
SECTION_MAP	VARCHAR2	(300)		A bitmap that controls which columns in ICX_CAT_ITEMS_TLP and ICX_CAT_EXT_ITEMS_TLP are free and can be assigned to new attributes.
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT RT_CATEGORY_ID
,      LANGUAGE
,      SOURCE_LANG
,      CATEGORY_NAME
,      DESCRIPTION
,      TYPE
,      KEY
,      TITLE
,      ITEM_COUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UPPER_CATEGORY_NAME
,      BATCH_JOB_NUM
,      REBUILD_FLAG
,      UPPER_KEY
,      SECTION_MAP
,      PROGRAM_LOGIN_ID
,      ZD_EDITION_NAME
FROM ICX.ICX_CAT_CATEGORIES_TL;

Dependencies

[top of page]

ICX.ICX_CAT_CATEGORIES_TL does not reference any database object

ICX.ICX_CAT_CATEGORIES_TL is referenced by following:

ICX: ICX_CAT_CATEGORIES_TL#