OracleOps AI
← All tables
Oracle Fusion/Supply Chain/Shipping

WSH_TRIP_STOPS

A stop (pickup or dropoff location) on a trip — deliveries are planned onto a stop, not the trip directly.

Key Columns

STOP_IDTRIP_IDSTOP_LOCATION_IDPLANNED_DEPARTURE_DATE

Parent Table

WSH_TRIPS

Trip header — a transportation run (e.g. one truck's route) that one or more deliveries are planned onto.

Common Joins

WSH_TRIPSvia TRIP_ID

The trip this stop belongs to.

Used In

Shipping

Related

Shipping data model: delivery detail, delivery, and trip

Pick release creates a WSH_DELIVERY_DETAILS row per fulfillment line, grouped into a WSH_NEW_DELIVERIES header via WSH_DELIVERY_ASSIGNMENTS — a separate assignment table (not a direct FK) specifically so a line can be moved to a different delivery before it ships. One or more deliveries are then planned onto a WSH_TRIPS header at a WSH_TRIP_STOPS pickup/dropoff location, which is the transportation-run level (e.g. one truck's route) above the delivery.

Ask Oracle AI about WSH_TRIP_STOPS