Search Results wsh_ss_shipment_v




Overview
Explore in AI Chat

Overview

The WSH_SS_SHIPMENT_V view is a Shipping Execution (WSH) reporting object owned by the APPS schema and defined as a VALID database view in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, read-only projection of shipment and delivery header information, joining together delivery records, shipment transaction history, ship-from locations, organization definitions, carrier definitions, and carrier service details. Its principal role is to expose shipment-level attributes in a single queryable structure for reporting, inbound/outbound integration, and custom concurrent programs, without requiring the consumer to reconstruct the underlying multi-table join.

Because a delivery in Oracle Shipping may be represented across several transactional and historical tables (the delivery itself, its transaction history, and its carrier assignment), this view distills the delivery header into a convenient denormalized form. Notably, the view includes the DELIVERED_DATE column, derived from WSH_NEW_DELIVERIES.DELIVERED_DATE, which is directly relevant to searches for shipment "delivered_date." The view also exposes document metadata, freight and weight attributes, carrier and service level information, and a full set of shipment DFF attributes.

Underlying Base Objects

The view is defined over multiple base objects. The primary delivery source is WSH_NEW_DELIVERIES (WND), joined to WSH_TRANSACTIONS_HISTORY (WTH) to supply document number, document type, action type, and original document number. Location information is supplied by HR_LOCATIONS_ALL_TL for the ship-from location code and by WSH_LOCATIONS for country. Organization context comes from ORG_ORGANIZATION_DEFINITIONS, and carrier-related data comes from WSH_CARRIERS_V and WSH_CARRIER_SERVICES.

Documented referenced base objects further include HR_GENERAL, HR_SECURITY, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, MTL_PARAMETERS, and WSH_SHIPMENT_BATCHES. The HR security packages and HZ tables typically support location and party-site resolution behind the ship-to logic, while MTL_PARAMETERS supplies inventory organization context. The view returns distinct delivery/transaction combinations.

Key Columns

Common Use Cases and Queries

Typical uses include shipment tracking reports, carrier performance analysis, and extraction for data warehouses or integration middleware. The DELIVERED_DATE column is commonly used to measure delivery timeliness against ULTIMATE_DROPOFF_DATE and to identify shipments delivered within a period.

  • List shipments delivered in a given date range: 
    SELECT delivery_id, document_number, delivered_date, carrier, service_level
FROM   apps.wsh_ss_shipment_v
WHERE  delivered_date BETWEEN :p_from AND :p_to;
  • Identify shipments by carrier and ship-from location: 
    SELECT document_number, ship_from_location, carrier, organization_code
FROM   apps.wsh_ss_shipment_v
WHERE  carrier = :p_carrier
AND    organization_code = :p_org;
  • Report outbound freight volumes and weights: 
    SELECT delivery_id, gross_weight, weight_uom_code, volume, volume_uom_code
FROM   apps.wsh_ss_shipment_v
WHERE  shipment_direction = 'O';

Because the view incorporates HR security and location tables, query results may be filtered by organization and location access. All queries should reference the APPS schema with appropriate responsibilities and grants.