INV_TXN_REQUEST_HEADERS

-- ============================================================
-- Table  : INV_TXN_REQUEST_HEADERS — Movement request (move order) headers — the user-visible request number, type, status, and required date for requests to move material within an organization
-- Purpose: Column-selected read of INV_TXN_REQUEST_HEADERS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + HEADER_ID + REQUEST_NUMBER
-- 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 "Movement-request surrogate key",
  t.REQUEST_NUMBER AS "The user-visible move order number — unique per organization, not globally",
  t.ORGANIZATION_ID AS "Inventory organization of the request",
  t.MOVE_ORDER_TYPE AS "Category of movement request (requisition, pick wave…) — a numeric code",
  t.TRANSACTION_TYPE_ID AS "Default transaction type for the request",
  t.HEADER_STATUS AS "Overall request status — a numeric code; line status is the working truth",
  t.STATUS_DATE AS "When the status last changed",
  t.DATE_REQUIRED AS "When the material is needed",
  t.DESCRIPTION AS "Free-text description of the request",
  t.FROM_SUBINVENTORY_CODE AS "Default source subinventory — lines can override",
  t.FROM_LOCATOR_ID AS "Default source locator",
  t.TO_SUBINVENTORY_CODE AS "Default destination subinventory",
  t.TO_LOCATOR_ID AS "Default destination locator",
  t.TO_ACCOUNT_ID AS "Destination account for account-issue moves",
  t.SHIP_TO_LOCATION_ID AS "Ship-to location reference"
FROM <catalog>.<schema>.INV_TXN_REQUEST_HEADERS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.HEADER_ID = <HEADER_ID>
  -- AND t.REQUEST_NUMBER = '<REQUEST_NUMBER>'
  -- AND t.DATE_REQUIRED >= DATE '<DATE_FROM>'
  -- AND t.DATE_REQUIRED <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.HEADER_ID;