Results for “mtl_uom_classes_vl”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_UOM_CLASSES_VL is a translated (language-specific) view owned by the APPS schema in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. It belongs to the Inventory (INV) product family and exposes unit-of-measure (UOM) class definitions together with their language-dependent descriptive text. In the Oracle EBS multilanguage architecture, "_VL" denotes a view that joins a base (non-translated) table to its translation table and filters the result to the session language. MTL_UOM_CLASSES_VL performs this function by selecting from MTL_UOM_CLASSES_TL and restricting rows to those matching the current runtime language.
UOM classes are the highest-level grouping used to organize units of measure — for example, Quantity, Weight, Volume, and Time. Every UOM defined in Oracle Inventory is assigned to exactly one class, and the class governs which UOMs may be converted against one another. MTL_UOM_CLASSES_VL therefore serves as the reporting and integration entry point for UOM class metadata, since it delivers the class code, the translated class name/description, audit columns, descriptive flexfield attributes, and concurrent program context in a single queryable object.
Underlying Base Objects
The documented metadata identifies MTL_UOM_CLASSES_TL (referenced through a synonym) as the base object over which the view is defined. MTL_UOM_CLASSES_TL is the translation table for UOM classes; it stores one row per class per installed language. The "_TL" suffix indicates translated content, where the class identifier is language-independent, but the translatable text (the UOM_CLASS_TL value and DESCRIPTION) varies by LANGUAGE.
The view text supplied in the metadata confirms this relationship directly: the SELECT list enumerates all columns of MTL_UOM_CLASSES_TL and applies the predicate WHERE LANGUAGE = USERENV('LANG'). This filter resolves the session's language at runtime, returning only the single translation appropriate to the connected user's environment. Consequently, MTL_UOM_CLASSES_VL behaves as a language-aware virtual table: downstream reports and forms can query it without embedding language logic, and Oracle's forms/reporting layer automatically returns localized class names.
Key Columns
- ROW_ID — the ROWID of the underlying MTL_UOM_CLASSES_TL row, exposed for tools that require a physical row identifier.
- UOM_CLASS — the language-independent class code / primary key value that uniquely identifies the UOM class.
- UOM_CLASS_TL — the translated (language-specific) name or label for the class, resolved against the session language.
- DESCRIPTION — the translated descriptive text for the UOM class.
- DISABLE_DATE — the date on which the class became or becomes inactive; NULL for enabled classes.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns capturing creation and last-modification metadata.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield (DFF) context and segment columns for customer-defined class attributes.
- REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the request or program that last modified the record.
Common Use Cases and Queries
Typical uses include populating UOM-class list-of-values (LOVs), generating inventory setup reports, and validating integration payloads that reference UOM classes by code. Because the view already localizes text, it is the preferred source over the translation table in multilingual reporting.
Listing all active UOM classes:
SELECT uom_class, uom_class_tl, description
FROM apps.mtl_uom_classes_vl
WHERE disable_date IS NULL
ORDER BY uom_class_tl;
Joining the view to base UOM definitions to produce a class-to-UOM hierarchy:
SELECT c.uom_class, c.uom_class_tl, u.uom_code, u.uom_id
FROM apps.mtl_uom_classes_vl c,
apps.mtl_units_of_measure u
WHERE u.uom_class = c.uom_class
ORDER BY c.uom_class_tl, u.uom_code;
In Release 12.1.1 and 12.2.2 the structure and language-filtering behavior of MTL_UOM_CLASSES_VL are consistent, making it a stable, release-portable object for custom reports, BI Publisher data models, and interface programs that require localized UOM class reference data.
-
View: MTL_UOM_CLASSES_VL 12.2.2
APPS.MTL_UOM_CLASSES_VL·↳ MTL_UOM_CLASSES_TL·Explore INV module →
-
View: MTL_UOM_CLASSES_VL 12.1.1
APPS.MTL_UOM_CLASSES_VL·↳ MTL_UOM_CLASSES_TL·Explore INV module →
-
12.1.1 FND Design Data 12.1.1
-
PACKAGE: APPS.GR_EXPLOSIONS 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
PACKAGE: APPS.GR_EXPLOSIONS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2