OE_TRANSACTION_TYPES_TL

-- ============================================================
-- Table  : OE_TRANSACTION_TYPES_TL — Translation companion for order/line transaction types — the display name and description per installed language; the only place the type name exists
-- Purpose: Column-selected read of OE_TRANSACTION_TYPES_TL — auto-generated from field metadata
-- Grain  : One row per TRANSACTION_TYPE_ID
-- 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.TRANSACTION_TYPE_ID AS "The transaction type",
  t.LANGUAGE AS "Language of this row — one row per installed language per type",
  t.SOURCE_LANG AS "The language this row's text was translated from",
  t.NAME AS "The type's display name — exists only on this table, not on the base",
  t.DESCRIPTION AS "Type description in this row's language"
FROM <catalog>.<schema>.OE_TRANSACTION_TYPES_TL t
WHERE
  t.LANGUAGE = '<language>'  -- one language or rows multiply; translations fall back to SOURCE_LANG
  -- AND t.TRANSACTION_TYPE_ID = <TRANSACTION_TYPE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.TRANSACTION_TYPE_ID;