MTL_UNITS_OF_MEASURE_TL

-- ============================================================
-- Table  : MTL_UNITS_OF_MEASURE_TL — The unit-of-measure master — both the 3-char UOM code and the 25-char unit name, the UOM class, and the base-unit flag, one row per unit per language
-- Purpose: Column-selected read of MTL_UNITS_OF_MEASURE_TL — auto-generated from field metadata
-- Grain  : One row per UOM_CODE
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.UOM_CODE AS "The 3-char UOM code transaction and balance columns carry — the practical join key",
  t.LANGUAGE AS "Language of this row — the whole table is language-striped, structural columns included",
  t.UNIT_OF_MEASURE AS "The 25-char unit name — also unique per language; purchasing documents historically carry this form",
  t.SOURCE_LANG AS "The language this row was translated from",
  t.UOM_CLASS AS "The UOM class (weight, volume, quantity…) conversions stay within",
  t.BASE_UOM_FLAG AS "Whether this unit is its class's base unit — conversion rates are expressed against it",
  t.DESCRIPTION AS "Unit description in this row's language",
  t.DISABLE_DATE AS "When the unit was disabled — NULL while active"
FROM <catalog>.<schema>.MTL_UNITS_OF_MEASURE_TL t
WHERE
  t.LANGUAGE = '<language>'  -- one language or rows multiply; translations fall back to SOURCE_LANG
  -- AND t.UOM_CODE = '<UOM_CODE>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.UOM_CODE;