Search Results pos_asn_review_shipments_v




Overview
Explore in AI Chat

Overview

The POS_ASN_REVIEW_SHIPMENTS_V view is an Oracle iProcurement (ICX) reporting object owned by the APPS schema. It presents Advance Shipment Notice (ASN) line details submitted by suppliers through the iProcurement supplier portal, enriching each shipment line with purchasing, receiving, tax, freight, and location context. Its primary role is to support the "Review ASN" pages and related reporting flows where buyers and administrators inspect shipment notices prior to receipt.

The view is central to any inquiry that must reconcile an ASN line against its originating purchase order shipment. In particular, it exposes the purchase order shipment number through the PLL.SHIPMENT_NUM column, derived from PO_LINE_LOCATIONS. This makes the view directly relevant to searches involving po_shipment_num, since it bridges the ASN shop cart data and the PO shipment numbering scheme. The object's status is VALID and it is documented for both 12.1.1 and 12.2.2 releases, with the 12.2.2 metadata confirming the same APPS ownership and base object set.

Underlying Base Objects

The view is defined over eleven documented base objects. The driving table is POS_ASN_SHOP_CART_DETAILS (aliased ASND), which holds the supplier-entered ASN lines. It is joined to the purchasing tables PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, and, through an outer join, PO_RELEASES. The join keys are PO_LINE_LOCATION_ID and PO_HEADER_ID/PO_LINE_ID, linking each ASN line to its PO shipment.

Most secondary joins are outer joins (denoted by (+)), ensuring ASN lines remain visible even when freight, reason, tax, or territory data is absent.

Key Columns

Common Use Cases and Queries

Typical scenarios include buyer review of incoming ASNs, shipment reconciliation to PO shipments, and freight/tax auditing. A representative query retrieving shipment number and shipped quantity is:

SELECT asn_line_id, shipment_num, po_line_location_id,
       quantity_shipped, expected_receipt_date
FROM   apps.pos_asn_review_shipments_v
WHERE  shipment_num = :po_shipment_num;

The view may also be aggregated for shipment receipt summaries or joined back to purchasing tables for reconciliation reports.