Oracle Inventory (INV) key tables – mtl_system_items (1)

MTL_SYSTEM_ITEMS_B is the definition table for items. This table
holds the definitions for inventory items, engineering items, and
purchasing items. You can specify item–related information in fields
such as: Bill of Material, Costing, Purchasing, Receiving, Inventory,
Physical attributes, General Planning, MPS/MRP Planning, Lead times,
Work in Process, Order Management, and Invoicing.

You can set up the item with multiple segments, since it is implemented as a flexfield.
Use the standard ’System Items’ flexfield that is shipped with the
product to configure your item flexfield. The flexfield code is MSTK.
The primary key for an item is the INVENTORY_ITEM_ID and
ORGANIZATION_ID. Therefore, the same item can be defined in
more than one organization. Each item is initially defined in an item
master organization. The user then assigns the item to other
organizations that need to recognize this item; a row is inserted for
each new organization the item is assigned to.

Many columns such as MTL_TRANSACTIONS_ENABLED_FLAG and
BOM_ENABLED_FLAG correspond to item attributes defined in the
MTL_ITEM_ATTRIBUTES table. The attributes that are available to
the user depend on which Oracle applications are installed. The table
MTL_ATTR_APPL_DEPENDENCIES maintains the relationships
between item attributes and Oracle applications.

Two unit of measure columns are stored in MTL_SYSTEM_ITEMS table.
PRIMARY_UOM_CODE is the 3–character unit that is used throughout
Oracle Manufacturing. PRIMARY_UNIT_OF_MEASURE is the
25–character unit that is used throughout Oracle Purchasing.

Items now support multilingual description. MLS is implemented with a pair
Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions
in multiple languages. DESCRIPTION column in the base table
(MTL_SYSTEM_ITEMS_B) is for backward compatibility and is main
tained in the installation base language only.

Leave a Comment