MTL_UOM_CONVERSIONS

-- ============================================================
-- Table  : MTL_UOM_CONVERSIONS — Intra-class UOM conversion rates to each class's base unit — both standard conversions and item-specific overrides, distinguished by the item id
-- Purpose: Column-selected read of MTL_UOM_CONVERSIONS — auto-generated from field metadata
-- Grain  : One row per INVENTORY_ITEM_ID + 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.INVENTORY_ITEM_ID AS "Item id — 0 marks the standard (item-independent) conversion; an item-specific row wins over it",
  t.UOM_CODE AS "The unit being converted to its class base unit",
  t.UNIT_OF_MEASURE AS "The unit's 25-char name form",
  t.UOM_CLASS AS "The class the conversion stays within — cross-class conversions live elsewhere",
  t.CONVERSION_RATE AS "Multiplier from this unit to the class base unit",
  t.DISABLE_DATE AS "When the conversion was disabled — NULL while active"
FROM <catalog>.<schema>.MTL_UOM_CONVERSIONS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.INVENTORY_ITEM_ID = <INVENTORY_ITEM_ID>
  -- 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.INVENTORY_ITEM_ID;