WSH_TRIP_STOPS

-- ============================================================
-- Table  : WSH_TRIP_STOPS — Trip stops — one row per pickup or drop-off point on a trip, with planned and actual arrival/departure timestamps; the actual departure at the pickup stop is the gate-out time ship confirm writes
-- Purpose: Column-selected read of WSH_TRIP_STOPS — auto-generated from field metadata
-- Grain  : One row per STOP_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.STOP_ID AS "Surrogate key of the stop",
  t.TRIP_ID AS "The trip the stop belongs to",
  t.STOP_SEQUENCE_NUMBER AS "Order of the stop within the trip",
  t.STOP_LOCATION_ID AS "The stop's location",
  t.STATUS_CODE AS "OP open, IT in transit, CL closed — spelled out in the data dictionary's column comment",
  t.PLANNED_ARRIVAL_DATE AS "Planned arrival",
  t.PLANNED_DEPARTURE_DATE AS "Planned departure",
  t.ACTUAL_ARRIVAL_DATE AS "Actual arrival",
  t.ACTUAL_DEPARTURE_DATE AS "Actual departure — at the pickup stop this is the gate-out time ship confirm writes",
  t.DEPARTURE_GROSS_WEIGHT AS "Gross weight at departure",
  t.PENDING_INTERFACE_FLAG AS "Y while the stop awaits the interface run — a backlog signal"
FROM <catalog>.<schema>.WSH_TRIP_STOPS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.STOP_ID = <STOP_ID>
  -- AND t.ACTUAL_DEPARTURE_DATE >= DATE '<DATE_FROM>'
  -- AND t.ACTUAL_DEPARTURE_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.STOP_ID;