Search Results transportation_method




Overview
Explore in AI Chat

Overview

WSH_STND_SHIPMENT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Shipping Execution (WSH) product family. It presents a denormalized, shipment-level ("standard shipment") perspective by joining delivery header data from WSH_NEW_DELIVERIES with transaction history records from WSH_TRANSACTIONS_HISTORY, and enriching the result with organization, carrier, and ship-from location attributes. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a convenient read-only interface for reports, concurrent programs, BI Publisher data models, and outbound integrations that require shipment identifiers, transport details, weight/volume measures, and descriptive flexfield (DFF) context in a single result set. Because the view exposes the DFF column ATTRIBUTE_CATEGORY as SHIPMENT_ATTRIBUTE_CATEGORY alongside SHIPMENT_ATTRIBUTE1 through SHIPMENT_ATTRIBUTE15, it is frequently the target of queries that filter or report on shipment attribute category values — the exact use case reflected in the search term "shipment_attribute_category".

Underlying Base Objects

The documented referenced base objects are: HR_GENERAL (PACKAGE), HR_LOCATIONS_ALL_TL (SYNONYM), HR_SECURITY (PACKAGE), ORG_ORGANIZATION_DEFINITIONS (VIEW), WSH_CARRIERS_V (VIEW), WSH_LOCATIONS (SYNONYM), WSH_NEW_DELIVERIES (SYNONYM), and WSH_TRANSACTIONS_HISTORY (SYNONYM).

  • WSH_NEW_DELIVERIES (aliased WND) is the primary driver, supplying delivery_id, ship method, dates, weights, volume, shipping marks, FOB and freight terms codes, loading sequence, waybill, service level, and the ATTRIBUTE_CATEGORY/ATTRIBUTE1–15 DFF columns.
  • WSH_TRANSACTIONS_HISTORY (aliased WTH) contributes transaction-level context: action_type (exported as ACTION_CODE), document_number, document_type, document_revision, and orig_document_number.
  • WSH_CARRIERS_V (aliased WCAR) supplies CARRIER_NAME.
  • ORG_ORGANIZATION_DEFINITIONS (aliased OOG) supplies ORGANIZATION_CODE.
  • WSH_LOCATIONS / HR_LOCATIONS_ALL_TL (aliased HRL) resolve the ship-from LOCATION_CODE.
  • HR_GENERAL and HR_SECURITY packages are referenced to support organization and location security resolution.

The SELECT DISTINCT clause indicates that the joins may produce duplicate rows, so the view deduplicates results.

Key Columns

Common Use Cases and Queries

Typical uses include shipment status/attribute reporting, carrier analysis, and DFF-based filtering.

  • List all shipments of a given attribute category: 
    SELECT delivery_id, document_number, shipment_attribute_category, shipment_attribute1
FROM   apps.wsh_stnd_shipment_v
WHERE  shipment_attribute_category = 'MY_DFF_CONTEXT';
  • Weight/volume summary by carrier: 
    SELECT carrier, SUM(gross_weight) total_gross, SUM(volume) total_volume
FROM   apps.wsh_stnd_shipment_v
GROUP  BY carrier;
  • Organization-scoped shipment listing: 
    SELECT organization_code, delivery_id, ship_from_location
FROM   apps.wsh_stnd_shipment_v
WHERE  organization_id = :p_org_id;