MTL_RESERVATIONS

-- ============================================================
-- Table  : MTL_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 MTL_RESERVATIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + RESERVATION_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.RESERVATION_ID AS "Surrogate key of the reservation",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.INVENTORY_ITEM_ID AS "Item id",
  t.DEMAND_SOURCE_TYPE_ID AS "What kind of demand holds the reservation (sales order, most commonly)",
  t.DEMAND_SOURCE_HEADER_ID AS "The demand document's header id — interpretation depends on the source type",
  t.DEMAND_SOURCE_LINE_ID AS "The demand document's line id",
  t.SUPPLY_SOURCE_TYPE_ID AS "What supplies the reservation — on-hand or an expected supply document",
  t.SUPPLY_SOURCE_HEADER_ID AS "The supplying document's header id, when not against on-hand",
  t.RESERVATION_QUANTITY AS "Reserved quantity in the reservation UOM",
  t.PRIMARY_RESERVATION_QUANTITY AS "Reserved quantity in the item's primary UOM — the column to aggregate",
  t.RESERVATION_UOM_CODE AS "The UOM the reservation was placed in",
  t.SUBINVENTORY_CODE AS "Subinventory the reservation is pinned to, when detailed",
  t.LOCATOR_ID AS "Locator the reservation is pinned to",
  t.LOT_NUMBER AS "Lot the reservation is pinned to",
  t.REQUIREMENT_DATE AS "When the demand needs the material"
FROM <catalog>.<schema>.MTL_RESERVATIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- 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>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.RESERVATION_ID;