Search Results unit_amount




Overview
Explore in AI Chat

Overview

WSHBV_FREIGHT_COSTS is an APPS-owned read-only view in the Oracle E-Business Suite Shipping Execution (WSH) module. It consolidates freight cost records captured against deliveries, delivery details, trips, stops, and delivery legs into a single reporting-optimized structure. The view is defined with the WITH READ ONLY clause, which prevents DML operations and enforces its role as a query-only interface for reporting and integration.

Because freight costs are stored in the base table WSH_FREIGHT_COSTS with foreign keys spanning multiple shipping entities, reconstructing a complete freight picture requires joining several tables. WSHBV_FREIGHT_COSTS encapsulates those joins and applies directional filters, exposing only outbound and internal outbound shipment records. This makes the view a convenient foundation for costing reports, freight audit extracts, and integration interfaces in both EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over five documented base objects, all referenced through synonyms in the APPS schema:

All four joins to the secondary tables are outer joins ((+)), so freight cost rows are preserved even when the related delivery, trip, stop, or detail record is absent. The WHERE clause applies directional filters using NVL defaults: NVL(WND.SHIPMENT_DIRECTION,'O') IN ('O','IO'), NVL(WT.SHIPMENTS_TYPE_FLAG,'O') IN ('O','M'), NVL(WTS.SHIPMENTS_TYPE_FLAG,'O') IN ('O','M'), and NVL(WDD.LINE_DIRECTION,'O') IN ('O','IO'). Consequently, inbound shipments are excluded from this view, and consumers must rely on the base table for those records.

Key Columns

The view exposes 22 columns. The primary identifier is FREIGHT_COST_ID, accompanied by standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).

  • DELIVERY_ID, DELIVERY_DETAIL_ID, TRIP_ID, STOP_ID, DELIVERY_LEG_ID — foreign keys linking the cost to its shipping context.
  • FREIGHT_COST_TYPE_ID — reference to the freight cost type definition.
  • UNIT_AMOUNT, QUANTITY, UOM, TOTAL_AMOUNT — the monetary and quantity measures of the charge.
  • CALCULATION_METHOD — indicates how the cost was derived.
  • FREIGHT_CODE — the freight charge code.
  • CURRENCY_CODE, CONVERSION_DATE, CONVERSION_RATE, CONVERSION_TYPE_CODE — currency and conversion attributes. The CONVERSION_TYPE_CODE column, the term that prompted this lookup, identifies the currency conversion rate type (for example, Corporate or Spot) applied to the freight cost, with CONVERSION_RATE and CONVERSION_DATE providing the associated rate and effective date.

Common Use Cases and Queries

Typical uses include delivery-level freight cost analysis, trip costing, freight audit and reconciliation, and integration extracts. A simple query retrieving freight costs with currency conversion detail:

  • SELECT freight_cost_id, delivery_id, trip_id, total_amount, currency_code, conversion_type_code, conversion_rate FROM wshbv_freight_costs WHERE conversion_type_code = 'Corporate';
  • SELECT delivery_id, SUM(total_amount) FROM wshbv_freight_costs GROUP BY delivery_id;
  • SELECT f.freight_cost_id, f.trip_id, f.freight_code, f.unit_amount, f.quantity, f.uom FROM wshbv_freight_costs f WHERE f.trip_id IS NOT NULL;

When queries require inbound shipment direction or write access, the base table WSH_FREIGHT_COSTS must be used instead, since the view is read-only and filtered to outbound and internal outbound records.