WSH Commercial Invoice – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Shipping commercial invoice report showing delivery details including shipped items, quantities, unit costs, extended costs, ship-from/ship-to addresses, freight information, and bill of lading details. Blitz version of the Oracle standard Commercial Invoice (XML) concurrent program WSHRDINV_XML. DB package: WSH_WSHRDINV_XMLP_PKG

Report Parameters

Trip Stop, Stop Planned Depart Date (Low), Stop Planned Depart Date (High), Freight Carrier, Warehouse, Delivery Name, Currency Code, Item Display, Show DFF Attributes, Print Customer Item

Oracle EBS Tables Used

wsh_carrier_services, wsh_delivery_assignments_v, wsh_delivery_details, wsh_bols_rd_v, hz_party_site_uses, hz_party_sites, hz_parties, hz_cust_site_uses_all, hz_cust_acct_sites_all, hz_cust_account_roles, hz_relationships, mtl_system_items_vl, mtl_categories_kfv, mtl_item_categories, mtl_category_sets_vl, oe_order_lines_all, oke_k_deliverables_b, wsh_freight_costs, wsh_freight_cost_types, wsh_new_deliveries, wsh_locations, mtl_categories, mtl_default_category_sets, fnd_territories_tl, org_organization_definitions, bom_inventory_components, dual

Report Categories

Enginatics

WSH Shipping/Delivery Transactions, ONT Orders and Lines, PPF_WP3_OM_DETAILS

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output WSH Commercial Invoice 28-Mar-2026 011331.xlsx
Blitz Report™ XML Import WSH_Commercial_Invoice.xml
Full SQL on Enginatics www.enginatics.com/reports/wsh-commercial-invoice/

© 2026 Enginatics