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_POR_DESCRIPTORS_TL

Object Details

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

Stores information about descriptors associated with a given category. Root descriptors are associated with the category ID of zero.
The descriptor ID is used to generate the descriptor column names in the item (ICX_POR_ITEMS & ICX_POR_ITEMS_TL) and category tables. Category tables are created dynamically as categories with descriptors are created. Category tables are of the form ICX_POR_C_TL. If a category does not contain descriptors no table is generated for it.
Descriptor column names are generated by concatenating A and the descriptor ID.
Sequence used for descriptors starts with a high number to reserve lower numbers for use by Oracle for seeded descriptors. Oracle currently seeds a set of root descriptors.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_POR_DESCRIPTORS_TL_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	RT_DESCRIPTOR_ID LANGUAGE
ICX_POR_DESCRIPTORS_TL_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	KEY RT_CATEGORY_ID LANGUAGE
ICX_POR_DESCRIPTORS_TL_U3	NORMAL	UNIQUE	APPS_TS_ARCHIVE	DESCRIPTOR_NAME RT_CATEGORY_ID LANGUAGE
ICX_POR_DESCRIPTORS_TL_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	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	Actual language for the row
TITLE	VARCHAR2	(500)		ID of the Originating system data source/publishing entity set to Oracle for Oracle-sourced data
DESCRIPTOR_NAME	VARCHAR2	(250)	Yes	Descriptor name
DESCRIPTION	VARCHAR2	(2000)		Description
RT_CATEGORY_ID	NUMBER		Yes	Identifier for the Category the descriptor is associated with.
TYPE	NUMBER		Yes	Indicates the type of data the descriptor is intended to hold. 0-Text, 1-Number, 2-Translatable Text, 3-Date, 4-URL
HIDDEN	NUMBER
SEQUENCE	NUMBER			Indicates the sequence in which this descriptor will be displayed relative to other descriptors of the same category.
KEY	VARCHAR2	(250)	Yes	User-defined identifer for a descriptor.
DEFAULTVALUE	VARCHAR2	(2000)		Reserved for future use.
MULTI_VALUE_TYPE	NUMBER			Reserved for future use.
MULTI_VALUE_KEY	VARCHAR2	(2000)		Reserved for future use.
REQUIRED	NUMBER			Indicates whether the descriptor is required during item creation/update.
REFINABLE	NUMBER			Not used.
SEARCHABLE	NUMBER			Indicates whether users can search for items based on values on this descriptor.
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
REQUEST_ID	NUMBER			Extended Who Column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who Column
PROGRAM_ID	NUMBER			Extended Who Column
PROGRAM_UPDATE_DATE	DATE			Extended Who Column
SEARCH_RESULTS_VISIBLE	VARCHAR2	(1)		Indicates whether the descriptor will be visible in search results pages.
ITEM_DETAIL_VISIBLE	VARCHAR2	(1)		Indicates whether the descriptor will be visible in the Item Detail, Item Compare pages.
VALIDATED	NUMBER			Reserved for future use.
BATCH_JOB_NUM	NUMBER			Batch job number for the job generated to rebuild the Intermedia Index due to changes in descriptor/category definition.
REBUILD_FLAG	VARCHAR2	(1)		Indicates whether a change in the definition of the descriptor requires rebuilding of the Intermedia Index.
CLASS	VARCHAR2	(30)		Class of the descriptor. Possible values are : POM_BASE_ATTR - Base attribute, IPD_BASE_ATTR - Product Development specific base attribute, POM_CAT_ATTR - Category attribute, POM_PRICE_ATTR - Pricing attribute
CUSTOMIZATION_LEVEL	VARCHAR2	(30)		Bitmap indicating the level of customization allowed. By position 1-Can attribute be deleted, 2-can user modify item detail visible property, 3-can user modify search results visible property, 4-can user modify searchable property, 5-can user modify required property, 6-can user modify descriptor name.
MULTIVALUE	VARCHAR2	(1)		Reserved for future use.
SECTION_TAG	NUMBER			Indicates the section assigned to the descriptor during section building for the Intermedia Index.

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
FROM ICX.ICX_POR_DESCRIPTORS_TL;

Dependencies

[top of page]

ICX.ICX_POR_DESCRIPTORS_TL does not reference any database object

ICX.ICX_POR_DESCRIPTORS_TL is referenced by following:

ICX: ICX_POR_DESCRIPTORS_TL#