INV_TRANSFER_ORDER_HEADERS

-- ============================================================
-- Table  : INV_TRANSFER_ORDER_HEADERS — Transfer order headers — the orchestration document for internal material moves within or between organizations, carrying the order number, originating process, and requisitioning business unit
-- Purpose: Column-selected read of INV_TRANSFER_ORDER_HEADERS — auto-generated from field metadata
-- Grain  : One row per HEADER_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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 "Transfer-order surrogate key",
  t.HEADER_NUMBER AS "The transfer order number users see",
  t.DESCRIPTION AS "Order description",
  t.REQ_BU_ID AS "Requisitioning business unit — a named BU id column, not an ORG_ID stripe",
  t.SOURCE_TYPE_LOOKUP AS "Where the order originated (self-service, planning, return, min-max…)",
  t.ORDERED_DATE AS "Order creation date",
  t.FULFILL_ORCHESTRATION_REQUIRED AS "Whether the order was routed through Order Management for fulfillment",
  t.BUDGET_CONTROL_ENABLED_FLAG AS "Under budgetary control or not"
FROM <catalog>.<schema>.INV_TRANSFER_ORDER_HEADERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.HEADER_ID = <HEADER_ID>
  -- AND t.ORDERED_DATE >= DATE '<DATE_FROM>'
  -- AND t.ORDERED_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.HEADER_ID;