Search Results order_by_code_int

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:

• WSH_DELIVERY_ASSIGNMENTS_V (VIEW) — links a delivery to its delivery details and provides DELIVERY_ID and PARENT_DELIVERY_DETAIL_ID (exposed as CONTAINER_INSTANCE_ID).
• WSH_DELIVERY_DETAILS (SYNONYM) — the primary source of order references, purchase order number, sales order number, currency, FOB point, and freight terms.
• HZ_CUST_ACCOUNT_ROLES, HZ_RELATIONSHIPS, HZ_ORG_CONTACTS, HZ_PARTIES — resolve the order-by contact name, job title, and related party names.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTY_SITES — supply the sold-to (order-by) address and its location codes.
• ECE_TP_HEADERS (SYNONYM) — provides the trading-partner reference extensions TP_REFERENCE_EXT1 and TP_REFERENCE_EXT2.
• WSH_ECE_VIEWS_DEF (PACKAGE) — supplies the PL/SQL functions GET_CONT_AREA_CODE and GET_CONT_PHONE_NUMBER used to derive contact area code and telephone number.

Key Columns

• DELIVERY_ID, CONTAINER_INSTANCE_ID — delivery and container (LIC) identification.
• ORDER_HEADER_ID, SOURCE_CODE, SALES_ORDER_NUMBER, PURCHASE_ORDER_NUMBER — originating order identity.
• ORDER_BY_ADDRESS_ID, ORDER_BY_CODE_INT, ORDER_BY_EDI_LOC_CODE, ORDER_BY_TP_REF_1, ORDER_BY_TP_REF_2 — order-by (sold-to) location and trading-partner references.
• ORDER_BY_NAME, ORDER_BY_ADDRESS1..4, ORDER_BY_CITY, ORDER_BY_POSTAL_CODE, ORDER_BY_COUNTRY_INT, ORDER_BY_STATE_INT, ORDER_BY_PROVINCE_INT, ORDER_BY_COUNTY — order-by address components.
• ORDER_BY_CONTACT_LAST_NAME, ORDER_BY_CONTACT_FIRST_NAME, ORDER_BY_CONTACT_JOB_TITLE, ORDER_BY_AREA_CODE, ORDER_BY_TELEPHONE — order-by contact details.
• TRANSACTIONAL_CURRENCY_CODE — order currency.
• FOB_POINT_CODE_INT — internal FOB point code.
• FREIGHT_TERMS_CODE_INT — internal freight terms QuickCode for the order.

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.