Search Results wsh_packing_slips_db_v




Overview
Explore in AI Chat

Overview

The WSH_PACKING_SLIPS_DB_V view is a Shipping Execution (WSH) database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes packing slip document instances — the generated, printable packing slip records associated with outbound deliveries — in a denormalized form that joins document instance data to delivery header and delivery leg attributes. The view is a reporting and integration convenience layer: rather than requiring callers to manually join the document instance table to the delivery and delivery-leg tables, it pre-composes those relationships into a single, queryable projection. Because it is a view (Object Type: VIEW, Status: VALID), it carries no independent storage; all data is materialized at query time from its base objects. This makes it suitable for read-only reporting, custom concurrent programs, BI Publisher data sources, and inbound/outbound interface queries that need packing slip context alongside delivery details.

Underlying Base Objects

Per the ETRM metadata, the view is defined over three base objects, all referenced through APPS synonyms:

  • WSH_DOCUMENT_INSTANCES — the driving table supplying the packing slip document instance, its sequence number, status, and final print date.
  • WSH_NEW_DELIVERIES — the delivery header supplying shipment direction, delivery type, delivery name, and description.
  • WSH_DELIVERY_LEGS — the delivery leg supplying proof-of-delivery (POD) attributes; joined with an outer (+) in the view definition, so deliveries without a matching leg still return rows.

The join condition ties the document instance to the delivery via WDI.ENTITY_ID = WND.DELIVERY_ID, filters ENTITY_NAME = 'WSH_NEW_DELIVERIES' and DOCUMENT_TYPE = 'PACK_TYPE', excludes cancelled instances, restricts shipment direction to outbound or internal outbound ('O', 'IO'), and limits to standard deliveries.

Key Columns

  • ROWID / ROWI_ID — pseudo-column alias for the underlying document instance row; used for row identification.
  • DOCUMENT_INSTANCE_ID — primary identifier of the packing slip document instance.
  • PACKING_SLIP_NUMBER — the human-readable packing slip number exposed for reporting.
  • STATUS / FINAL_PRINT_DATE — lifecycle state of the packing slip and the timestamp of its final print.
  • ENTITY_NAME / ENTITY_ID — the associated entity (WSH_NEW_DELIVERIES) and delivery identifier.
  • DELIVERY_ID / DELIVERY_NAME / DESCRIPTION — delivery header context, including the delivery name used on documents.
  • POD_FLAG / POD_BY / POD_DATE — proof-of-delivery indicators sourced from the delivery leg.
  • REASON_OF_TRANSPORT — transport reason from the delivery header.

Common Use Cases and Queries

Typical scenarios include reconciling printed packing slips against shipped deliveries, building a packing slip register for a given date range, and feeding downstream label or manifest integrations. A representative query listing unprinted packing slips for a delivery is shown below.

  • SELECT packing_slip_number, delivery_name, status, final_print_date FROM apps.wsh_packing_slips_db_v WHERE delivery_id = :p_delivery_id;
  • SELECT packing_slip_number, delivery_name, pod_flag, pod_date FROM apps.wsh_packing_slips_db_v WHERE final_print_date BETWEEN :p_from AND :p_to ORDER BY final_print_date;

Because the view filters to outbound standard deliveries and non-cancelled packing slips, it should not be used to report on inbound shipments or on cancelled document instances; query the base WSH_DOCUMENT_INSTANCES table directly for those cases.