Results for “wsh_pack_slip_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_PACK_SLIP_V is a shipping execution view owned by the APPS schema in Oracle E-Business Suite. It is documented in ETRM for both release 12.1.1 and 12.2.2 with a status of VALID. The view presents the set of standard outbound deliveries that are still pending pack slip printing. Rather than exposing all delivery records held in the shipping tables, it filters the population to those deliveries that have an associated pack-type document instance whose final print date has not yet been recorded. As a result, the view functions as a lightweight "pack slip print queue" — a reporting and integration surface that isolates work awaiting pack slip generation from the broader delivery dataset.

Its role in Oracle EBS reporting and integration is that of a convenience abstraction. Instead of requiring report authors, concurrent programs, or external integrations to join the delivery header table to the document instance table and replicate a consistent set of filter predicates, the view encapsulates that logic once. Consumers simply query WSH_PACK_SLIP_V and receive the qualifying delivery identifiers, names, and organizations.

Underlying Base Objects

The documented base objects for this view are WSH_NEW_DELIVERIES and WSH_DOCUMENT_INSTANCES, both referenced through synonyms in the APPS schema. WSH_NEW_DELIVERIES supplies the delivery header information, while WSH_DOCUMENT_INSTANCES supplies the printing and document-type state. The view joins the two on DELIVERY_ID = ENTITY_ID, with the document instance restricted to entity name 'WSH_NEW_DELIVERIES'.

The populated view text applies a specific predicate set. Deliveries are excluded when STATUS_CODE equals 'CA' (cancelled). The associated document instance must have FINAL_PRINT_DATE IS NULL and DOCUMENT_TYPE = 'PACK_TYPE'. The delivery must be outbound in direction, expressed as NVL(SHIPMENT_DIRECTION, 'O') IN ('O', 'IO'), and the delivery type must be 'STANDARD'. The join and filters together yield only open, standard, outbound deliveries whose pack slip has never been finally printed.

Key Columns

• DELIVERY_ID — The unique identifier of the delivery, sourced from DEL.DELIVERY_ID. This is the primary join key to WSH_NEW_DELIVERIES and related shipping tables.
• DELIVERY_NAME — The user-visible delivery name (DEL.NAME), used for display, label printing, and cross-referencing in shipping reports.
• ORGANIZATION_ID — The inventory organization that owns the delivery, from DEL.ORGANIZATION_ID. This column supports multi-org reporting and is typically constrained via the MO: Operating Unit or inventory organization security context.

Common Use Cases and Queries

The primary use case is identifying deliveries still requiring pack slip printing. A typical query returns the pending print workload for an organization:

• SELECT delivery_id, delivery_name, organization_id FROM wsh_pack_slip_v WHERE organization_id = :org_id;
• SELECT COUNT(*) FROM wsh_pack_slip_v WHERE organization_id = :org_id;

A second scenario joins the view back to delivery detail tables to produce a printable manifest of unprinted deliveries for a picking or packing station. A third scenario uses the view as a driver for integrations or concurrent programs that must process only those deliveries not yet marked with a final print date, avoiding duplicate pack slip generation.

Because the view contains no date or status column beyond the delivery identifier, name, and organization, consumers requiring delivery dates, ship-to addresses, or line detail must join to WSH_NEW_DELIVERIES or the associated delivery detail views on DELIVERY_ID. It is also worth noting that the view reflects delivery-level document state; once FINAL_PRINT_DATE is populated in WSH_DOCUMENT_INSTANCES, the row exits the view automatically. This self-clearing behavior makes the view suitable for repetitive polling without additional purge logic.