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_DESCRIPTORS_TL

Object Details

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

There are 2 kinds of descriptors:
Base(Root) and
Local(Category) descriptors.
This table stores both these descriptors. This holds the translation information for all the descriptors.
For Local Descriptors, the column RT_CATEGORY_ID holds the Item Category Id reference value.
For Base Descriptors, the column RT_CATEGORY_ID stores the Root Category Id value. I.e. "0"
The attributes STORED_IN_TABLE and STORED_IN_COLUMN contains the table name and the column name where the attribute's value is stored for an item. These column values will be seeded for all the seeded base attributes. For example, for the base attribute "SUPPLIER", STORED_IN_TABLE will be populated with "ICX_CAT_ITEMS_TLP" and STORED_IN_COLUMN will be populated with "SUPPLIER".
When a new attribute is created, the values for the columns STORED_IN_TABLE and STORED_IN_COLUMNS are derived from the:
- Type of the Attribute (BASE/LOCAL)
- Data Type of the Attribute (TEXT/NUMERIC/TRANSLATABLE TEXT)
- Section Map value for the associated category.
SECTION_TAG is a number that is unique within a category. SECTION_TAG this is used for category attributes or base attributes created by users to derive which column in ICX_CAT_ITEMS_TLP or ICX_CAT_EXT_ITEMS_TLP stores this attribute.
The section_tag value is also used as the section tag in the CTX string if the attribute is searchable. For category attributes, section_tag starts at 5000 so it can be distinguished from the base attributes in the CTX string. To deduce the column, subtract 5000 from it. For non-seeded base attributes, section_tag starts for 1000. For seeded base attributes, section_tag will be seeded.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_DESCRIPTORS_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RT_DESCRIPTOR_ID LANGUAGE
ICX_CAT_DESCRIPTORS_TL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	KEY RT_CATEGORY_ID LANGUAGE
ICX_CAT_DESCRIPTORS_TL_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DESCRIPTOR_NAME RT_CATEGORY_ID LANGUAGE
ICX_CAT_DESCRIPTORS_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_CATEGORY_ID LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
RT_DESCRIPTOR_ID	NUMBER		Yes	Internal identifier for a Descriptor.
LANGUAGE	VARCHAR2	(4)	Yes	Defined language for the row
SOURCE_LANG	VARCHAR2	(4)	Yes	Source language for the row
TITLE	VARCHAR2	(500)		Title of the descriptor source
DESCRIPTOR_NAME	VARCHAR2	(250)	Yes	Descriptor name
DESCRIPTION	VARCHAR2	(2000)		Description
RT_CATEGORY_ID	NUMBER		Yes	Item Category Id. (References ICX_CAT_CATEGORIES_TL.rt_category_id)
TYPE	NUMBER		Yes	Type of the descriptor. Stores 0 for Text based descriptor1 for Numeric descriptor2 for Translatable text based descriptor.
HIDDEN	NUMBER			Hidden
SEQUENCE	NUMBER			Sequence of the descriptor
KEY	VARCHAR2	(250)	Yes	Descriptor Key
DEFAULTVALUE	VARCHAR2	(2000)		Default value
MULTI_VALUE_TYPE	NUMBER			Multi value type
MULTI_VALUE_KEY	VARCHAR2	(2000)		Multi value key
REQUIRED	NUMBER			Required
REFINABLE	NUMBER			Refinable
SEARCHABLE	NUMBER			Decides whether descriptor value is searchable. Store 1 if Searchable. 0 for non searchable attributes.
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
SEARCH_RESULTS_VISIBLE	VARCHAR2	(1)		Flag controlling the visibility of the attribute in the Search results. Value of 1 makes the attribute available in the search. Value of 0 hides the attributes availability in the search.
ITEM_DETAIL_VISIBLE	VARCHAR2	(1)		Flag controlling the visibility of the attribute in the Item Details. Value of 1 makes the attribute available in the Item Detail. Value of 0 hides the attributes availability in the Item Detail.
VALIDATED	NUMBER			Validated
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 Descriptor Definition.
CLASS	VARCHAR2	(30)		Specifies whether attribute is a base/price/category attribute. Stores either of the values, 'ICX_BASE_ATTR'/ 'ICX_CAT_ATTR'/ 'ICX_PRICE_ATTR'
CUSTOMIZATION_LEVEL	VARCHAR2	(30)		Customization level
MULTIVALUE	VARCHAR2	(1)		Specifies whether the attribute is a multivalue attribute or not.
SECTION_TAG	NUMBER			Section Tag. Value decides the bit position of the section map in the corresponding category
STORED_IN_TABLE	VARCHAR2	(30)		Stored in table
STORED_IN_COLUMN	VARCHAR2	(30)		Stored in column. The column in which the descriptor value is populated.

Query Text

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


SELECT RT_DESCRIPTOR_ID
,      LANGUAGE
,      SOURCE_LANG
,      TITLE
,      DESCRIPTOR_NAME
,      DESCRIPTION
,      RT_CATEGORY_ID
,      TYPE
,      HIDDEN
,      SEQUENCE
,      KEY
,      DEFAULTVALUE
,      MULTI_VALUE_TYPE
,      MULTI_VALUE_KEY
,      REQUIRED
,      REFINABLE
,      SEARCHABLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SEARCH_RESULTS_VISIBLE
,      ITEM_DETAIL_VISIBLE
,      VALIDATED
,      BATCH_JOB_NUM
,      REBUILD_FLAG
,      CLASS
,      CUSTOMIZATION_LEVEL
,      MULTIVALUE
,      SECTION_TAG
,      STORED_IN_TABLE
,      STORED_IN_COLUMN
FROM ICX.ICX_CAT_DESCRIPTORS_TL;

Dependencies

[top of page]

ICX.ICX_CAT_DESCRIPTORS_TL does not reference any database object

ICX.ICX_CAT_DESCRIPTORS_TL is referenced by following:

APPS: ICX_CAT_DESCRIPTORS_TL