Search Results quote_description

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:

• ASO_QUOTE_HEADERS (synonym) — the central driving table supplying quote identity, version, status, currency, and amount columns.
• ASO_QUOTE_STATUSES_VL (view) — supplies status code, meaning, and workflow control flags such as UPDATE_ALLOWED_FLAG and AUTO_VERSION_FLAG.
• ASO_I_PRICE_LISTS_V (view) and QP_PRICE_LIST_PVT (package) — provide price list name and identifier resolution.
• ASO_I_ORDER_TYPES_V (view) — resolves the order type name associated with ORDER_TYPE_ID.
• ASO_TAX_DETAILS (synonym) — contributes tax exemption number, reason, and flag.
• HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_PARTY_SITES, HZ_CONTACT_POINTS, HZ_LOCATIONS, HZ_RELATIONSHIPS — TCA objects supplying customer party name and type, account number, header contact, and phone attributes.
• JTF_RS_SALESREPS_MO_V (synonym) — resolves the sales resource name where RESOURCE_ID is populated, otherwise the employee name is used via a DECODE expression.
• FND_TERRITORIES_VL (view) — referenced for territory descriptions tied to locations.

Key Columns

• QUOTE_HEADER_ID — primary key of the quote header; the principal join key to quote lines.
• QUOTE_NUMBER, QUOTE_NAME, QUOTE_VERSION — human-readable quote identification and revision control.
• QUOTE_STATUS_ID, STATUS_CODE, MEANING, UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG — status and workflow behavior indicators.
• EMPLOYEE_PERSON_ID, RESOURCE_ID, resource name — the owning sales representative, resolved from either the HR employee or the JTF resource.
• PARTY_ID, PARTY_NAME, PARTY_TYPE, ACCOUNT_NUMBER, CUST_ACCOUNT_ID — customer identity drawn from TCA.
• QUOTE_CATEGORY_CODE, QUOTE_SOURCE_CODE, ORIGINAL_SYSTEM_REFERENCE — classification and source system traceability.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_TYPE_CODE, EXCHANGE_RATE_DATE — currency conversion context.
• QUOTE_EXPIRATION_DATE, ORDERED_DATE, ORDER_ID, ORDER_TYPE_ID — lifecycle and order conversion references.
• TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT — monetary summary values for the header.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE — tax exemption attributes.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE) support auditing and concurrent program traceability.

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.