Search Results i_cust_parties




Overview
Explore in AI Chat

Overview

APPS.ASO_PVT_SHIPMENTS_V is a reporting and integration view in the Oracle EBS Order Capture (ASO) module. It presents shipment-level records from the ASO_SHIPMENTS table enriched with customer, party site, and address attributes drawn from the Oracle Trading Community Architecture (TCA) and FND reference data. The view is prefixed "PVT," which in Oracle Applications convention typically denotes a private or internal object; nevertheless, it is exposed under the APPS schema and is frequently reached by custom reports, extracts, and interfaces that need a denormalized shipment record without hand-joining TCA tables. Its role is to supply quote-to-order shipping data—promise dates, schedule ship dates, ship-to party and site, freight and FOB terms, reserved quantities, and flexible attribute columns—together with resolved customer names, account numbers, and shipping addresses.

The view is documented in ETRM under Oracle EBS 12.2.2 metadata (owner APPS) and is equally applicable to 12.1.1, since the underlying ASO, HZ, and FND objects share compatible structures across both releases. Interest in this view commonly arises when searching for the i_cust_parties alias, which is the HZ_PARTIES join that resolves the ship-to customer name and customer type.

Underlying Base Objects

The view is defined over the following documented base objects:

Because the view joins TCA entities, its output reflects the current state of customer and address records rather than a historical snapshot.

Key Columns

Common Use Cases and Queries

Typical uses include quote-to-order shipment extracts, customer-facing delivery reporting, freight and logistics analysis, and data migration validation. A sample query resolving customer details through the i_cust_parties join is shown below.

SELECT s.shipment_id,
       s.quote_header_id,
       s.schedule_ship_date,
       s.customer_name,
       s.customer_type,
       s.customer_account_number,
       s.ship_to_city,
       s.ship_to_country,
       s.quantity,
       s.reserved_quantity
FROM   apps.aso_pvt_shipments_v s
WHERE  s.ship_to_cust_party_id IS NOT NULL
  AND  s.schedule_ship_date >= TRUNC(SYSDATE)
ORDER BY s.schedule_ship_date;

To aggregate shipment volume by customer type and territory, the view can be grouped directly on customer_type and ship_to_country. Because the view exposes no organization or operating unit filter, results should be constrained by quote or order identifiers where multi-org isolation is required. As with all "PVT" objects, Oracle does not guarantee the view definition across patches or upgrades, so it should be used advisedly for read-only reporting and validated against release-specific documentation.