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_ATTRIBUTES_TL

Object Details

Object Name:	ICX_CAT_ATTRIBUTES_TL
Object Type:	TABLE
Owner:	ICX
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 "DESCRIPTION", STORED_IN_TABLE will be populated with "PO_ATTRIBUTE_VALUES_TLP" and STORED_IN_COLUMN will be populated with "DESCRIPTION".
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 PO_ATTRIBUTE_VALUES or PO_ATTRIBUTE_VALUES_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_ATTRIBUTES_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID LANGUAGE ZD_EDITION_NAME
ICX_CAT_ATTRIBUTES_TL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	KEY RT_CATEGORY_ID LANGUAGE ZD_EDITION_NAME
ICX_CAT_ATTRIBUTES_TL_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_NAME RT_CATEGORY_ID LANGUAGE ZD_EDITION_NAME
ICX_CAT_ATTRIBUTES_TL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RT_CATEGORY_ID LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_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
ATTRIBUTE_NAME	VARCHAR2	(250)	Yes	Attribute 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.
SEQUENCE	NUMBER			Sequence of the descriptor
KEY	VARCHAR2	(250)	Yes	Descriptor Key
SEARCHABLE	NUMBER			Decides whether descriptor value is searchable. Store 1 if Searchable. 0 for non searchable attributes.
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.
SECTION_TAG	NUMBER			Section Tag. Value decides the bit position of the section map in the corresponding category
STORED_IN_TABLE	VARCHAR2	(30)		Table where the Attribute's Value is stored. Valid values are null : When the Attribute's value is either calculated or stored in PO_LINES_ALL table. PO_ATTRIBUTE_VALUES : When the Attribute's value is stored in PO_ATTRUBUTE_VALUES PO_ATTRIBUTE_VALUES_TLP : When the Attribute's value is stored in PO_ATTRUBUTE_VALUES_TLP
STORED_IN_COLUMN	VARCHAR2	(30)		Stored in column. The column in which the descriptor value is populated.
REQUEST_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER			Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID
REBUILD_FLAG	VARCHAR2	(1)		Indicates whether the Oracle Text Index should be rebuilt due to changes in the Descriptor Definition.
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.)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ATTRIBUTE_ID
,      LANGUAGE
,      SOURCE_LANG
,      ATTRIBUTE_NAME
,      DESCRIPTION
,      RT_CATEGORY_ID
,      TYPE
,      SEQUENCE
,      KEY
,      SEARCHABLE
,      SEARCH_RESULTS_VISIBLE
,      ITEM_DETAIL_VISIBLE
,      SECTION_TAG
,      STORED_IN_TABLE
,      STORED_IN_COLUMN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      REBUILD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM ICX.ICX_CAT_ATTRIBUTES_TL;

Dependencies

[top of page]

ICX.ICX_CAT_ATTRIBUTES_TL does not reference any database object

ICX.ICX_CAT_ATTRIBUTES_TL is referenced by following:

ICX: ICX_CAT_ATTRIBUTES_TL#