Search Results pack_type




Overview
Explore in AI Chat

Overview

APPS.WSH_PACK_SLIP_V is a reporting view in the Oracle E-Business Suite Shipping (WSH) module that identifies deliveries for which a packing slip document exists but has not yet been printed. The view returns a concise list of delivery identifiers, delivery names, and the associated organization, filtered to only those deliveries whose packing slip has never been submitted to a final print run. Its central role is to support the packing slip printing process, whereby the Shipping module and concurrent programs must discover which eligible deliveries still require a printed document.

In Oracle EBS 12.1.1 and 12.2.2, this view is owned by the APPS schema and is typically referenced by printing concurrent programs, custom reports, and integrations that need to enumerate outstanding packing slip work. Because it surfaces only deliveries that are not yet finally printed, it functions as a work-queue view rather than a historical listing of all shipments. The reference to PACK_TYPE in WSH_DOCUMENT_INSTANCES is the mechanism that restricts results to packing slip document instances specifically, distinguishing them from other document types such as bills of lading or commercial invoices.

Underlying Base Objects

The view is defined over two base objects, both accessed through APPS synonyms:

  • WSH_NEW_DELIVERIES (alias DEL) — the primary delivery header table holding delivery identity, status, direction, and type.
  • WSH_DOCUMENT_INSTANCES (alias DOC) — the document instance table that records each generated document, its document type, entity reference, and final print date.

The join is established on DEL.DELIVERY_ID = DOC.ENTITY_ID, with the additional constraint DOC.ENTITY_NAME = 'WSH_NEW_DELIVERIES' ensuring the document instance belongs to a delivery header. The view applies an inner join, so only deliveries that actually have a matching document instance are returned.

Key Columns

  • DELIVERY_ID — The unique identifier of the delivery, sourced from WSH_NEW_DELIVERIES and matched to the document entity.
  • DELIVERY_NAME — The user-visible delivery name (DEL.NAME), used for identification in reports and print output.
  • ORGANIZATION_ID — The inventory organization that owns the delivery, enabling multi-org filtering and reporting.

Although not projected as columns, the view's filter predicates carry important meaning: STATUS_CODE != 'CA' excludes cancelled deliveries; FINAL_PRINT_DATE IS NULL restricts to unprinted documents; DOCUMENT_TYPE = 'PACK_TYPE' isolates packing slips; SHIPMENT_DIRECTION in ('O','IO') limits results to outbound and internal outbound movements; and DELIVERY_TYPE = 'STANDARD' excludes non-standard delivery types.

Common Use Cases and Queries

Typical uses include concurrent print processing, operational dashboards for outstanding packing slips, and interfaces that reconcile unprinted shipping documents.

A simple query listing unprinted standard outbound packing slips:

  • SELECT delivery_id, delivery_name, organization_id FROM apps.wsh_pack_slip_v WHERE organization_id = :org_id;

Counting outstanding packing slips per organization:

  • SELECT organization_id, COUNT(*) FROM apps.wsh_pack_slip_v GROUP BY organization_id;

Joining to delivery details for operational reporting:

  • SELECT v.delivery_name, d.status_code FROM apps.wsh_pack_slip_v v, apps.wsh_new_deliveries d WHERE v.delivery_id = d.delivery_id;

Because the view already applies all eligibility filters, consumers should avoid re-implementing the PACK_TYPE and final-print-date logic in parallel queries; doing so risks divergence from the Shipping module's own print selection criteria.