Search Results freight_class_cat




Overview
Explore in AI Chat

Overview

APPS.WSH_ITM_SHIPITEMS_V is a shipping-execution view owned by the APPS schema and registered under FND Design Data as WSH.WSH_ITM_SHIPITEMS_V. It presents item-level shipping (ship item) detail consolidated from delivery, delivery-detail, and item master sources, exposing one row per shippable line item within a delivery. The view is classified as an internal Oracle view: Oracle Corporation does not support direct data access through this object except from standard Oracle Applications programs. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

The view is principally consumed by Oracle Shipping Execution, Transportation Management (OTM/ETRM integration), and downstream documents such as packing slips, bills of lading, commercial invoices, and export documentation. Because it joins item attributes (freight classification, hazard class, country of origin, commodity code) to delivery lines, it serves as the item-attribute enrichment layer between raw delivery data and printed/transmitted shipping documents. The user query term freight_class_cat corresponds to the FREIGHT_CLASS_CAT column exposed directly by this view.

Underlying Base Objects

According to the documented view metadata (ETRM 12.2.2), WSH_ITM_SHIPITEMS_V is defined over the following base objects:

Key Columns

The view exposes item identity, quantity, classification, and delivery key columns. Notable examples include:

Common Use Cases and Queries

Typical uses include freight rating extracts, export/customs documentation, hazmat reporting, and reconciling shipped versus ordered quantities. Because the object is internal, queries should be restricted to reporting and read-only diagnostics.

Example — items with their freight classification for a given delivery:

SELECT d.delivery_id, s.item_number, s.freight_class_cat, s.hazard_class, s.country_of_origin, s.shipped_qty FROM apps.wsh_itm_shipitems_v s, apps.wsh_new_deliveries d WHERE s.delivery_id = d.delivery_id AND s.org_id = :org_id;

Example — aggregate net weight and volume by freight class:

SELECT freight_class_cat, SUM(net_weight) net_wt, SUM(volume) vol FROM apps.wsh_itm_shipitems_v WHERE org_id = :org_id GROUP BY freight_class_cat;

Example — hazmat shipments on a delivery:

SELECT item_number, hazard_class FROM apps.wsh_itm_shipitems_v WHERE hazard_class IS NOT NULL AND delivery_id = :delivery_id;