Search Results wsh_new_deliveries_v




Overview
Explore in AI Chat

Overview

WSH_NEW_DELIVERIES_V is a shipping execution view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents delivery header information from the Shipping Execution module (WSH) in a form suitable for concurrent programs, reports, and outbound integrations. The view is documented as VALID in the ETRM and is closely related to the WSH_NEW_DELIVERIES base entity, from which it draws the bulk of its delivery-level attributes.

In the documented view text, the first three select list positions return TO_NUMBER(NULL), indicating that the view exposes placeholder numeric columns that reinforce a fixed, legacy interface contract. Because the view is a customization and integration surface rather than a transactional table, it is typically referenced by name in SQL that must remain stable across patches. Its role is therefore to project a consistent set of delivery header attributes—identification, status, locations, weights, and descriptive flexfield data—while joining to lookup descriptions for translated status meanings.

Underlying Base Objects

The ETRM metadata lists two referenced base objects: WSH_LOOKUPS (VIEW) and WSH_NEW_DELIVERIES (SYNONYM). WSH_NEW_DELIVERIES is the synonym through which the physical delivery header table is accessed; WSH_NEW_DELIVERIES_V selects its columns using the alias D and adds a lookup join to obtain the decoded status meaning.

  • WSH_NEW_DELIVERIES (SYNONYM) — source of all delivery header columns such as DELIVERY_ID, NAME, STATUS_CODE, and the flexfield segments.
  • WSH_LOOKUPS (VIEW) — joined via the alias WL to resolve lookup codes, most visibly WL.MEANING for the delivery STATUS_CODE.

The view is a direct projection with a single lookup decode, so its row cardinality matches the underlying delivery rows for the queried organization and status range.

Key Columns

Common Use Cases and Queries

The view supports delivery status reporting, ASN monitoring, weight and volume analysis, and interfaces that require decoded status text and flexfield values. Typical queries filter by ORGANIZATION_ID, STATUS_CODE, or a date range on INITIAL_PICKUP_DATE or CONFIRM_DATE.

  • Open deliveries by organization: select DELIVERY_ID, NAME, STATUS_CODE, MEANING from WSH_NEW_DELIVERIES_V where ORGANIZATION_ID = :org and STATUS_CODE not in ('CL','CA').
  • ASN status review: select DELIVERY_ID, ASN_STATUS_CODE, ASN_DATE_SENT, ASN_SEQ_NUMBER from WSH_NEW_DELIVERIES_V where ASN_DATE_SENT is not null.
  • Weight and volume audit: select DELIVERY_ID, GROSS_WEIGHT, NET_WEIGHT, WEIGHT_UOM_CODE, VOLUME, VOLUME_UOM_CODE from WSH_NEW_DELIVERIES_V where ORGANIZATION_ID = :org.
  • Flexfield extraction: select DELIVERY_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, TP_ATTRIBUTE1, GLOBAL_ATTRIBUTE1 from WSH_NEW_DELIVERIES_V where DELIVERY_ID = :delivery_id.

Because the view is read-only and based on delivery headers alone, joins to delivery details are required to report line or item-level content.