Oracle R12 Inventory Tables

Sr. No	Table Name	Description/ Uses
1	MTL_PARAMETERS	It maintains a set of default options like general ledger accounts; locator, lot, and serial controls, inter-organization options, costing method, etc. for each organization defined in Oracle Inventory.
2	MTL_SYSTEM_ITEMS_B	This table holds the definitions for inventory items, engineering items, and purchasing items. The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID.
3	MTL_ITEM_STATUS	This is the definition table for material status codes. Status code is a required item attribute. It indicates the status of an item, i.e., Active, Pending, Obsolete.
4	MTL_UNITS_OF_MEASURE_TL	This is the definition table for both the 25-character and the 3-character units of measure. The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class. Oracle Inventory uses this table to keep track of the units of measure used to transact an item.
5	MTL_ITEM_LOCATIONS	This is the definition table for stock locators. The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc.
6	MTL_ITEM_CATEGORIES	This table stores inventory item assignments to categories within a category set
7	MTL_CATEGORIES_B	This is the code combinations table for item categories.
8	MTL_CATEGORY_SETS_B	It contains the entity definition for category sets.
9	MTL_DEMAND	This table stores demand and reservation information used in Available To Promise, Planning and other Manufacturing functions. There are three major row types stored in the table: Summary Demand rows,Open Demand Rows, and Reservation Rows.
10	MTL_SECONDARY_INVENTORIES	This is the definition table for the subinventory.
11	MTL_ONHAND_QUANTITIES	It stores quantity on hand information by control level and location.
12	MTL_TRANSACTION_TYPES	It contains seeded transaction types and the user defined ones.
13	MTL_MATERIAL_TRANSACTIONS	This table stores a record of every material transaction or cost update performed in Inventory.
14	MTL_ITEM_ATTRIBUTES	This table stores information on item attributes.
15	MTL_ITEM_CATALOG_GROUPS_B	This is the code combinations table for item catalog groups.
16	MTL_ITEM_REVISIONS_B	It stores revision levels for an inventory item.
17	MTL_ITEM_TEMPLATES_B	This is the definition table for item templates. It
18	MTL_DESCRIPTIVE_ELEMENTS	It stores the descriptive element definitions for an item catalog group. Descriptive elements are defining properties used to describe in the catalog group.
19	MTL_DESCR_ELEMENT_VALUES	It stores the descriptive element values for a specific item. When an item is associated with a particular item catalog group, one row per descriptive element (for that catalog group) is inserted into this table.
20	ORG_ACCT_PERIODS	It holds the open and closed financial periods for organizations.
21	MTL_CUSTOMER_ITEMS	It stores customer item information for a specific customer. Each record can be defined at one of the following levels: Customer, Address Category, and Address. The customer item definition is organization independent.
22	MTL_SYSTEM_ITEMS_INTERFACE	It temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.
23	MTL_TRANSACTIONS_INTERFACE	It allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory  transaction module.
24	MTL_ITEM_REVISIONS_INTERFACE	It temporarily stores revision levels for an inventory item before loading this information into Oracle Inventory.
25	MTL_ITEM_CATEGORIES_INTERFACE	This table temporarily stores data about inventory item assignments to category sets and categories before loading this information into Oracle Inventory.
26	MTL_DESC_ELEM_VAL_INTERFACE	This table temporarily stores descriptive element values for an item that is associated with an item catalog group before loading this information into Oracle Inventory.
27	MTL_DEMAND_INTERFACE	It is the interface point between non-Inventory applications and the Inventory demand module. Records inserted into this table are processed by the Demand Manager concurrent program.
28	MTL_INTERFACE_ERRORS	It stores errors that occur during the item interface process reporting where the errors occurred along with the error messages.