<p>Oracle R12 Inventory - Table name details with description
MTL_ABC_CLASSES contains information about
ABC Classes. Each row in this table defines an ABC
An ABC Class is a category under which items with
similar metrics are put together. The Compile ABC
Analysis form allows the user to specify the
criterion to be used for defining such metrics. A
given ABC Class can be used in more than one ABC
Group, but not more than once in a given group.
MTL_ABC_COMPILES stores information about
each item within an ABC compile. Each
row includes an item's sequence number relative
to other items within the given compile, based on
the compile criteria defined in
MTL_ABC_COMPILE_HEADERS. Each row also
contains an item's compile quantity, compile value,
cumulative quantity, and cumulative value. Oracle
Inventory uses this information to provide an
ordered sequence of items, to which the user can
then assign an ABC Class.
MTL_CATEGORIES_B is the code combinations
table for item categories. Items are grouped into
categories within the context of a category set to
provide flexible grouping schemes.
The item category is a key flexfield with a flex code
of MCAT. The flexfield structure identifier is also
stored in this table to support the ability to define
more than one flexfield structure (multi-flex).
Item categories now support multilingual category
description. MLS is implemented with a pair of
tables: MTL_CATEGORIES_B and
MTL_CATEGORIES_TL. MTL_CATEGORIES_TL table
holds translated Description for Categories.
MTL_CATEGORY_SETS_B contains the entity
definition for category sets. A category set is a
categorization scheme for a group of items. Items
may be assigned to different categories in different
category sets to represent the different groupings
of items used for different purposes.
This table is used to store seria