Search Results max_size_width

Overview

WSH_CARRIER_SERVICES_V is a shipping execution view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents carrier service definitions maintained in the Shipping Execution module, combining the operational attributes of a carrier service with the decoded meaning of its ship method lookup code. The view exists primarily to simplify reporting and integration by resolving the foreign key relationship between WSH_CARRIER_SERVICES.SHIP_METHOD_CODE and the SHIP_METHOD lookup type in FND_LOOKUP_VALUES_VL, exposing the resulting translation as the SHIP_METHOD_MEANING column. This is the attribute most commonly sought by users who search on the term "ship_method_meaning," since the base table stores only the code and not the user-facing description.

Underlying Base Objects

The view is defined over two documented base objects. The first is WSH_CARRIER_SERVICES, referenced through a synonym, which supplies the carrier-service master data including carrier identifiers, service levels, mode of transport, transit-time attributes, and the flexible attribute columns. The second is FND_LOOKUP_VALUES_VL, the multilingual lookup values view, which supplies the translated meaning. The join is performed on three conditions: the lookup type must equal SHIP_METHOD, the lookup code must equal WSH_CARRIER_SERVICES.SHIP_METHOD_CODE, and the view application identifier must equal 3, restricting results to the Oracle Shipping application lookup set. Because the join relies on a lookup constrained to a single type, each carrier service row is enriched with exactly one meaning value, keeping the view effectively one-to-one with its driving table.

Key Columns

The view exposes the full WSH_CARRIER_SERVICES column set plus the derived meaning. Key columns include:

• CARRIER_SERVICE_ID – Primary key identifying the carrier service record.
• CARRIER_ID – Foreign key to the carrier definition used by the service.
• SHIP_METHOD_CODE – The lookup code stored on the carrier service.
• SHIP_METHOD_MEANING – The decoded, translated meaning resolved from FND_LOOKUP_VALUES_VL; the focal column for reporting.
• SERVICE_LEVEL and MODE_OF_TRANSPORT – Classification attributes for the service.
• MIN_SL_TIME, MAX_SL_TIME, and SL_TIME_UOM – Service-level transit time boundaries and unit of measure.
• ENABLED_FLAG and WEB_ENABLED – Activation indicators for internal and web-facing use.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 – Descriptive flexfield segments.
• Who columns such as CREATION_DATE, CREATED_BY, and LAST_UPDATE_DATE.
• Transportation planning attributes including MAX_NUM_STOPS_PERMITTED, MAX_TOTAL_DISTANCE, MAX_TOTAL_TIME, and related continuous-move parameters.

Common Use Cases and Queries

The view is typically used for reporting on carrier services with human-readable ship method descriptions, for validating ship method configuration, and for integration extracts that must supply meaningful labels rather than codes. A representative query lists enabled services with their meanings:

• SELECT carrier_service_id, carrier_id, ship_method_code, ship_method_meaning FROM wsh_carrier_services_v WHERE enabled_flag = 'Y';
• SELECT ship_method_meaning, COUNT(*) FROM wsh_carrier_services_v GROUP BY ship_method_meaning;
• SELECT c.carrier_id, v.ship_method_meaning FROM wsh_carrier_services_v v, wsh_carriers c WHERE v.carrier_id = c.carrier_id;

Because the meaning is resolved through the multilingual lookup view, results respect the session language, making the view suitable for localized reports and interfaces.