Search Results stop_description

Overview

The WSH_SRS_TRIP_STOPS_V view is a Shipping Execution (WSH) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, human-readable projection of trip stop information by joining trip headers, trip stop lines, and shipping locations. The view was introduced or revised under Oracle change reference 1924581 to leverage HR_LOCATIONS-related data via the WSH_LOCATIONS synonym.

The view is primarily intended for reporting, integration, and interface scenarios where a descriptive stop label is required rather than raw surrogate identifiers. It exposes a single derived STOP_DESCRIPTION column that concatenates the trip name, the location code, a city or address fragment, and a formatted departure date. The search term stop_description maps directly to this derived column, which is the principal reason consumers query this view.

Underlying Base Objects

The view is defined over three documented base objects:

• WSH_TRIPS (synonym) — the trip header, supplying TRIP_ID and NAME.
• WSH_TRIP_STOPS (synonym) — the trip stop detail, supplying STOP_ID, STOP_LOCATION_ID, PLANNED_DEPARTURE_DATE, ACTUAL_DEPARTURE_DATE, SHIPMENTS_TYPE_FLAG, and PENDING_INTERFACE_FLAG.
• WSH_LOCATIONS (synonym) — the shipping location, supplying LOCATION_CODE, CITY, ADDRESS1, and UI_LOCATION_CODE.

Joins are performed on TS.TRIP_ID = T.TRIP_ID and TS.STOP_LOCATION_ID = WL.WSH_LOCATION_ID. A filter restricts rows to shipment types 'O' (outbound) and 'M' (miscellaneous), applying NVL(SHIPMENTS_TYPE_FLAG,'O') so that null flags default to outbound.

Key Columns

• STOP_ID — surrogate identifier of the trip stop from WSH_TRIP_STOPS.
• STOP_DESCRIPTION — derived string formatted as TripName-LocationCode:City-or-Address-DD\MM\YYYY, using NVL(ACTUAL_DEPARTURE_DATE, PLANNED_DEPARTURE_DATE).
• STOP_LOCATION_ID — foreign key to WSH_LOCATIONS.
• LOCATION_CODE — concatenation of location code and city/address fragment.
• LOCATION_DESCRIPTION — the user-interface location code (UI_LOCATION_CODE).
• TRIP_ID — parent trip identifier.
• PENDING_INTERFACE_FLAG — indicates whether the stop is pending an interface to an external system.

Common Use Cases and Queries

Typical usage includes trip manifest reports, carrier interface extracts, and shipment tracking dashboards that require a readable stop label. The following query retrieves stops for a given trip:

SELECT STOP_ID, STOP_DESCRIPTION, LOCATION_DESCRIPTION
FROM   APPS.WSH_SRS_TRIP_STOPS_V
WHERE  TRIP_ID = :p_trip_id
ORDER BY STOP_DESCRIPTION;

To list only stops pending external interface:

SELECT TRIP_ID, STOP_ID, STOP_DESCRIPTION
FROM   APPS.WSH_SRS_TRIP_STOPS_V
WHERE  PENDING_INTERFACE_FLAG = 'Y';

Because the view exposes the derived STOP_DESCRIPTION, applications should not rely on it for deterministic sorting across locales; sorting on STOP_ID or TRIP_ID is preferred. The view is read-only and inherits the security context of the querying responsibility.