WSH_DELIVERY_LEGS

-- ============================================================
-- Table  : WSH_DELIVERY_LEGS — Delivery legs — the mapping from a delivery to the trip stops where it is picked up and dropped off; the only path from deliveries to trips
-- Purpose: Column-selected read of WSH_DELIVERY_LEGS — auto-generated from field metadata
-- Grain  : One row per DELIVERY_LEG_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.DELIVERY_LEG_ID AS "Surrogate key of the leg",
  t.DELIVERY_ID AS "The delivery the leg moves",
  t.SEQUENCE_NUMBER AS "Leg order within the delivery's route — pick the lowest for the origin departure",
  t.PICK_UP_STOP_ID AS "The trip stop the leg picks up at (spelled PICK_UP, not PICKUP)",
  t.DROP_OFF_STOP_ID AS "The trip stop the leg drops off at",
  t.STATUS_CODE AS "Leg status",
  t.ACTUAL_ARRIVAL_DATE AS "Actual arrival at the drop-off stop",
  t.ACTUAL_DEPARTURE_DATE AS "Actual departure from the pickup stop"
FROM <catalog>.<schema>.WSH_DELIVERY_LEGS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.DELIVERY_LEG_ID = <DELIVERY_LEG_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.DELIVERY_LEG_ID;