Results for “to_uom_class”

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

Overview

MTL_UOM_CLASS_CONV_VAL_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is registered under the Inventory (INV) product module and is documented in the E-Business Suite Technical Reference Manual (ETRM) as a valid object. The ETRM description explicitly identifies this view as "10SC ONLY," indicating that its scope of use is restricted to the 10SC configuration rather than being a general-purpose Inventory object. This designation typically means the view exists to support a specific localization, regulatory, or customer-specific deployment scenario, and it should not be treated as a standard, universally available interface for UOM class conversion data.

Functionally, the view exposes the relationship between a target unit-of-measure class and the inventory item to which that class conversion applies, filtering out conversions that have already been disabled. Its narrow column list and single-table definition make it a lightweight, purpose-built projection rather than a comprehensive reporting view. Because the view name contains the substring "to_uom_class," users searching for the term "to_uom_class" will encounter this object; the exposed TO_UOM_CLASS column is the element that most directly corresponds to that search term.

Underlying Base Objects

The view is defined over a single documented base object: the MTL_UOM_CLASS_CONVERSIONS table, referenced in the APPS schema through a synonym. The view text is:

• SELECT TO_UOM_CLASS, INVENTORY_ITEM_ID FROM MTL_UOM_CLASS_CONVERSIONS MCC WHERE NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE

No joins, aggregations, or additional tables are involved. The view therefore inherits the row-level data of MTL_UOM_CLASS_CONVERSIONS and applies only a single active-record filter. The predicate NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE treats rows with a null DISABLE_DATE as active indefinitely, while rows with a populated DISABLE_DATE are returned only when that date is still in the future. This is an effective-dating pattern common throughout the Inventory module.

Key Columns

• TO_UOM_CLASS — The unit-of-measure class that serves as the target of a class conversion definition. This column correlates directly with the "to_uom_class" search term and identifies the destination UOM class within a conversion relationship.
• INVENTORY_ITEM_ID — The surrogate key of the inventory item associated with the conversion record. It joins to MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID for item attribute resolution.

Because these are the only two projected columns, the view does not expose the source UOM class, the conversion rate, the disable date, or timestamps from the underlying table. Consumers requiring those attributes must query MTL_UOM_CLASS_CONVERSIONS directly.

Common Use Cases and Queries

Typical usage centers on validating which target UOM classes remain active for a given item. A representative query is:

• SELECT TO_UOM_CLASS, INVENTORY_ITEM_ID FROM APPS.MTL_UOM_CLASS_CONV_VAL_V WHERE INVENTORY_ITEM_ID = :item_id;
• SELECT DISTINCT TO_UOM_CLASS FROM APPS.MTL_UOM_CLASS_CONV_VAL_V ORDER BY TO_UOM_CLASS;

Such queries support validation during item setup, data migration checks, and 10SC-specific integration extracts. Given the "10SC ONLY" restriction, developers should confirm availability in the target instance before relying on the view in custom code, and should prefer direct, filtered queries against MTL_UOM_CLASS_CONVERSIONS where additional columns or broader scope are required.