Search Results aso_pvt_quote_headers_v




Overview
Explore in AI Chat

Overview

ASO_PVT_QUOTE_HEADERS_V is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the ASO - Order Capture (Advanced Pricing and Quoting) product family. It exposes a flattened, presentation-ready image of quote header information sourced primarily from ASO_QUOTE_HEADERS, enriched through joins to customer, contact, pricing, tax, and sales resource entities. Because it consolidates attributes that would otherwise require numerous joins across the TCA (Trading Community Architecture), pricing, and quoting schemas, the view is well suited for use in concurrent reports, BI Publisher data templates, Discoverer workbooks, and inbound/outbound integration queries that must retrieve quote header context in a single pass.

The view carries the "_PVT" naming convention, indicating it is a private implementation object supporting the Order Capture quoting engine and its associated public views and APIs. While it is a valid database object, Oracle does not document it as a supported public interface, so direct dependencies should be carefully managed across patches and upgrades. The object is present and valid in both EBS 12.1.1 and 12.2.2, with the 12.2.2 metadata confirming the same structure and referenced base objects.

Underlying Base Objects

The documented 12.2.2 metadata identifies the following referenced objects underpinning the view:

Key Columns

Common Use Cases and Queries

Typical scenarios include listing open quotes with customer names, extracting expired quotes for follow-up, reconciling quote totals against orders, and feeding quotation data to external CRM or analytics platforms.

Sample query — active quotes with customer and status:

  • SELECT quote_number, quote_name, party_name, account_number, meaning AS status, total_adjusted_amount FROM aso_pvt_quote_headers_v WHERE org_id = :p_org_id AND meaning = 'Active';

Sample query — quotes by sales resource and currency:

  • SELECT quote_number, quote_version, resource_id, currency_code, quote_expiration_date FROM aso_pvt_quote_headers_v WHERE resource_id = :p_resource_id ORDER BY quote_expiration_date;

Sample query — tax-exempt quotes converted to orders:

  • SELECT quote_number, account_number, order_id, tax_exempt_number FROM aso_pvt_quote_headers_v WHERE tax_exempt_flag = 'Y' AND order_id IS NOT NULL;

Because the view joins multiple TCA and pricing objects, queries should filter on ORG_ID and indexed keys such as QUOTE_HEADER_ID or CUST_ACCOUNT_ID to control execution cost, and downstream code should be validated against Oracle's supported ASO public views where upgrade safety is a requirement.