MTL_TXN_REQUEST_HEADERS

-- ============================================================
-- Table  : MTL_TXN_REQUEST_HEADERS — Move order headers — the user-visible move order number, type, status, and required date for requests to move material within an organization
-- Purpose: Column-selected read of MTL_TXN_REQUEST_HEADERS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + HEADER_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.HEADER_ID AS "Surrogate key of the move order",
  t.REQUEST_NUMBER AS "The move order number users see — unique per org, not globally",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.MOVE_ORDER_TYPE AS "Requisition, replenishment, or pick-wave move order",
  t.HEADER_STATUS AS "Header status — line status drives most processing, filter both",
  t.TRANSACTION_TYPE_ID AS "The transaction type the move order transacts as",
  t.DATE_REQUIRED AS "When the move is required",
  t.DESCRIPTION AS "Move order description"
FROM <catalog>.<schema>.MTL_TXN_REQUEST_HEADERS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.HEADER_ID = <HEADER_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.HEADER_ID;