MTL_SUPPLY

-- ============================================================
-- Table  : MTL_SUPPLY — The incoming-supply picture — one row per open requisition, purchase order, or in-transit shipment element expected into an org, with the supply type migrating as the document progresses
-- Purpose: Column-selected read of MTL_SUPPLY — auto-generated from field metadata
-- Grain  : One row per SUPPLY_TYPE_CODE + SUPPLY_SOURCE_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.SUPPLY_TYPE_CODE AS "The supply stage — requisition, PO, receiving, or shipment; migrates as the document progresses",
  t.SUPPLY_SOURCE_ID AS "Id of the supplying document element at the current stage",
  t.ITEM_ID AS "Item id — this table's name for it (not INVENTORY_ITEM_ID)",
  t.TO_ORGANIZATION_ID AS "The org the supply is coming INTO — the org filter for supply pictures",
  t.FROM_ORGANIZATION_ID AS "The shipping org on internal transfers",
  t.QUANTITY AS "Open supply quantity",
  t.EXPECTED_DELIVERY_DATE AS "When the supply is expected to arrive",
  t.NEED_BY_DATE AS "When the org needs it, from the document",
  t.RECEIPT_DATE AS "Receipt date for supply already in receiving",
  t.PO_HEADER_ID AS "The purchase order header, for PO-stage supply",
  t.PO_LINE_ID AS "The purchase order line",
  t.REQ_HEADER_ID AS "The requisition header, for requisition-stage supply",
  t.SHIPMENT_HEADER_ID AS "The receiving shipment header, once in receiving",
  t.DESTINATION_TYPE_CODE AS "Where the supply is destined (inventory, expense, shop floor)"
FROM <catalog>.<schema>.MTL_SUPPLY t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.EXPECTED_DELIVERY_DATE >= DATE '<DATE_FROM>'
  -- AND t.EXPECTED_DELIVERY_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.SUPPLY_TYPE_CODE;