OE_DROP_SHIP_SOURCES

-- ============================================================
-- Table  : OE_DROP_SHIP_SOURCES — The drop-ship bridge — one row linking a sales order line to the purchase requisition and purchase order raised to fulfill it from the supplier; the only physical tie between the order-to-cash and procure-to-pay flows
-- Purpose: Column-selected read of OE_DROP_SHIP_SOURCES — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + DROP_SHIP_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.DROP_SHIP_SOURCE_ID AS "Working surrogate key — no enforced primary key in the data dictionary",
  t.ORG_ID AS "Operating unit — drop-ship raises the requisition and PO in the order's OU",
  t.HEADER_ID AS "The sales order header",
  t.LINE_ID AS "The sales order line being drop-shipped",
  t.DESTINATION_ORGANIZATION_ID AS "The receiving inventory org on the purchasing side",
  t.REQUISITION_HEADER_ID AS "The requisition raised for the line",
  t.REQUISITION_LINE_ID AS "The requisition line",
  t.PO_HEADER_ID AS "The purchase order raised, once autocreated",
  t.PO_LINE_ID AS "The purchase order line",
  t.LINE_LOCATION_ID AS "The PO shipment schedule — this table's name for it (the supply picture spells it PO_LINE_LOCATION_ID)",
  t.PO_RELEASE_ID AS "The blanket release, when fulfilled off an agreement"
FROM <catalog>.<schema>.OE_DROP_SHIP_SOURCES t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.DROP_SHIP_SOURCE_ID = <DROP_SHIP_SOURCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.DROP_SHIP_SOURCE_ID;