Inventory Key   Tables     Table Definitions 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.     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.         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.         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.         MTL_ITEM_CATEGORIES This table stores inventory item assignments to categories within a category set.         MTL_CATEGORIES_B This is the code combinations table for item categories.         MTL_CATEGORIES_B and MTL_CATEGORIES_TL. MTL_CATEGORIES_TL table holds translated Description for Categories.         MTL_CATEGORY_SETS_B  It contains the entity definition for category sets.     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.         MTL_SECONDARY_INVENTORIES This is the definition table for the subinventory.         MTL_ONHAND_QUANTITIES  It stores quantity on hand information by control level and location.         MTL_TRANSACTION_TYPES It contains seeded transaction types and the user defined ones.         MTL_MATERIAL_TRANSACTIONS This table stores a record of every material transaction or cost update performed in Inventory.         MTL_ITEM_ATTRIBUTES  This table stores information on item attributes.         MTL_ITEM_CATALOG_GROUPS_B  This is the code combinations table for item catalog groups.         MTL_ITEM_REVISIONS_B  It stores revision levels for an inventory item.         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.         MTL_SYSTEM_ITEMS_INTERFACE It temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.         MTL_TRANSACTIONS_INTERFACE  It allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory  transaction module.         MTL_ITEM_REVISIONS_INTERFACE It temporarily stores revision levels for an inventory item before loading this information into Oracle Inventory.         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.         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.         MTL_INTERFACE_ERRORS  It stores errors that occur during the item interface process reporting where the errors occurred along with the error messages.         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.Each organization’s item master organization (MASTER_ORGANIZATION_ID) and costing organization (COST_ORGANIZATION_ID) are maintained here.         RCV_TRANSACTIONS It stores historical information about receiving transactions that you have performed. When you enter a receiving transaction and the receiving transaction processor processes your transaction, the transaction is recorded in this table         RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES When a Ship Confirm is processed, one record is inserted in rcv_shipment_headers and one record is inserted in rcv_shipment_lines for each of the Sales Order Lines. The rcv_shipment_lines are linked to the one rcv_shipment_header record by shipment_header_id.             MTL_ITEM_TEMPLATES_B This is the definition table for item templates. It   contains the user-defined name (TEMPLATE_NAME) and description (DESCRIPTION) .You can use a template to set certain item attributes.     ORG_ACCT_PERIODS It holds the open and closed financial periods for organizations.     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.         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.         MTL_ABC_CLASSES MTL_ABC_CLASSES contains information about ABC Classes. Each row in this table defines an ABC Class.         MTL_ABC_COMPILES MTL_ABC_COMPILES stores information about each item within an ABC compile.          MTL_CC_SERIAL_NUMBERS This table is used to store serial numbers associated to a cycle count entry involving a serialized item.          MTL_CC_SUBINVENTORIES MTL_CC_SUBINVENTORIES stores all the subinventories that are to be considered for cycle counting when the scope of the cycle count is at subinventory level.          MTL_CROSS_REFERENCES MTL_CROSS_REFERENCES is used to assign cross-references to items. The cross reference type code identifies the cross-referencing identification system being used.          MTL_CROSS_REFERENCE_TYPES MTL_CROSS_REFERENCE_TYPES is used to define cross-reference types.         MTL_DEFAULT_CATEGORY_SETS MTL_DEFAULT_CATEGORY_SETS stores the identifier of the category set that acts as the default for a particular functional area.         MTL_ITEM_LOC_DEFAULTS MTL_ITEM_LOC_DEFAULTS contains the optional default locators for shipping and receivingpurposes.          MTL_ITEM_SUB_DEFAULTS MTL_ITEM_SUB_DEFAULTS contains the list of optional default shipping and receiving subinventories for items in an organization.          MTL_ITEM_SUB_INVENTORIES MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.         MTL_ITEM_TEMPLATES MTL_ITEM_TEMPLATES is the definition table for item templates. It contains the user-defined name (TEMPLATE_NAME) and description (DESCRIPTION).         MTL_ITEM_TEMPL_ATTRIBUTES MTL_ITEM_TEMPL_ATTRIBUTES stores the attributes and attribute values for item templates.          MTL_LOT_NUMBERS MTL_LOT_NUMBERS stores the definition and expiration date of all lot numbers in inventory.         MTL_MATERIAL_STATUSES_B MTL_MATERIAL_STATUSES_B is the base table for the inventory statuses.          MTL_TXN_REQUEST_HEADERS This table stores all of the move order headers.         MTL_TXN_REQUEST_LINES The table MTL_TXN_REQUEST_LINES stores all of the move order lines.         MTL_RESERVATIONS This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source.          MTL_SALES_ORDERS MTL_SALES_ORDERS stores Inventory's local definition of sales orders.     MTL_SECONDARY_INVENTORIES MTL_SECONDARY_INVENTORIES is the definition table for the subinventory.      MTL_SERIAL_NUMBERS MTL_SERIAL_NUMBERS stores the definition and current status of all serial numbers in Oracle Inventory. These serial numbers are also used in other areas of Oracle Manufacturing.A serial number can have one of four statuses: - Defined but not used - Resides in stores - Issued out of stores - Resides in intransit           MTL_RELATED_ITEMS Table containing items that can be substitute to an item if the original item is out of stock     MTL_GENERIC_DISPOSITIONS Account Alias table     MTL_ABC_ASSIGNMENT_GROUPS ABC     MTL_ABC_ASSGN_GROUP_CLASSES ABC Classification table         MTL_ABC_CLASSES ABC Classes with value of each item based on criteria in ABC Assignment     MTL_UNITS_OF_MEASURE UOM used for Item         MTL_MANUFACTURERS Manufacturers table for an item         MTL_CATEGORIES_KFV Categories Flexfield     MTL_CATEGORY_SETS Category Sets which contains the structure of flexfield     MTL_UOM_CONVERSIONS conversion table based on UOM     MTL_TRANSACTION_ACCOUNTS Accounting Distribution for Material Transactions         MTL_TRANSACTION_SOURCE_TYPES Source of Material Transactions         CST_ITEM_COSTS Standard Cost Tables         CST_ITEM_COST_DETAILS Standard Cost Detail Table     CST_COST_TYPES Types of Costing as used in Material Transaction Costing     ORG_ORGANIZATION_DEFINITIONS Organization Information used in Inventory         MTL_SERIAL_NUMBERS_INTERFACE Stores the serial number of an item for transactions         MTL_TRANSACTION_LOTS_INTERFACE Interface for transaction of item with lot controlled         MTL_CROSS_REFERENCES_INTERFACE Cross References Interface         MTL_ITEM_REVISIONS_INTERFACE Revision of Item in terms of changes from ECO for example     MTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for processing material transactions      MTL_TRANSACTION_REASONS Inventory Transaction Reasons .     MTL_TRANSACTION_LOTS_TEMP Temporary lot numbers holding table     MTL_CATEGORY_SET_VALID_CATS Valid categories for category sets