Search Results ship_set_id




Overview
Explore in AI Chat

Overview

WSH_SS_SHIPITEMS_V is a Shipping Execution (WSH) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a flattened, denormalized projection of shipping line detail, combining delivery detail attributes, item master descriptions, category set classifications, hazard information, serial number ranges, and delivery-level identifiers into a single row per shipment item. The view is intended primarily for reporting, label printing, and external integration scenarios such as carrier manifests, packing slips, and advanced shipment notification (ASN) extracts, where consumers require a consolidated shipping line record without joining the underlying WSH tables directly.

Because the view already resolves item concatenated segments, customer item numbers, category set names, and decoded priority codes, it is frequently used as a data source for BI Publisher reports, custom concurrent programs, and interface tables feeding warehouse management or transportation systems. All database objects referenced reside in the APPS schema, and the view is marked VALID in the data dictionary.

Underlying Base Objects

The view is defined over the following documented base objects: MTL_SYSTEM_ITEMS_KFV (synonym), MTL_CUSTOMER_ITEMS (synonym), MTL_CATEGORY_SETS_VL (view), PO_HAZARD_CLASSES_VL (view), WSH_DELIVERY_DETAILS (synonym), WSH_DELIVERY_ASSIGNMENTS (synonym), WSH_NEW_DELIVERIES (synonym), and WSH_SERIAL_NUMBERS (synonym).

WSH_DELIVERY_DETAILS supplies the core shipping line columns, including requested quantity, shipped quantity, weight, volume, lot and serial attributes, tolerances, attributes, and the material transaction identifiers. WSH_DELIVERY_ASSIGNMENTS links each delivery detail to its parent delivery, providing DELIVERY_ID and PARENT_DELIVERY_DETAIL_ID. WSH_NEW_DELIVERIES contributes delivery context, while WSH_SERIAL_NUMBERS resolves from/to serial number ranges via the NVL expressions on FM_SERIAL_NUMBER and TO_SERIAL_NUMBER. MTL_SYSTEM_ITEMS_KFV provides the concatenated item segment (ITEM_NUMBER). MTL_CUSTOMER_ITEMS supplies the customer-specific item number, and MTL_CATEGORY_SETS_VL is joined twice to resolve the freight class and commodity code category set names. PO_HAZARD_CLASSES_VL supplies hazard classification data.

Key Columns

Common Use Cases and Queries

Typical usage includes freight classification reporting, hazmat compliance extracts, and packing slip data retrieval. A representative query filters shipment items by freight class and delivery:

  • SELECT d.delivery_id, d.item_number, d.freight_class_cat, d.hazard_class, d.shipped_qty FROM apps.wsh_ss_shippitems_v d WHERE d.freight_class_cat = 'FREIGHT_CLASS';
  • Freight rating extracts often select VOLUME, NET_WEIGHT, and their UOM codes alongside COUNTRY_OF_ORIGIN for duty calculation.
  • Serial-controlled items are reported using FROM_SERIAL_NUMBER and TO_SERIAL_NUMBER to document shipped serial ranges.

Because the view performs the joins across delivery, assignment, item, category, and hazard sources, consumers avoid replicating complex WSH join logic. Grounding queries on DELIVERY_ID and DELIVERY_DETAIL_ID remains the most reliable access pattern.