[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_ITEM_BULKLOAD_RECS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
BUNDLE_COLLECTION_ID
BUNDLE_ID |
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 |
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;
INV.MTL_ITEM_BULKLOAD_RECS does not reference any database object
INV.MTL_ITEM_BULKLOAD_RECS is referenced by following:
|
|
|