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_ITEMS_TLP

Object Details

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

This table is obsolete since R12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: ICX_POR_ITEMS_TLP_PK1

RT_ITEM_ID
LANGUAGE

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_ITEMS_TLP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RT_ITEM_ID LANGUAGE
ICX_CAT_ITEMS_TLP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_CATEGORY_ID RT_ITEM_ID
ICX_CAT_ITEMS_TLP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER SUPPLIER_PART_NUM ORG_ID
ICX_CAT_ITEMS_TLP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RT_ITEM_ID	NUMBER		Yes	Internally generated Item Id. (References ICX_CAT_ITEMS_B.rt_item_id)
LANGUAGE	VARCHAR2	(4)	Yes	Language. Can be any of the installed languages.
ORG_ID	NUMBER			Operating Unit Id, to which the item belongs. A value of '-2' indicates that the item will be available for All Operating Units.
SUPPLIER_ID	NUMBER			Supplier Id of the item. If no value is available we store -2 by default.
ITEM_SOURCE_TYPE	VARCHAR2	(8)		Whether item is internally sourced or supplier source or both. Thus probable values are 'INTERNAL', 'SUPPLIER' and 'BOTH'.
SEARCH_TYPE	VARCHAR2	(8)		Stores "SUPPLIER" or "INTERNAL".
PRIMARY_CATEGORY_ID	NUMBER			ID of primary category that is displayed in search results. (References ICX_CAT_CATEGORIES_TL.rt_category_id)
PRIMARY_CATEGORY_NAME	VARCHAR2	(250)		Primary Category Name. (References ICX_CAT_CATEGORIES_TL.category_name)
INTERNAL_ITEM_ID	NUMBER			Item unique identifier. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.)Populated only for Extracted Items.
INTERNAL_ITEM_NUM	VARCHAR2	(700)		Internal Item Number, specified for Extracted Items
SUPPLIER	VARCHAR2	(700)		Seeded base attribute: Supplier Name
SUPPLIER_PART_NUM	VARCHAR2	(700)		Seeded base attribute: Supplier Part Number
SUPPLIER_PART_AUXID	VARCHAR2	(255)		Seeded base attribute: Supplier Part Auxiliary ID of the item. Used for CIF/cXML file uploads. Stores '##NULL' in case this field is not provided in the loader file.
MANUFACTURER	VARCHAR2	(700)		Seeded base attribute: Manufacturer Name
MANUFACTURER_PART_NUM	VARCHAR2	(700)		Seeded base attribute: Manufacturer Part Number
SUPPLIER_URL	VARCHAR2	(700)		Seeded base attribute: Supplier URL
MANUFACTURER_URL	VARCHAR2	(700)		Seeded base attribute: Manufacturer URL
DESCRIPTION	VARCHAR2	(2000)		Seeded base attribute: Description of the Item
COMMENTS	VARCHAR2	(700)		Seeded base attribute: Comments
ALIAS	VARCHAR2	(700)		Seeded base attribute: Alias
PICTURE	VARCHAR2	(700)		Seeded base attribute: Image file name
PICTURE_URL	VARCHAR2	(700)		Seeded base attribute: Image URL
THUMBNAIL_IMAGE	VARCHAR2	(700)		Seeded base attribute: Thumbnail Image
ATTACHMENT_URL	VARCHAR2	(700)		Seeded base attribute: Attachment URL
LONG_DESCRIPTION	VARCHAR2	(2000)		Seeded base attribute: Long Description
UNSPSC_CODE	VARCHAR2	(700)		Seeded base attribute: UNSPSC Code
AVAILABILITY	VARCHAR2	(700)		Seeded base attribute: Availability of the item
LEAD_TIME	NUMBER			Seeded base attribute: Lead Time
ITEM_TYPE	VARCHAR2	(700)		Seeded base attribute: Item Type
TEXT_BASE_ATTRIBUTE1	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE2	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE3	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE4	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE5	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE6	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE7	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE8	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE9	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE10	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE11	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE12	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE13	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE14	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE15	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE16	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE17	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE18	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE19	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE20	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE21	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE22	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE23	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE24	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE25	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE26	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE27	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE28	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE29	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE30	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE31	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE32	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE33	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE34	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE35	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE36	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE37	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE38	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE39	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE40	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE41	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE42	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE43	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE44	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE45	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE46	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE47	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE48	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE49	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE50	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE51	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE52	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE53	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE54	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE55	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE56	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE57	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE58	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE59	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE60	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE61	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE62	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE63	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE64	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE65	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE66	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE67	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE68	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE69	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE70	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE71	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE72	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE73	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE74	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE75	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE76	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE77	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE78	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE79	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE80	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE81	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE82	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE83	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE84	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE85	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE86	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE87	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE88	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE89	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE90	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE91	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE92	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE93	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE94	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE95	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE96	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE97	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE98	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE99	VARCHAR2	(700)		Text base attribute value of the item
TEXT_BASE_ATTRIBUTE100	VARCHAR2	(700)		Text base attribute value of the item
NUM_BASE_ATTRIBUTE1	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE2	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE3	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE4	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE5	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE6	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE7	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE8	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE9	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE10	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE11	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE12	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE13	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE14	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE15	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE16	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE17	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE18	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE19	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE20	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE21	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE22	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE23	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE24	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE25	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE26	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE27	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE28	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE29	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE30	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE31	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE32	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE33	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE34	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE35	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE36	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE37	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE38	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE39	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE40	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE41	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE42	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE43	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE44	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE45	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE46	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE47	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE48	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE49	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE50	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE51	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE52	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE53	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE54	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE55	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE56	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE57	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE58	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE59	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE60	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE61	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE62	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE63	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE64	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE65	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE66	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE67	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE68	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE69	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE70	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE71	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE72	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE73	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE74	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE75	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE76	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE77	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE78	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE79	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE80	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE81	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE82	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE83	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE84	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE85	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE86	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE87	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE88	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE89	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE90	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE91	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE92	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE93	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE94	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE95	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE96	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE97	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE98	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE99	NUMBER			Numeric base attribute value of the item
NUM_BASE_ATTRIBUTE100	NUMBER			Numeric base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE1	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE2	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE3	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE4	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE5	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE6	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE7	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE8	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE9	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE10	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE11	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE12	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE13	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE14	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE15	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE16	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE17	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE18	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE19	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE20	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE21	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE22	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE23	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE24	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE25	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE26	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE27	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE28	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE29	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE30	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE31	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE32	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE33	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE34	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE35	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE36	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE37	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE38	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE39	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE40	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE41	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE42	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE43	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE44	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE45	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE46	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE47	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE48	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE49	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE50	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE51	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE52	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE53	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE54	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE55	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE56	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE57	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE58	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE59	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE60	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE61	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE62	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE63	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE64	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE65	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE66	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE67	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE68	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE69	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE70	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE71	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE72	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE73	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE74	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE75	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE76	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE77	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE78	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE79	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE80	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE81	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE82	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE83	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE84	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE85	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE86	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE87	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE88	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE89	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE90	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE91	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE92	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE93	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE94	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE95	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE96	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE97	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE98	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE99	VARCHAR2	(700)		Translatable text base attribute value of the item
TL_TEXT_BASE_ATTRIBUTE100	VARCHAR2	(700)		Translatable text base attribute value of the item
CTX_DESC	VARCHAR2	(1)		Oracle Text Indexed column, defined using multi-lexer
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.)
LAST_UPDATED_BY	NUMBER			Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE	DATE			Standard Who column: date when this record was last updated
CREATED_BY	NUMBER			Standard Who column: the user who created this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE			Standard Who column: date when this record was created
REQUEST_ID	NUMBER			Concurrent Request Id through which items are extracted/bulkloaded.
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

Query Text

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


SELECT RT_ITEM_ID
,      LANGUAGE
,      ORG_ID
,      SUPPLIER_ID
,      ITEM_SOURCE_TYPE
,      SEARCH_TYPE
,      PRIMARY_CATEGORY_ID
,      PRIMARY_CATEGORY_NAME
,      INTERNAL_ITEM_ID
,      INTERNAL_ITEM_NUM
,      SUPPLIER
,      SUPPLIER_PART_NUM
,      SUPPLIER_PART_AUXID
,      MANUFACTURER
,      MANUFACTURER_PART_NUM
,      SUPPLIER_URL
,      MANUFACTURER_URL
,      DESCRIPTION
,      COMMENTS
,      ALIAS
,      PICTURE
,      PICTURE_URL
,      THUMBNAIL_IMAGE
,      ATTACHMENT_URL
,      LONG_DESCRIPTION
,      UNSPSC_CODE
,      AVAILABILITY
,      LEAD_TIME
,      ITEM_TYPE
,      TEXT_BASE_ATTRIBUTE1
,      TEXT_BASE_ATTRIBUTE2
,      TEXT_BASE_ATTRIBUTE3
,      TEXT_BASE_ATTRIBUTE4
,      TEXT_BASE_ATTRIBUTE5
,      TEXT_BASE_ATTRIBUTE6
,      TEXT_BASE_ATTRIBUTE7
,      TEXT_BASE_ATTRIBUTE8
,      TEXT_BASE_ATTRIBUTE9
,      TEXT_BASE_ATTRIBUTE10
,      TEXT_BASE_ATTRIBUTE11
,      TEXT_BASE_ATTRIBUTE12
,      TEXT_BASE_ATTRIBUTE13
,      TEXT_BASE_ATTRIBUTE14
,      TEXT_BASE_ATTRIBUTE15
,      TEXT_BASE_ATTRIBUTE16
,      TEXT_BASE_ATTRIBUTE17
,      TEXT_BASE_ATTRIBUTE18
,      TEXT_BASE_ATTRIBUTE19
,      TEXT_BASE_ATTRIBUTE20
,      TEXT_BASE_ATTRIBUTE21
,      TEXT_BASE_ATTRIBUTE22
,      TEXT_BASE_ATTRIBUTE23
,      TEXT_BASE_ATTRIBUTE24
,      TEXT_BASE_ATTRIBUTE25
,      TEXT_BASE_ATTRIBUTE26
,      TEXT_BASE_ATTRIBUTE27
,      TEXT_BASE_ATTRIBUTE28
,      TEXT_BASE_ATTRIBUTE29
,      TEXT_BASE_ATTRIBUTE30
,      TEXT_BASE_ATTRIBUTE31
,      TEXT_BASE_ATTRIBUTE32
,      TEXT_BASE_ATTRIBUTE33
,      TEXT_BASE_ATTRIBUTE34
,      TEXT_BASE_ATTRIBUTE35
,      TEXT_BASE_ATTRIBUTE36
,      TEXT_BASE_ATTRIBUTE37
,      TEXT_BASE_ATTRIBUTE38
,      TEXT_BASE_ATTRIBUTE39
,      TEXT_BASE_ATTRIBUTE40
,      TEXT_BASE_ATTRIBUTE41
,      TEXT_BASE_ATTRIBUTE42
,      TEXT_BASE_ATTRIBUTE43
,      TEXT_BASE_ATTRIBUTE44
,      TEXT_BASE_ATTRIBUTE45
,      TEXT_BASE_ATTRIBUTE46
,      TEXT_BASE_ATTRIBUTE47
,      TEXT_BASE_ATTRIBUTE48
,      TEXT_BASE_ATTRIBUTE49
,      TEXT_BASE_ATTRIBUTE50
,      TEXT_BASE_ATTRIBUTE51
,      TEXT_BASE_ATTRIBUTE52
,      TEXT_BASE_ATTRIBUTE53
,      TEXT_BASE_ATTRIBUTE54
,      TEXT_BASE_ATTRIBUTE55
,      TEXT_BASE_ATTRIBUTE56
,      TEXT_BASE_ATTRIBUTE57
,      TEXT_BASE_ATTRIBUTE58
,      TEXT_BASE_ATTRIBUTE59
,      TEXT_BASE_ATTRIBUTE60
,      TEXT_BASE_ATTRIBUTE61
,      TEXT_BASE_ATTRIBUTE62
,      TEXT_BASE_ATTRIBUTE63
,      TEXT_BASE_ATTRIBUTE64
,      TEXT_BASE_ATTRIBUTE65
,      TEXT_BASE_ATTRIBUTE66
,      TEXT_BASE_ATTRIBUTE67
,      TEXT_BASE_ATTRIBUTE68
,      TEXT_BASE_ATTRIBUTE69
,      TEXT_BASE_ATTRIBUTE70
,      TEXT_BASE_ATTRIBUTE71
,      TEXT_BASE_ATTRIBUTE72
,      TEXT_BASE_ATTRIBUTE73
,      TEXT_BASE_ATTRIBUTE74
,      TEXT_BASE_ATTRIBUTE75
,      TEXT_BASE_ATTRIBUTE76
,      TEXT_BASE_ATTRIBUTE77
,      TEXT_BASE_ATTRIBUTE78
,      TEXT_BASE_ATTRIBUTE79
,      TEXT_BASE_ATTRIBUTE80
,      TEXT_BASE_ATTRIBUTE81
,      TEXT_BASE_ATTRIBUTE82
,      TEXT_BASE_ATTRIBUTE83
,      TEXT_BASE_ATTRIBUTE84
,      TEXT_BASE_ATTRIBUTE85
,      TEXT_BASE_ATTRIBUTE86
,      TEXT_BASE_ATTRIBUTE87
,      TEXT_BASE_ATTRIBUTE88
,      TEXT_BASE_ATTRIBUTE89
,      TEXT_BASE_ATTRIBUTE90
,      TEXT_BASE_ATTRIBUTE91
,      TEXT_BASE_ATTRIBUTE92
,      TEXT_BASE_ATTRIBUTE93
,      TEXT_BASE_ATTRIBUTE94
,      TEXT_BASE_ATTRIBUTE95
,      TEXT_BASE_ATTRIBUTE96
,      TEXT_BASE_ATTRIBUTE97
,      TEXT_BASE_ATTRIBUTE98
,      TEXT_BASE_ATTRIBUTE99
,      TEXT_BASE_ATTRIBUTE100
,      NUM_BASE_ATTRIBUTE1
,      NUM_BASE_ATTRIBUTE2
,      NUM_BASE_ATTRIBUTE3
,      NUM_BASE_ATTRIBUTE4
,      NUM_BASE_ATTRIBUTE5
,      NUM_BASE_ATTRIBUTE6
,      NUM_BASE_ATTRIBUTE7
,      NUM_BASE_ATTRIBUTE8
,      NUM_BASE_ATTRIBUTE9
,      NUM_BASE_ATTRIBUTE10
,      NUM_BASE_ATTRIBUTE11
,      NUM_BASE_ATTRIBUTE12
,      NUM_BASE_ATTRIBUTE13
,      NUM_BASE_ATTRIBUTE14
,      NUM_BASE_ATTRIBUTE15
,      NUM_BASE_ATTRIBUTE16
,      NUM_BASE_ATTRIBUTE17
,      NUM_BASE_ATTRIBUTE18
,      NUM_BASE_ATTRIBUTE19
,      NUM_BASE_ATTRIBUTE20
,      NUM_BASE_ATTRIBUTE21
,      NUM_BASE_ATTRIBUTE22
,      NUM_BASE_ATTRIBUTE23
,      NUM_BASE_ATTRIBUTE24
,      NUM_BASE_ATTRIBUTE25
,      NUM_BASE_ATTRIBUTE26
,      NUM_BASE_ATTRIBUTE27
,      NUM_BASE_ATTRIBUTE28
,      NUM_BASE_ATTRIBUTE29
,      NUM_BASE_ATTRIBUTE30
,      NUM_BASE_ATTRIBUTE31
,      NUM_BASE_ATTRIBUTE32
,      NUM_BASE_ATTRIBUTE33
,      NUM_BASE_ATTRIBUTE34
,      NUM_BASE_ATTRIBUTE35
,      NUM_BASE_ATTRIBUTE36
,      NUM_BASE_ATTRIBUTE37
,      NUM_BASE_ATTRIBUTE38
,      NUM_BASE_ATTRIBUTE39
,      NUM_BASE_ATTRIBUTE40
,      NUM_BASE_ATTRIBUTE41
,      NUM_BASE_ATTRIBUTE42
,      NUM_BASE_ATTRIBUTE43
,      NUM_BASE_ATTRIBUTE44
,      NUM_BASE_ATTRIBUTE45
,      NUM_BASE_ATTRIBUTE46
,      NUM_BASE_ATTRIBUTE47
,      NUM_BASE_ATTRIBUTE48
,      NUM_BASE_ATTRIBUTE49
,      NUM_BASE_ATTRIBUTE50
,      NUM_BASE_ATTRIBUTE51
,      NUM_BASE_ATTRIBUTE52
,      NUM_BASE_ATTRIBUTE53
,      NUM_BASE_ATTRIBUTE54
,      NUM_BASE_ATTRIBUTE55
,      NUM_BASE_ATTRIBUTE56
,      NUM_BASE_ATTRIBUTE57
,      NUM_BASE_ATTRIBUTE58
,      NUM_BASE_ATTRIBUTE59
,      NUM_BASE_ATTRIBUTE60
,      NUM_BASE_ATTRIBUTE61
,      NUM_BASE_ATTRIBUTE62
,      NUM_BASE_ATTRIBUTE63
,      NUM_BASE_ATTRIBUTE64
,      NUM_BASE_ATTRIBUTE65
,      NUM_BASE_ATTRIBUTE66
,      NUM_BASE_ATTRIBUTE67
,      NUM_BASE_ATTRIBUTE68
,      NUM_BASE_ATTRIBUTE69
,      NUM_BASE_ATTRIBUTE70
,      NUM_BASE_ATTRIBUTE71
,      NUM_BASE_ATTRIBUTE72
,      NUM_BASE_ATTRIBUTE73
,      NUM_BASE_ATTRIBUTE74
,      NUM_BASE_ATTRIBUTE75
,      NUM_BASE_ATTRIBUTE76
,      NUM_BASE_ATTRIBUTE77
,      NUM_BASE_ATTRIBUTE78
,      NUM_BASE_ATTRIBUTE79
,      NUM_BASE_ATTRIBUTE80
,      NUM_BASE_ATTRIBUTE81
,      NUM_BASE_ATTRIBUTE82
,      NUM_BASE_ATTRIBUTE83
,      NUM_BASE_ATTRIBUTE84
,      NUM_BASE_ATTRIBUTE85
,      NUM_BASE_ATTRIBUTE86
,      NUM_BASE_ATTRIBUTE87
,      NUM_BASE_ATTRIBUTE88
,      NUM_BASE_ATTRIBUTE89
,      NUM_BASE_ATTRIBUTE90
,      NUM_BASE_ATTRIBUTE91
,      NUM_BASE_ATTRIBUTE92
,      NUM_BASE_ATTRIBUTE93
,      NUM_BASE_ATTRIBUTE94
,      NUM_BASE_ATTRIBUTE95
,      NUM_BASE_ATTRIBUTE96
,      NUM_BASE_ATTRIBUTE97
,      NUM_BASE_ATTRIBUTE98
,      NUM_BASE_ATTRIBUTE99
,      NUM_BASE_ATTRIBUTE100
,      TL_TEXT_BASE_ATTRIBUTE1
,      TL_TEXT_BASE_ATTRIBUTE2
,      TL_TEXT_BASE_ATTRIBUTE3
,      TL_TEXT_BASE_ATTRIBUTE4
,      TL_TEXT_BASE_ATTRIBUTE5
,      TL_TEXT_BASE_ATTRIBUTE6
,      TL_TEXT_BASE_ATTRIBUTE7
,      TL_TEXT_BASE_ATTRIBUTE8
,      TL_TEXT_BASE_ATTRIBUTE9
,      TL_TEXT_BASE_ATTRIBUTE10
,      TL_TEXT_BASE_ATTRIBUTE11
,      TL_TEXT_BASE_ATTRIBUTE12
,      TL_TEXT_BASE_ATTRIBUTE13
,      TL_TEXT_BASE_ATTRIBUTE14
,      TL_TEXT_BASE_ATTRIBUTE15
,      TL_TEXT_BASE_ATTRIBUTE16
,      TL_TEXT_BASE_ATTRIBUTE17
,      TL_TEXT_BASE_ATTRIBUTE18
,      TL_TEXT_BASE_ATTRIBUTE19
,      TL_TEXT_BASE_ATTRIBUTE20
,      TL_TEXT_BASE_ATTRIBUTE21
,      TL_TEXT_BASE_ATTRIBUTE22
,      TL_TEXT_BASE_ATTRIBUTE23
,      TL_TEXT_BASE_ATTRIBUTE24
,      TL_TEXT_BASE_ATTRIBUTE25
,      TL_TEXT_BASE_ATTRIBUTE26
,      TL_TEXT_BASE_ATTRIBUTE27
,      TL_TEXT_BASE_ATTRIBUTE28
,      TL_TEXT_BASE_ATTRIBUTE29
,      TL_TEXT_BASE_ATTRIBUTE30
,      TL_TEXT_BASE_ATTRIBUTE31
,      TL_TEXT_BASE_ATTRIBUTE32
,      TL_TEXT_BASE_ATTRIBUTE33
,      TL_TEXT_BASE_ATTRIBUTE34
,      TL_TEXT_BASE_ATTRIBUTE35
,      TL_TEXT_BASE_ATTRIBUTE36
,      TL_TEXT_BASE_ATTRIBUTE37
,      TL_TEXT_BASE_ATTRIBUTE38
,      TL_TEXT_BASE_ATTRIBUTE39
,      TL_TEXT_BASE_ATTRIBUTE40
,      TL_TEXT_BASE_ATTRIBUTE41
,      TL_TEXT_BASE_ATTRIBUTE42
,      TL_TEXT_BASE_ATTRIBUTE43
,      TL_TEXT_BASE_ATTRIBUTE44
,      TL_TEXT_BASE_ATTRIBUTE45
,      TL_TEXT_BASE_ATTRIBUTE46
,      TL_TEXT_BASE_ATTRIBUTE47
,      TL_TEXT_BASE_ATTRIBUTE48
,      TL_TEXT_BASE_ATTRIBUTE49
,      TL_TEXT_BASE_ATTRIBUTE50
,      TL_TEXT_BASE_ATTRIBUTE51
,      TL_TEXT_BASE_ATTRIBUTE52
,      TL_TEXT_BASE_ATTRIBUTE53
,      TL_TEXT_BASE_ATTRIBUTE54
,      TL_TEXT_BASE_ATTRIBUTE55
,      TL_TEXT_BASE_ATTRIBUTE56
,      TL_TEXT_BASE_ATTRIBUTE57
,      TL_TEXT_BASE_ATTRIBUTE58
,      TL_TEXT_BASE_ATTRIBUTE59
,      TL_TEXT_BASE_ATTRIBUTE60
,      TL_TEXT_BASE_ATTRIBUTE61
,      TL_TEXT_BASE_ATTRIBUTE62
,      TL_TEXT_BASE_ATTRIBUTE63
,      TL_TEXT_BASE_ATTRIBUTE64
,      TL_TEXT_BASE_ATTRIBUTE65
,      TL_TEXT_BASE_ATTRIBUTE66
,      TL_TEXT_BASE_ATTRIBUTE67
,      TL_TEXT_BASE_ATTRIBUTE68
,      TL_TEXT_BASE_ATTRIBUTE69
,      TL_TEXT_BASE_ATTRIBUTE70
,      TL_TEXT_BASE_ATTRIBUTE71
,      TL_TEXT_BASE_ATTRIBUTE72
,      TL_TEXT_BASE_ATTRIBUTE73
,      TL_TEXT_BASE_ATTRIBUTE74
,      TL_TEXT_BASE_ATTRIBUTE75
,      TL_TEXT_BASE_ATTRIBUTE76
,      TL_TEXT_BASE_ATTRIBUTE77
,      TL_TEXT_BASE_ATTRIBUTE78
,      TL_TEXT_BASE_ATTRIBUTE79
,      TL_TEXT_BASE_ATTRIBUTE80
,      TL_TEXT_BASE_ATTRIBUTE81
,      TL_TEXT_BASE_ATTRIBUTE82
,      TL_TEXT_BASE_ATTRIBUTE83
,      TL_TEXT_BASE_ATTRIBUTE84
,      TL_TEXT_BASE_ATTRIBUTE85
,      TL_TEXT_BASE_ATTRIBUTE86
,      TL_TEXT_BASE_ATTRIBUTE87
,      TL_TEXT_BASE_ATTRIBUTE88
,      TL_TEXT_BASE_ATTRIBUTE89
,      TL_TEXT_BASE_ATTRIBUTE90
,      TL_TEXT_BASE_ATTRIBUTE91
,      TL_TEXT_BASE_ATTRIBUTE92
,      TL_TEXT_BASE_ATTRIBUTE93
,      TL_TEXT_BASE_ATTRIBUTE94
,      TL_TEXT_BASE_ATTRIBUTE95
,      TL_TEXT_BASE_ATTRIBUTE96
,      TL_TEXT_BASE_ATTRIBUTE97
,      TL_TEXT_BASE_ATTRIBUTE98
,      TL_TEXT_BASE_ATTRIBUTE99
,      TL_TEXT_BASE_ATTRIBUTE100
,      CTX_DESC
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM ICX.ICX_CAT_ITEMS_TLP;

Dependencies

[top of page]

ICX.ICX_CAT_ITEMS_TLP does not reference any database object

ICX.ICX_CAT_ITEMS_TLP is referenced by following:

APPS: ICX_CAT_ITEMS_TLP