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: INV.MTL_ITEM_BULKLOAD_RECS

Object Details

Object Name:	MTL_ITEM_BULKLOAD_RECS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ITEM_BULKLOAD_RECS
Subobject Name:
Status:	VALID

When Items are bulkloaded, we pass request_id as parameter to business event.
API's subscribing to these events will use this value to query against request_id column in mtl_system_items_b.
IP team requested for index on request_id to enable faster access to all the bulkloaded records.
Since mtl_system_items_b table has more than 15 indexes, we are providing the following as alternate solution.
This is outcome of discussions with perf team.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ITEM_BULKLOAD_RECS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BUNDLE_COLLECTION_ID BUNDLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ORGANIZATION_ID	NUMBER			Organization identifier
REVISION_ID	NUMBER			Item Revision Id
CATEGORY_ID	NUMBER			Category Id
CATEGORY_SET_ID	NUMBER			Category Set Id
REQUEST_ID	NUMBER		Yes	Standard Who column
TRANSACTION_TYPE	VARCHAR2	(10)		Specifies the mode in which item open interface is working (e.g.: CREATE, UPDATE)
ENTITY_TYPE	VARCHAR2	(25)		Specifies type of entity i.e. ITEM, ITEM_REVISION ,ITEM_CATEGORY etc
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
BUNDLE_ID	NUMBER			Bundle Identification Id
BUNDLE_COLLECTION_ID	NUMBER			Bundle Collection Id
SOURCE_SYSTEM_ID	NUMBER			Source System Id
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Source System Reference
MESSAGE_TYPE	VARCHAR2	(30)		Message Type: Could be "Error" or "Warning"
MESSAGE_CODE	VARCHAR2	(80)		Error/Warning Message Code

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      REVISION_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      REQUEST_ID
,      TRANSACTION_TYPE
,      ENTITY_TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BUNDLE_ID
,      BUNDLE_COLLECTION_ID
,      SOURCE_SYSTEM_ID
,      SOURCE_SYSTEM_REFERENCE
,      MESSAGE_TYPE
,      MESSAGE_CODE
FROM INV.MTL_ITEM_BULKLOAD_RECS;

Dependencies

[top of page]

INV.MTL_ITEM_BULKLOAD_RECS does not reference any database object

INV.MTL_ITEM_BULKLOAD_RECS is referenced by following:

INV: MTL_ITEM_BULKLOAD_RECS#