Search Results partial_shipments_allowed

Overview

APPS.WSH_DSNO_ORDERS_SPECIFIC_V is a Shipping Execution (WSH) view that consolidates order-header, customer, address, contact, agreement, and payment-term attributes into a single denormalized structure for outbound order information. The name prefix "DSNO" denotes Delivery Ship Notice Outbound, indicating the view's role within the Oracle E-Business Suite outbound EDI/XML messaging and shipping-integration framework. It is a supporting object referenced by the WSH_DSNO (ship notice) extraction logic and is exposed by the WSH_ECE_VIEWS_DEF package, which supplies derived values such as contact area codes and telephone numbers.

The view is defined in the APPS schema and is documented as VALID. It presents one row per order header record sourced from Order Management (OE), joined outward to delivery and customer master data. Because the PURCHASE_ORDER_DATE column is implemented as a direct alias of OEH.ORDERED_DATE, a search on "purchase_order_date" against this view resolves to the order's original ordered date rather than a true procurement document date. This aliasing behaviour is a common source of confusion in reporting.

Underlying Base Objects

The view is defined over a wide set of documented base objects:

• Order Management: OE_ORDER_HEADERS_ALL, OE_TRANSACTION_TYPES_TL, OE_AGREEMENTS_B
• Contracts/OKE: OKC_K_HEADERS_B, OKE_K_HEADERS, OKE_K_TERMS, OKE_K_FUNDING_SOURCES
• Receivables: RA_TERMS
• Customer master (HZ): HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_ORG_CONTACTS, HZ_PARTIES, HZ_PARTY_SITES, HZ_RELATIONSHIPS
• Trading partner EDI: ECE_TP_HEADERS
• Shipping: WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS_V
• Program units: WSH_DSNO_OKE (package), WSH_ECE_VIEWS_DEF (package)

The joins establish the linkage from the sales order down to the ship-to/invoice customer account site, site use, location addresses, and organization contacts. Delivery-related rows are attached through WSH_DELIVERY_DETAILS and WSH_DELIVERY_ASSIGNMENTS_V, which map order lines to delivery details and assignments. The WSH_DSNO_OKE and WSH_ECE_VIEWS_DEF PL/SQL packages supply additional derived values, including contact and EDI location attributes used in outbound messages.

Key Columns

• PURCHASE_ORDER_DATE — aliased directly to OEH.ORDERED_DATE; represents the original sales-order ordered date, not a distinct procurement date.
• SALES_ORDER_DATE / SALES_ORDER_NUMBER — ordered date and order number of the source order header.
• SOURCE_CODE / SOURCE_HEADER_ID — literal 'OE' and the underlying OE header ID, providing provenance for the row.
• ORDER_TYPE_INT, ORDER_CATEGORY_CODE, ORDER_DATE_TYPE_CODE — order classification and dating semantics.
• CUSTOMER_REQUEST_DATE — request date from OEH.REQUEST_DATE.
• INVOICE_ADDRESS_ID and INVOICE_ADDRESS1–4, INVOICE_CITY, INVOICE_STATE_INT, INVOICE_POSTAL_CODE, INVOICE_COUNTRY_INT — invoice address detail drawn from HZ_LOCATIONS and site records.
• INVOICE_CONTACT_LAST_NAME / FIRST_NAME / JOB_TITLE — contact attribution via HZ_PARTIES, HZ_ORG_CONTACTS and HZ_RELATIONSHIPS.
• INVOICE_AREA_CODE, INVOICE_TELEPHONE — derived by WSH_ECE_VIEWS_DEF.
• INVOICE_CODE_INT, INVOICE_EDI_LOC_CODE, INVOICE_TP_REF_1/2 — EDI-related identifiers (ECE_TP_HEADERS) used in outbound documents.
• CURRENCY_CONVERSION_TYPE_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency conversion metadata.
• PAYMENT_TERMS_INT — payment terms name from RA_TERMS.
• TAX_EXEMPT_FLAG / NUMBER / REASON_CODE_INT — tax exemption attributes.
• DELIVERY_ID — exposed as a constant 0 in the visible fragment, reflecting delivery linkage supplied elsewhere in the definition.

Common Use Cases and Queries

The view supports ship-notice generation, order-data extraction for outbound EDI, and customer-facing order extracts. Typical patterns include filtering by date range and joining to WSH delivery tables.

SELECT source_header_id,
       sales_order_number,
       purchase_order_date,
       sales_order_date,
       invoice_city,
       payment_terms_int
FROM   apps.wsh_dsno_orders_specific_v
WHERE  purchase_order_date >= :from_date
AND    purchase_order_date <  :to_date;

For contact and EDI attributes:

SELECT sales_order_number,
       invoice_contact_last_name,
       invoice_telephone,
       invoice_edi_loc_code,
       invoice_tp_ref_1
FROM   apps.wsh_dsno_orders_specific_v
WHERE  invoice_edi_loc_code IS NOT NULL;

Because PURCHASE_ORDER_DATE mirrors the sales order ordered date, reports must not treat it as a procurement date; a genuine PO date must be sourced from procurement tables. Queries should be schema-qualified as APPS and executed with appropriate Shipping Execution and Order Management privileges.