MTL_SYSTEMS_B
is the base table and MTL_SYSTEM_ITEMS is a synonym for MTL_SYSTEM_ITEMS_B.Because
of this synonym, old code written that used mtl_system_items still compiles
without any problem. That is the sole purpose of the synonym.
What is MTL_SYSTEM_ITEMS_B table?
What is MTL_SYSTEM_ITEMS_B table?
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 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.
Two unit of measure columns are stored in MTL_SYSTEM_ITEMS_B table.
PRIMARY_UOM_CODE is the 3-character unit that is used throughout Oracle
Manufacturing. PRIMARY_UNIT_OF_MEASURE is the 25-character Unit of Measure that
is used throughout Oracle Purchasing. Unlike the PRIMARY_UOM_CODE, the Unit of
Measure is language-dependent attribute, however, PRIMARY_UNIT_OF_MEASURE
column stores value in the installation base language only.
No comments:
Post a Comment