WSH_TRIPS

-- ============================================================
-- Table  : WSH_TRIPS — The trip header — a carrier/vehicle journey over an ordered set of stops, with ship method, carrier, and vehicle attributes
-- Purpose: Column-selected read of WSH_TRIPS — auto-generated from field metadata
-- Grain  : One row per TRIP_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.TRIP_ID AS "Surrogate key of the trip",
  t.NAME AS "The trip name users see",
  t.STATUS_CODE AS "OP open, IT in transit, CL closed — same ladder as trip stops, from the same dictionary comment",
  t.PLANNED_FLAG AS "Whether the trip is planned",
  t.CARRIER_ID AS "Freight carrier running the trip",
  t.SHIP_METHOD_CODE AS "Ship method",
  t.VEHICLE_ITEM_ID AS "The vehicle, modeled as an item",
  t.VEHICLE_NUMBER AS "Vehicle identifier",
  t.ARRIVE_AFTER_TRIP_ID AS "Trip sequencing constraint — this trip arrives after that one"
FROM <catalog>.<schema>.WSH_TRIPS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.TRIP_ID = <TRIP_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.TRIP_ID;