INV_RESERVATIONS

-- ============================================================
-- Table  : INV_RESERVATIONS — Firm reservations tying a demand source (a sales order line, most commonly) to a supply source (on-hand or expected supply) for an item in an org, optionally pinned down to subinventory, locator, and lot
-- Purpose: Column-selected read of INV_RESERVATIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + RESERVATION_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.RESERVATION_ID AS "Surrogate key of the reservation",
  t.INVENTORY_ITEM_ID AS "Reserved item",
  t.ORGANIZATION_ID AS "Org where the reservation lives",
  t.SUBINVENTORY_CODE AS "Subinventory of reserved stock — NULL for org-level reservations",
  t.LOCATOR_ID AS "Locator of reserved stock, when detailed",
  t.LOT_NUMBER AS "Lot of reserved stock, when detailed",
  t.REVISION AS "Item revision of the reserved stock",
  t.DEMAND_SOURCE_TYPE_ID AS "What kind of demand consumes the reservation",
  t.DEMAND_SOURCE_HEADER_ID AS "Demand document header",
  t.DEMAND_SOURCE_LINE_ID AS "Demand document line",
  t.SUPPLY_SOURCE_TYPE_ID AS "What kind of supply backs the reservation (on-hand, WIP…)",
  t.SUPPLY_SOURCE_HEADER_ID AS "Supply document header",
  t.SUPPLY_SOURCE_LINE_ID AS "Supply document line",
  t.RESERVATION_QUANTITY AS "Reserved quantity in the reservation UOM",
  t.PRIMARY_RESERVATION_QUANTITY AS "Reserved quantity in the item's primary UOM",
  t.RESERVATION_UOM_CODE AS "UOM of the reservation",
  t.REQUIREMENT_DATE AS "When the demand needs the material",
  t.DETAILED_QUANTITY AS "Portion of the reservation already pinned to subinventory/locator/lot"
FROM <catalog>.<schema>.INV_RESERVATIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.RESERVATION_ID = <RESERVATION_ID>
  -- AND t.REQUIREMENT_DATE >= DATE '<DATE_FROM>'
  -- AND t.REQUIREMENT_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.RESERVATION_ID;