Search Results destination_cont_id




Overview
Explore in AI Chat

Overview

APPS.WSH_OPSM_ASN_ITEMS_V is a valid Oracle E-Business Suite view owned by the APPS schema, registered under FND Design Data as WSH.WSH_OPSM_ASN_ITEMS_V. It exposes line-level Advanced Shipment Notice (ASN) and delivery detail information drawn from the Oracle Shipping (WSH) module, specifically for consumption by Oracle Process Manufacturing (OPM) and Order Management integration flows. In releases 12.1.1 and 12.2.2 the view serves as a reporting and integration surface that flattens delivery, order, item, and customer attributes into a single denormalized structure suitable for external systems, concurrent programs, and BI Publisher reports.

The view is read-only and carries no DML capability. Its primary role is to present shipment line data with sufficient order and customer context to support downstream OPM supply chain processing, order status reporting, and customer-facing shipment confirmations.

Underlying Base Objects

Per documented ETRM metadata, WSH_OPSM_ASN_ITEMS_V is defined over two underlying views:

The view therefore acts as a union or consolidation layer over these two component views, presenting a merged column set that includes delivery identifiers, order references, item details, and shipping quantities. Because both parents are themselves views, any tuning or investigation of performance issues should trace through to the underlying WSH delivery detail and order line base tables rather than to this view alone.

Key Columns

The view exposes approximately thirty-six columns. The most significant include:

Common Use Cases and Queries

Typical uses include extracting shipments for a specific customer, reconciling shipped versus ordered quantities, and feeding OPM integration programs. Because SOLDTO_CUSTOMER_ID is a common search term, a representative query retrieving shipment lines for a given sold-to customer is:

  • SELECT delivery_id, delivery_detail_id, sales_order_number, item, ordered_quantity, shipped_quantity, promise_date FROM apps.wsh_opsm_asn_items_v WHERE soldto_customer_id = :p_customer_id;

Additional scenarios include filtering by ORGANIZATION_ID to isolate a warehouse, by OPSM_INTEGRATED_FLAG to find unprocessed lines, or by PROMISE_DATE range for delivery performance analysis. Joins to customer and item master tables on SOLDTO_CUSTOMER_ID and ITEM_ID respectively extend the reporting context.