MTL_TRANSACTION_TYPES

-- ============================================================
-- Table  : MTL_TRANSACTION_TYPES — The transaction type list — seeded and user-defined types, each mapping to the transaction action and source type that together classify material transactions
-- Purpose: Column-selected read of MTL_TRANSACTION_TYPES — 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 "Transaction type id — what the material ledger carries",
  t.TRANSACTION_TYPE_NAME AS "The type's display name",
  t.TRANSACTION_ACTION_ID AS "The physical action the type performs",  -- decode t.TRANSACTION_ACTION_ID via FND_LOOKUP_VALUES (LANGUAGE-filtered; confirm the LOOKUP_TYPE against your instance) — see quirks guide #lookups
  t.TRANSACTION_SOURCE_TYPE_ID AS "The document source type the type pairs with",
  t.DESCRIPTION AS "Type description",
  t.DISABLE_DATE AS "When the type was disabled — NULL while active",
  t.USER_DEFINED_FLAG AS "Site-defined vs seeded type — user-defined ids differ across environments"
FROM <catalog>.<schema>.MTL_TRANSACTION_TYPES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- 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;