DBA Data[Home] [Help] [Dependency Information]


TABLE: INV.MTL_ITEM_CATEGORIES

Object Details
Object Name: MTL_ITEM_CATEGORIES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_ITEM_CATEGORIES
Subobject Name:
Status: VALID


MTL_ITEM_CATEGORIES stores inventory item assignments to categories within a category set. For each category assignment, this table stores the item, the category set, and the category. Items always may be assigned to multiple category sets. However, depending on the Multiple Assignments Allowed attribute value in a given category set definition, an item can be assigned to either many or only one category in that category set.
.
This table may be populated through the Master Items and
Organization Items windows. It can also be populated by
performing item assignments when a category set is defined. It is
also populated when an item is transferred from engineering to
manufacturing. The table may also be populated through the Item Category Open Interface.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_ITEM_CATEGORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnCATEGORY_SET_ID
ColumnCATEGORY_ID
MTL_ITEM_CATEGORIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCATEGORY_SET_ID
ColumnCATEGORY_ID
MTL_ITEM_CATEGORIES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWH_UPDATE_DATE
MTL_ITEM_CATEGORIES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_SET_ID
ColumnCATEGORY_ID
ColumnORGANIZATION_ID
MTL_ITEM_CATEGORIES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_SET_ID
ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
CATEGORY_SET_ID NUMBER
Yes Category set identifier
CATEGORY_ID NUMBER
Yes Category identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
WH_UPDATE_DATE DATE

Warehouse update date for tracking changes relevant to data collected in the Data Warehouse
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
FROM INV.MTL_ITEM_CATEGORIES;

Dependencies

[top of page]

INV.MTL_ITEM_CATEGORIES does not reference any database object

INV.MTL_ITEM_CATEGORIES is referenced by following:

SchemaAPPS
SynonymMTL_ITEM_CATEGORIES
TriggerMTL_ITEM_CATEGORIES_TA_IBE
Materialized ViewOE_ITEMS_MV
Materialized ViewOZF_EARNING_SUMMARY_MV