Results for “shipitem_attribute_category”

17 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_STND_SHIPITEMS_V is a standard Oracle Shipping Execution (WSH) view owned by the APPS schema. It presents the shipping item details associated with a delivery, exposing line-level shipment attributes such as item, requested quantity, unit of measure, packaging, hazardous material classification, weight/volume, and descriptive flexfield context. The name and structure indicate its role as a "standalone" ship-items view used in shipping documentation, packing slip and bill-of-lading style reports, and integration extracts where delivery content must be reported without the transactional overhead of the base shipping tables.

The view is published and valid within both Oracle EBS 12.1.1 and 12.2.2. It is most frequently referenced in shipping-confirmation and shipping-document reports, and it is the object typically queried when a user searches for the column requested_qty_uom — the requested quantity and its unit of measure for a given shipped or staged delivery line.

Underlying Base Objects

The view is defined over the WSH Shipping core tables plus several reference and lookup views. The documented base objects are:

The item number is formatted using the key flexfield concatenated segments, with DECODE/SUBSTR logic keyed on the client identifier and the segment delimiter.

Key Columns

Common Use Cases and Queries

WSH_STND_SHIPITEMS_V is used for packing slip, bill-of-lading, and shipping-confirmation reports, and for integration extracts feeding external carriers or warehouse systems. A typical query joins the view to deliveries to report requested quantities per item.

  • A user seeking requested_qty_uom queries the view directly for delivery content.
  • Reports list item, requested quantity, UOM, and shipped quantity by delivery.
  • Extracts pull hazard class, freight class, and commodity code for carrier documentation.
  • Weight and volume columns drive shipment rating and manifesting.

Sample query:

SELECT si.delivery_id,
       si.item_number,
       si.requested_qty,
       si.requested_qty_uom,
       si.shipped_qty,
       si.freight_class_cat,
       si.hazard_class
FROM   apps.wsh_stnd_shipitems_v si
WHERE  si.delivery_id = :p_delivery_id
ORDER BY si.load_sequence_number;

Because the view exposes the item-number formatting, requested/shipped UOM columns, and physical measurements in a single row per delivery detail, it is a preferred reporting source over the normalized base tables when the objective is shipment-level documentation.