OE_TRANSACTION_TYPES_ALL

-- ============================================================
-- Table  : OE_TRANSACTION_TYPES_ALL — Order and line transaction types in one pool — each row defines a document type (distinguished order vs line by the type code) with its workflow binding, defaults, and accounting hooks; the decode for both ORDER_TYPE_ID and LINE_TYPE_ID
-- Purpose: Column-selected read of OE_TRANSACTION_TYPES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + 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 "Surrogate key — both ORDER_TYPE_ID and LINE_TYPE_ID resolve here",
  t.ORG_ID AS "Operating unit the type is defined for",
  t.TRANSACTION_TYPE_CODE AS "ORDER vs LINE — one id pool covers both kinds of type",
  t.ORDER_CATEGORY_CODE AS "Order, return, or mixed category the type produces",
  t.SALES_DOCUMENT_TYPE_CODE AS "Sales order vs sales agreement document family",
  t.WAREHOUSE_ID AS "Default ship-from inventory org for the type",
  t.CUST_TRX_TYPE_ID AS "The receivables transaction type invoicing maps to",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date — NULL while active",
  tl.NAME AS "The type's display name — exists only on this table, not on the base",
  tl.DESCRIPTION AS "Type description in this row's language"
FROM <catalog>.<schema>.OE_TRANSACTION_TYPES_ALL t
LEFT JOIN <catalog>.<schema>.OE_TRANSACTION_TYPES_TL tl
  ON tl.TRANSACTION_TYPE_ID = t.TRANSACTION_TYPE_ID
 AND tl.LANGUAGE = '<language>'  -- one language or rows multiply
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- 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;