Search Results wsh_new_deliveries_ob_grp_v




Overview
Explore in AI Chat

Overview

WSH_NEW_DELIVERIES_OB_GRP_V is an Oracle EBS shipping execution view owned by the APPS schema in the WSH (Shipping Execution) product. The view exposes delivery-level shipping data, including planned status, delivery lifecycle status, transportation details, ASN (Advance Shipment Notice) information, weights, volumes, address references, and the full set of descriptive flexfield and global attribute columns. It presents a denormalized, read-only surface over the delivery entity and is intended for reporting, integration, and lookup purposes rather than transactional modification.

The naming convention with the _V suffix confirms this is a view, and the status is VALID in the ETRM metadata for 12.1.1 and 12.2.2. Because it exposes ASN-related columns, including ASN_STATUS_CODE, ASN_DATE_SENT, and ASN_SEQ_NUMBER, it is particularly relevant for reporting on the ASN lifecycle — the electronic transmission of shipment information to customers or trading partners.

Underlying Base Objects

The documented base object for this view is the synonym WSH_NEW_DELIVERIES, which resolves to the WSH_NEW_DELIVERIES table in the WSH schema. The view is a straightforward projection of that table: each row in WSH_NEW_DELIVERIES_OB_GRP_V corresponds to a single delivery record, identified by DELIVERY_ID. No joins or aggregations are documented in the view text, so the relationship is one-to-one with the underlying delivery table.

As a WSH-owned object, the view participates in the shipping execution data model. Downstream consumers, such as order management, inventory, and external integration programs, can query it to obtain delivery headers without needing to know the full physical structure of WSH_NEW_DELIVERIES.

Key Columns

Common Use Cases and Queries

A frequent requirement is locating deliveries whose ASN has been sent or is pending. The ASN_STATUS_CODE column supports this directly.

  • Report all deliveries with a transmitted ASN:
    SELECT delivery_id, name, status_code, asn_status_code, asn_date_sent, asn_seq_number FROM apps.wsh_new_deliveries_ob_grp_v WHERE asn_status_code = 'SENT';
  • Identify deliveries awaiting ASN transmission:
    SELECT delivery_id, name, waybill, customer_id FROM apps.wsh_new_deliveries_ob_grp_v WHERE asn_status_code IS NULL AND status_code = 'CLOSED';
  • Extract shipment weight and volume for freight analysis:
    SELECT delivery_id, gross_weight, net_weight, weight_uom_code, volume, volume_uom_code FROM apps.wsh_new_deliveries_ob_grp_v WHERE planned_flag = 'Y';
  • Review ASN activity over a date range:
    SELECT delivery_id, name, asn_status_code, asn_date_sent FROM apps.wsh_new_deliveries_ob_grp_v WHERE asn_date_sent >= :from_date AND asn_date_sent < :to_date ORDER BY asn_date_sent;

Because the view is defined over WSH_NEW_DELIVERIES, it can also be joined to delivery detail tables such as WSH_DELIVERY_ASSIGNMENTS and WSH_DELIVERY_DETAILS using DELIVERY_ID to reconcile header-level ASN and status information with line-level packing data.