Search Results freight_terms_code_int




Overview
Explore in AI Chat

Overview

The WSH_DSNO_ORDERS_COMM_V view is an Oracle E-Business Suite dictionary object owned by the APPS schema and delivered as part of the Shipping Execution (WSH) product family. It presents order-level commercial and address information for delivery details in a form suitable for outbound shipping documents and EDI/XML message generation. The view is designed to supply the "Despatch Advice" (DSNO) trading-partner payload with the commercial attributes associated with a shipment: the header identifiers of the originating order, purchase order references, sold-to address and contact details, currency, FOB terms, and freight terms. It is typically consumed by the Oracle E-Commerce Gateway (ECE) outbound mapping for delivery notifications, where internal coded values must be paired with their trading-partner equivalents.

The view surfaces the freight terms of the order as the column FREIGHT_TERMS_CODE_INT, sourced directly from WSH_DELIVERY_DETAILS.FREIGHT_TERMS_CODE. This is the internal QuickCode value, and it is the column most frequently referenced when users search for "freight_terms_code_int" in the context of WSH reporting.

Underlying Base Objects

Per the documented ETRM metadata for release 12.2.2, the view is defined over the following base objects:

Key Columns

Common Use Cases and Queries

The view is used to populate outbound delivery notification data, to print commercial shipping documentation, and to report freight and FOB terms by shipment. A representative query retrieves the freight terms, FOB point, currency, and order-by details for a delivery:

  • SELECT delivery_id, sales_order_number, purchase_order_number, transactional_currency_code, fob_point_code_int, freight_terms_code_int FROM apps.wsh_dsno_orders_comm_v WHERE delivery_id = :p_delivery_id;
  • SELECT DISTINCT delivery_id, freight_terms_code_int FROM apps.wsh_dsno_orders_comm_v WHERE freight_terms_code_int IS NOT NULL; — to enumerate distinct freight terms on shipments.
  • Join to FND_LOOKUPS/WSH_LOOKUPS or ECE code conversion tables mapping FREIGHT_TERMS_CODE_INT to the trading-partner value for EDI generation.