Results for “mtl_abc_classes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_ABC_CLASSES is an Inventory (INV) module table that stores the definition of ABC classes used in Oracle E-Business Suite inventory management. ABC classification is the standard technique for segmenting inventory items according to value and velocity, typically assigning items to A, B, or C categories so that cycle counting frequency and control effort can be concentrated on the items that matter most. Each row in MTL_ABC_CLASSES defines one such class within a specific inventory organization, providing the reference vocabulary that downstream assignment, cycle counting, and planning processes consume.

Based on its foreign key topology, MTL_ABC_CLASSES is best modeled as a hub in a Data Vault context: it is a relatively narrow, stable reference entity keyed by a surrogate identifier, and it is referenced by a wide set of transactional and assignment tables. It behaves as a master/reference object rather than as a link or satellite, since multiple dependent tables carry its surrogate key as a foreign key.

Key Information Stored

The table is documented with 13 columns. The most significant of these are:

• ABC_CLASS_ID — the surrogate primary key (MTL_ABC_CLASSES_PK). This is the value propagated to all dependent tables.
• ABC_CLASS_NAME — the user-visible name of the class (for example, "A", "B", or "C"). Together with ORGANIZATION_ID it forms the second unique index (MTL_ABC_CLASSES_U1 and MTL_ABC_CLASSES_U2), making it a business-key candidate.
• ORGANIZATION_ID — the inventory organization that owns the class; foreign key to MTL_PARAMETERS. This is the other half of the business key.
• DESCRIPTION — free-text description of the class.
• DISABLE_DATE — effective end date for the class definition, supporting time-bounded applicability.
• Audit/Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, documenting row history.
• Concurrent program columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, capturing the batch process that last touched the record.

The table also includes a documented foreign key to MTL_PARAMETERS on ORGANIZATION_ID, confirming that ABC classes are organization-scoped.

Common Use Cases and Queries

The primary uses of MTL_ABC_CLASSES are inventory classification, cycle count planning, and reporting on item segmentation. Typical query patterns include:

• Listing classes for an organization: SELECT abc_class_id, abc_class_name FROM mtl_abc_classes WHERE organization_id = :org_id ORDER BY abc_class_name;
• Joining to assigned items to report current classification: SELECT mac.abc_class_name, mas.inventory_item_id FROM mtl_abc_assignments mas JOIN mtl_abc_classes mac ON mac.abc_class_id = mas.abc_class_id;
• Identifying active (undisabled) classes by testing DISABLE_DATE against the current date.
• Auditing which concurrent program created or last updated a class definition using PROGRAM_ID, REQUEST_ID, and PROGRAM_UPDATE_DATE.

Reporting teams frequently join this table to cycle count classes and items to validate that cycle count frequency matches the ABC designation.

Related Objects

MTL_ABC_CLASSES is referenced by several significant tables through ABC_CLASS_ID, and it references MTL_PARAMETERS. The most important relationships are:

• MTL_PARAMETERS — parent organization; joined on ORGANIZATION_ID.
• MTL_ABC_ASSIGNMENTS — assigns items to classes; joined on ABC_CLASS_ID.
• MTL_ABC_ASSGN_GROUP_CLASSES — associates assignment groups with classes on ABC_CLASS_ID.
• MTL_CYCLE_COUNT_CLASSES — cycle count class definitions on ABC_CLASS_ID.
• MTL_CYCLE_COUNT_ITEMS — cycle count item records on ABC_CLASS_ID.
• MRP_SYSTEM_ITEMS — planning item master referencing ABC_CLASS.
• WMS_SELECTION_CRITERIA_TXN — warehouse selection criteria on ABC_CLASS_ID.
• MSC_PDR_PARAMETERS and MSC_ST_SYSTEM_ITEMS — planning data store references to ABC_CLASS_ID.

Together these objects show that MTL_ABC_CLASSES sits at the center of item classification, cycle counting, and planning data in Oracle EBS Inventory.