Search Results packed_quantity




Overview
Explore in AI Chat

Overview

WSHBV_CONTAINERS is an APPS-owned, read-only database view in the Oracle E-Business Suite WSH (Shipping Execution) product. It is a Business View (hence the "BV" prefix) designed to expose container-level packing information for deliveries. In Oracle Shipping Execution, a container is a logical or physical unit used to group packed items—such as a carton, pallet, or LPN—that has been associated with a delivery detail of type container. WSHBV_CONTAINERS presents one row per container, combining attributes from the container's delivery detail record with its parent delivery assignment, item master, and locator information.

The view is frequently referenced in shipping reports, packing lists, and integration extracts where consumers need to query packed contents and container hierarchies without navigating the full WSH_DELIVERY_DETAILS model. It is important to note that the view is defined WITH READ ONLY, so it is intended purely for selection; inserts, updates, and deletes are not supported.

Underlying Base Objects

WSHBV_CONTAINERS is defined over four documented base objects, all referenced through APPS synonyms in the ETRM 12.2.2 metadata:

A security predicate (_SEC:WDD.ORGANIZATION_ID IS NOT NULL) and two key flexfield descriptors (_KF:INV:MTLL:MIL and _KF:INV:MSTK:MSI) are embedded in the view text, enforcing organization-level security and exposing descriptive flexfield contexts for the locator and item segments.

Key Columns

The view returns 27 columns. Significant columns include:

Common Use Cases and Queries

Typical uses include packing list generation, container hierarchy reporting, and integration extracts into WMS or freight systems. A common query retrieving packed quantities by delivery:

  • SELECT container_id, delivery_id, packed_quantity, container_name, fill_percent FROM apps.wshbv_containers WHERE delivery_id = :p_delivery_id;
  • SELECT container_id, parent_container_id, container_type_code FROM apps.wshbv_containers WHERE organization_id = :p_org_id ORDER BY parent_container_id;
  • SELECT c.container_id, c.packed_quantity, c.lot_number, c.serial_number FROM apps.wshbv_containers c WHERE c.container_id = :p_container_id;

Because the view exposes PACKED_QUANTITY directly from REQUESTED_QUANTITY, it is a convenient reporting layer for validating that packed contents reconcile with shipped quantities, without requiring joins back to WSH_DELIVERY_DETAILS. Organizations should apply the appropriate ORG_ID bind to respect the view's embedded security predicate.