| layout | default |
|---|---|
| title | WSH Commercial Invoice | Oracle EBS SQL Report |
| description | Shipping commercial invoice report showing delivery details including shipped items, quantities, unit costs, extended costs, ship-from/ship-to addresses… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, WSH, Commercial, Invoice, wsh_carrier_services, wsh_delivery_assignments_v, wsh_delivery_details |
| permalink | /WSH%20Commercial%20Invoice/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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
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
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
WSH Shipping/Delivery Transactions, ONT Orders and Lines, PPF_WP3_OM_DETAILS
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.
| 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/ |
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics