Results for “disable_date”

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

Overview

OKX_UNITS_OF_MEASURE_V is a seeded Oracle EBS database view owned by the APPS schema and classified under the OKX – Contracts Integration product. As documented in the ETRM metadata, the view presents "unit of measure definitions" and is implemented as a language-aware projection over the base table MTL_UNITS_OF_MEASURE_TL. Its object status is recorded as VALID across Oracle EBS 12.1.1 and 12.2.2.

The view exists to provide a stable, integration-facing interface to unit of measure (UOM) data for the OKX Contracts Integration module. Because it reads from the translation table MTL_UNITS_OF_MEASURE_TL and filters on the session language, it returns UOM descriptions and names in the language of the querying user, rather than the base-language values stored in MTL_UNITS_OF_MEASURE. This behavior is significant for reporting and integration scenarios where a caller — typically a contracts-related process or external system — must resolve UOM codes into human-readable, localized labels without embedding language logic of its own. The inclusion of UNIT_OF_MEASURE_TL as a projected column is consistent with standard Oracle EBS multi-language view patterns, in which the translation key is surfaced alongside the translated text.

Underlying Base Objects

The documented base object for this view is MTL_UNITS_OF_MEASURE_TL, referenced through a synonym. This is the translation (TL) table that stores language-specific UOM values. The view text is:

• SELECT TL.UNIT_OF_MEASURE, TL.UOM_CODE, TL.UOM_CLASS, TL.DISABLE_DATE, TL.DESCRIPTION, TL.UNIT_OF_MEASURE_TL FROM MTL_UNITS_OF_MEASURE_TL TL WHERE TL.LANGUAGE = USERENV('LANG')

Because the view selects only from the translation table, it does not join back to the base MTL_UNITS_OF_MEASURE table. All returned rows therefore depend entirely on the presence of a translation row in the session language. The USERENV('LANG') predicate enforces session-language filtering, meaning that a UOM with no translation for the current language will not appear in the result set. This mirrors the design of other OKX and EBS translation views and reflects Oracle's multilingual architecture for seed and reference data.

Key Columns

The view exposes six columns, each documented in the ETRM metadata:

• UNIT_OF_MEASURE — the translated unit of measure name, aliased from the translation table's UNIT_OF_MEASURE column. This is the user-facing label for the UOM.
• UOM_CODE — the short, language-independent UOM code. This is the standard join key used throughout EBS inventory, purchasing, and contracts modules.
• UOM_CLASS — the class to which the UOM belongs (for example, quantity, weight, volume, time). It groups related units and is used for validation and conversion logic.
• DISABLE_DATE — the date on which the UOM became or becomes inactive. A NULL value typically indicates the UOM is still enabled.
• DESCRIPTION — the translated descriptive text for the UOM, providing additional detail beyond the name.
• UNIT_OF_MEASURE_TL — the translation-table key column surfaced in the view, used to correlate the returned row with its translation record.

Common Use Cases and Queries

OKX_UNITS_OF_MEASURE_V is typically used to populate UOM lists in contracts integration interfaces, validate incoming UOM codes against active definitions, and produce localized UOM reports. A representative query returning only active, translated UOMs in a given class is:

• SELECT uom_code, unit_of_measure, uom_class, description FROM okx_units_of_measure_v WHERE uom_class = 'QUANTITY' AND disable_date IS NULL ORDER BY unit_of_measure;

To resolve a single code to its localized name for display or mapping purposes:

• SELECT unit_of_measure, description FROM okx_units_of_measure_v WHERE uom_code = 'EACH';

Because the view restricts output to the session language via USERENV('LANG'), callers requiring a specific language should set the session language (for example, through NLS_LANG or a session-level ALTER SESSION statement) before querying. Attempting to retrieve a language other than the session language is not supported by this view; for cross-language comparison, the underlying MTL_UNITS_OF_MEASURE_TL table must be queried directly. As with any APPS-owned view, access is granted through standard EBS responsibility and menu configuration rather than direct object privileges, and the view should be treated as read-only by integration and reporting clients.