Search Results sublot_number




Overview
Explore in AI Chat

Overview

WSH_ITM_SHIPITEMS_V is an Oracle E-Business Suite view owned by the APPS schema within the Shipping Execution (WSH) product. According to its documented description, it functions as a temporary presentation object that returns the contents of the base view WSH_SS_SHIPITEMS_V together with dummy records. This design pattern exists to prevent data retrieval problems when the underlying data set is consumed through Oracle XML SQL Utility (XSU), which can fail or produce inconsistent output when a result set returns zero rows or is otherwise unbounded. By injecting placeholder rows, the view guarantees that XSU-based integrations and reporting layers always receive a well-formed result structure.

The view is most commonly encountered in shipping documentation, delivery detail reporting, and XML-based outbound interfaces where shipment line attributes — item numbers, quantities, lots, serials, and freight classifications — must be extracted in a stable format. The presence of the SUBLOT_NUMBER column makes this view particularly relevant to environments handling lot and sublot controlled inventory, including process manufacturing and regulated supply chains.

Underlying Base Objects

The documented base objects referenced by WSH_ITM_SHIPITEMS_V span several schemas and object types:

The view joins these objects on delivery detail identifiers, inventory item identifiers, and customer associations to produce a denormalized shipping line record suitable for external consumption.

Key Columns

Common Use Cases and Queries

The view is typically queried for shipment documentation, label generation, and XML extracts. A representative query filtering by sublot, the term most often searched, follows:

  • Retrieving shipment lines for a specific delivery: SELECT item_number, lot_number, sublot_number, shipped_qty FROM wsh_itm_shipitems_v WHERE delivery_id = :p_delivery_id;
  • Identifying sublot-controlled shipments: SELECT delivery_detail_id, item_number, lot_number, sublot_number FROM wsh_itm_shipitems_v WHERE sublot_number IS NOT NULL;
  • Extracting backordered quantities for customer notification: SELECT item_number, ordered_qty, shipped_qty, backordered_qty FROM wsh_itm_shipitems_v WHERE backordered_qty > 0;

Because the view includes dummy records for XSU stability, consumers should filter on valid delivery detail identifiers and exclude placeholder rows where aggregations are performed.