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_B

Object Details

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

This table is obsolete since R12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CAT_ITEMS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RT_ITEM_ID
ICX_CAT_ITEMS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERNAL_ITEM_ID ORG_ID
ICX_CAT_ITEMS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER SUPPLIER_PART_NUM SUPPLIER_PART_AUXID ORG_ID
ICX_CAT_ITEMS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATALOG_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RT_ITEM_ID	NUMBER		Yes	System generated Sequence number.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number. Set to 1 initially, incremented every time the row is updated
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
SUPPLIER	VARCHAR2	(700)		Supplier Name of the item
SUPPLIER_PART_NUM	VARCHAR2	(700)		Supplier Part Number of the item
SUPPLIER_PART_AUXID	VARCHAR2	(255)		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.
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
EXTRACTOR_UPDATED_FLAG	VARCHAR2	(1)		Extractor Updated Flag. This flag differentiates whether the item is bulkloaded or extracted. Holds either Y or N.
REQUEST_ID	NUMBER			Concurrent Request Id through which items are extracted/bulkloaded.
CATALOG_NAME	VARCHAR2	(255)		Catalog Name, the Supplier File Name, which was used to load the item.
LAST_UPDATE_LOGIN	NUMBER		Yes	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		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
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
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: Program update date

Query Text

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


SELECT RT_ITEM_ID
,      OBJECT_VERSION_NUMBER
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER
,      SUPPLIER_PART_NUM
,      SUPPLIER_PART_AUXID
,      INTERNAL_ITEM_ID
,      INTERNAL_ITEM_NUM
,      EXTRACTOR_UPDATED_FLAG
,      REQUEST_ID
,      CATALOG_NAME
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM ICX.ICX_CAT_ITEMS_B;

Dependencies

[top of page]

ICX.ICX_CAT_ITEMS_B does not reference any database object

ICX.ICX_CAT_ITEMS_B is referenced by following:

APPS: ICX_CAT_ITEMS_B