Oracle Inventory (INV) key tables – mtl_category_sets_b, mtl_categories_b (3)

Categories: ERP Tables

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

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.
An item may be assigned to only one category within a category set,
however.
STRUCTURE_ID identifies the flexfield structure associated with the
category set. Only categories with the same flexfield structure may be
grouped into a category set.
CONTROL_LEVEL defines whether the category set is controlled at the
item or the item/organization level. When an item is assigned to an
item level category set within the item master organization, the category
set assignment is propagated to all other organizations to which the item
is assigned.
VALIDATE_FLAG defines whether a list of valid categories is used to
validate category usage within the set. Validated category sets will not
allow item assignment to the category set in categories that are not in a
predefined list of valid categories.
Category Sets now support multilingual category set name and
description. MLS is implemented with a pair of tables:
MTL_CATEGORY_SETS_B and MTL_CATEGORY_SETS_TL.

« « Oracle Purchasing (PO) key Vendor tables (5)                        Oracle EPB and OFA architecture comparison » »

Comments are closed.