Search Results delivery_name




Overview
Explore in AI Chat

Overview

The view WSH_PACKED_CONTAINERS_DPW_V is an APPS-owned database object in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It is categorized under the OE (Order Entry) product family and is described as "Containers for Departure Planning Workbench." The view is currently documented with a status of VALID and resides in the APPS schema, which is the standard repository for shared, pre-built query objects used across EBS modules.

Functionally, this view consolidates packed container information associated with deliveries and their corresponding planned departures. It serves as a reporting and integration layer for the Departure Planning Workbench (DPW), a logistics-focused feature within Oracle Shipping Execution (part of the Order Management suite). By joining packed container records with delivery, departure, and item master data, the view provides a denormalized, query-optimized snapshot suitable for operational reporting, data extraction, and downstream integration. The prominent exposure of the DEPARTURE_NAME column makes the view particularly useful for users searching for shipment departure identifiers, which was the apparent motive behind the user's search.

Underlying Base Objects

The view is defined over four documented synonymous base objects:

  • WSH_PACKED_CONTAINERS (SYNONYM) — The primary transaction table holding individual container records linked to deliveries.
  • WSH_DELIVERIES (SYNONYM) — Stores delivery header information, including the delivery name and the link to a planned departure.
  • WSH_DEPARTURES (SYNONYM) — Contains departure header definitions, providing the departure name referenced by the delivery.
  • MTL_SYSTEM_ITEMS (SYNONYM) — The item master, supplying container descriptions and unit-of-measure codes for the inventory item used as the container.

The join logic, as evidenced by the documented view text, connects WSH_DELIVERIES to WSH_PACKED_CONTAINERS on DELIVERY_ID, links MTL_SYSTEM_ITEMS to the container on both INVENTORY_ITEM_ID and ORGANIZATION_ID, and attaches WSH_DEPARTURES to the delivery via an outer join (WDP.DEPARTURE_ID (+) = WDL.PLANNED_DEPARTURE_ID). This outer join ensures that deliveries without an assigned planned departure are still returned, with null departure values.

Key Columns

The view exposes nine columns that collectively describe packed containers and their logistics context:

  • CONTAINER_ID — Primary identifier for the packed container record.
  • DEPARTURE_ID — The planned departure identifier, sourced from WDL.PLANNED_DEPARTURE_ID.
  • DEPARTURE_NAME — The human-readable name of the departure, taken from WDP.NAME. This is the column most directly relevant to the user's search term.
  • DELIVERY_ID — Identifier of the delivery to which the container belongs.
  • DELIVERY_NAME — The descriptive name of the delivery.
  • CONTAINER_INVENTORY_ITEM_ID — Inventory item identifier representing the container itself.
  • CONTAINER_DESCRIPTION — Item description of the container, from MSI.DESCRIPTION.
  • QUANTITY — Quantity of the container (or its contents) captured on the packed container record.
  • UOM_CODE — Unit of measure for the quantity, from MSI.PRIMARY_UOM_CODE.

Common Use Cases and Queries

Typical use cases include departure planning reports, container manifest extraction, and integration feeds into warehouse or transportation systems. A frequent requirement is to list all containers associated with a specific departure name:

  • SELECT CONTAINER_ID, DEPARTURE_NAME, DELIVERY_NAME, CONTAINER_DESCRIPTION, QUANTITY, UOM_CODE
  • FROM APPS.WSH_PACKED_CONTAINERS_DPW_V
  • WHERE DEPARTURE_NAME = :p_departure_name;

Because the underlying join uses an outer join to WSH_DEPARTURES, rows with a null DEPARTURE_NAME represent containers on deliveries not yet assigned to a departure. Analysts should account for this when filtering, using WHERE DEPARTURE_NAME IS NULL to identify unassigned containers, or including an IS NOT NULL predicate to focus solely on planned departures.