Search Results master_container_item_id




Overview
Explore in AI Chat

Overview

WSH_DSNO_ITEM_DETAILS_V is a Shipping Execution (WSH) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is designed to present item-level details for delivery assignments in a format suitable for Distributed Shipping Order (DSNO) and outbound logistics processing. The view flattens the relationship between a delivery assignment header, the underlying delivery detail line, and its associated serial number records, exposing quantities, serial number ranges, lot and revision information, and the full set of descriptive flexfield columns inherited from WSH_DELIVERY_DETAILS. Because it is a view rather than a table, it does not store data; it provides a read-only, denormalized projection over the Shipping Execution base objects that simplifies querying and integration for downstream consumers. The view is registered as VALID in the ETRM metadata for 12.2.2.

Underlying Base Objects

The view text joins three primary sources. WSH_DELIVERY_ASSIGNMENTS (referenced via the WSH_DELIVERY_ASSIGNMENTS_V view) supplies the delivery assignment identifier and the parent delivery detail identifier used to resolve the container instance. WSH_DELIVERY_DETAILS supplies the delivery detail identifier, container item references, lot number, revision, quantity, and the descriptive flexfield attribute columns. WSH_SERIAL_NUMBERS supplies the from and to serial number ranges and the quantity that overrides the shipped quantity when present. A fourth synonym, WMS_EPC, is documented as a referenced base object, reflecting the integration between Shipping Execution and Warehouse Management EPC (Electronic Product Code) data. Where serial number data exists in WSH_SERIAL_NUMBERS, the NVL logic in the view prefers it; otherwise the delivery detail values are used.

Key Columns

Common Use Cases and Queries

This view is typically queried to report shipped item details and serial number ranges for a delivery, to reconcile outbound serialized inventory, and to feed downstream systems such as distributed shipping order interfaces. A representative query retrieving serial ranges for a delivery is:

  • SELECT delivery_id, delivery_detail_id, from_serial_number, to_serial_number, shipped_quantity, lot_number, revision FROM apps.wsh_dsno_item_details_v WHERE delivery_id = :p_delivery_id;
  • SELECT delivery_detail_id, from_serial_number, to_serial_number FROM apps.wsh_dsno_item_details_v WHERE from_serial_number = :p_serial;
  • SELECT dd_attribute1, dd_tp_attribute1, shipped_quantity FROM apps.wsh_dsno_item_details_v WHERE delivery_assignment_id = :p_assignment_id;

Because the view resolves serial numbers through WSH_SERIAL_NUMBERS with delivery detail fallback, it is the preferred source when both consolidated and detail-level serial tracking must be reported consistently across the Shipping Execution module.