Search Results ship_method_code_meaning




Overview
Explore in AI Chat

Overview

WSH_CARRIER_SHIP_METHODS_V is a Shipping Execution (WSH) reporting view owned by the APPS schema. It presents the intersection of three distinct reference data sets: carrier ship methods defined in WSH_CARRIER_SHIP_METHODS, the corresponding lookup meaning of the shipment method code held in FND_LOOKUP_VALUES_VL, and the freight terms associated with the operating unit's shipping organization via ORG_FREIGHT_VL. The view is primarily used to expose a human-readable ship method description alongside the internal carrier/method configuration, which is a frequent requirement in shipping reports, carrier manifests, and integration extracts. Users searching for ship_method_code_meaning are typically attempting to resolve the seeded lookup value (SHIP_METHOD lookup type, view application id 3) that is returned in this view as the column SHIP_METHOD_CODE_MEANING (aliased from FL.MEANING). The view is marked VALID in ETRM 12.2.2 and is compatible with the 12.1.1 and 12.2.2 code lines.

Underlying Base Objects

The view is defined over the following documented base objects:

  • WSH_CARRIER_SHIP_METHODS (synonym) — the primary driver table holding carrier ship method definitions, including the carrier identifier, ship method code, service level, freight code, organization, carrier site, and descriptive flexfield attributes.
  • FND_LOOKUP_VALUES_VL (view) — joined on FL.LOOKUP_TYPE = 'SHIP_METHOD' and FL.LOOKUP_CODE = CSM.SHIP_METHOD_CODE, with FL.VIEW_APPLICATION_ID = 3, to supply the meaning and the active date range of the lookup value.
  • ORG_FREIGHT_VL (view) — joined on OFV.ORGANIZATION_ID = CSM.ORGANIZATION_ID and OFV.FREIGHT_CODE = CSM.FREIGHT_CODE, to supply the translated freight code description.
  • MTL_PARAMETERS (synonym) — joined on MP.ORGANIZATION_ID = CSM.ORGANIZATION_ID, to supply the organization code for the owning inventory/shipping organization.

The joins to the lookup and freight values are effectively mandatory inner joins, so a carrier ship method row only appears when matching lookup and freight records exist for the same organization.

Key Columns

  • CARRIER_SHIP_METHOD_ID — primary key of the carrier ship method configuration record.
  • CARRIER_ID — carrier the method belongs to; CARRIER_SITE_ID identifies the specific carrier site.
  • SHIP_METHOD_CODE — the internal lookup code (the value stored on shipping transactions).
  • SHIP_METHOD_CODE_MEANING — the descriptive meaning resolved from the SHIP_METHOD lookup via FL.MEANING; this is the column most commonly surfaced to end users.
  • SERVICE_LEVEL — carrier service level associated with the method.
  • ENABLED_FLAG — indicates whether the ship method is active.
  • FREIGHT_CODE / FREIGHT_CODE_TL — the freight term code and its translated description.
  • ORGANIZATION_ID / ORGANIZATION_CODE — the owning shipping organization.
  • WEB_ENABLED — flag indicating whether the method is available for web-based shipment.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the active date range of the underlying lookup value.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns for customer-defined data.

Common Use Cases and Queries

Typical uses include carrier/method validation extracts, shipment reporting with readable method names, and freight term analysis by organization. A common query resolves the meaning for a given code:

  • SELECT SHIP_METHOD_CODE, SHIP_METHOD_CODE_MEANING, CARRIER_ID, ENABLED_FLAG FROM WSH_CARRIER_SHIP_METHODS_V WHERE SHIP_METHOD_CODE = :p_code;
  • SELECT ORGANIZATION_CODE, SHIP_METHOD_CODE_MEANING, FREIGHT_CODE_TL FROM WSH_CARRIER_SHIP_METHODS_V WHERE ENABLED_FLAG = 'Y' ORDER BY ORGANIZATION_CODE;

Because the view resolves the lookup meaning and organization code, it is often preferred over querying WSH_CARRIER_SHIP_METHODS directly for reporting and integration scenarios.