Search Results quote_total

Overview

The ASO_I_QUOTE_HEADERS_BALI_V view is a reporting and integration interface object within the Oracle E-Business Suite Order Capture (ASO) module. It resides in the APPS schema and is provided for the Oracle iStore and Oracle Quoting (BALI) integration layer, presenting a denormalized, user-facing projection of quote header information. In EBS 12.1.1 and 12.2.2, the view serves as a stable, read-only data source that surfaces quote-level attributes — including the quote total, status, customer account, contact, currency, and sales resource — in a single row per quote header. Rather than exposing the raw multi-organization structure of ASO_QUOTE_HEADERS_ALL, the view flattens the relevant business fields and applies the required operating-unit and language security predicates, making it suitable for reports, concurrent programs, and external integration consumers that require a clean, joined quote summary without authoring their own joins across ASO and Trading Community Architecture (TCA) tables.

Underlying Base Objects

The documented ETRM metadata identifies ASO_QUOTE_HEADERS_ALL (accessed via synonym) and HR_OPERATING_UNITS (view) as referenced base objects. The view definition itself joins ASO_QUOTE_HEADERS_ALL QTE to ASO_QUOTE_STATUSES_VL STA on QUOTE_STATUS_ID, and further joins to HZ_CUST_ACCOUNTS ACCT on CUST_ACCOUNT_ID, to ASO_PVT_PARTIES_V APP and ASO_PVT_PARTY_RLTN_V APPR for party and contact resolution, and to JTF_RS_SRP_VL SRP for the sales resource name. Multi-organization and language access are enforced through the standard USERENV('CLIENT_INFO') predicates on ORG_ID, and the status join is constrained by effective dates using TRUNC(SYSDATE) between the status effective start and end dates. All non-mandatory joins (customer account, party, resource) are outer joins, preserving the quote header row even when the associated master data is absent.

Key Columns

• QUOTE_NAME — Descriptive name of the quote header.
• QUOTE_NUMBER_VERSION — Composite key formed from QUOTE_NUMBER concatenated with QUOTE_VERSION.
• QUOTE_TOTAL — The monetary total, exposed as NVL(TOTAL_QUOTE_PRICE, 0.0); this is the column most frequently referenced in "quote_total" enquiries.
• QUOTE_STATUS — The status meaning derived from ASO_QUOTE_STATUSES_VL for the currently effective status.
• CURRENCY_CODE — Transaction currency of the quote.
• ACCOUNT_NUMBER — The customer account number from HZ_CUST_ACCOUNTS.
• SOLD_TO_CONTACT_NAME — Party name of the sold-to contact resolved through the ASO private party views.
• RESOURCE_ID / RESOURCE_NAME — Sales resource identifier and name from JTF_RS_SRP_VL.
• QUOTE_HEADER_ID — Primary identifier of the quote header.
• CUST_ACCOUNT_ID, PARTY_ID, QTE_PARTY_ID, APP_PARTY_TYPE — Identifiers and party type for the customer relationship.
• CREATION_DATE, QUOTE_EXPIRATION_DATE — Timestamp and expiry date of the quote.

Common Use Cases and Queries

The view is typically consumed to report pipeline quotes and their totals filtered by status, customer, or resource, without requiring callers to navigate the multi-org tables directly. A representative query retrieving quote totals by customer is:

SELECT quote_number_version, quote_name, quote_status,
       quote_total, currency_code, sold_to_contact_name
FROM   apps.aso_i_quote_headers_bali_v
WHERE  account_number = :p_account_number
ORDER  BY creation_date DESC;

Reporting open pipeline value by sales resource is equally common:

SELECT resource_name, quote_status,
       SUM(quote_total) AS total_pipeline
FROM   apps.aso_i_quote_headers_bali_v
WHERE  quote_status = 'Open'
GROUP  BY resource_name, quote_status;

Because the view already applies inner synchronization of status effective dating and the operating-unit CLIENT_INFO predicate, it is safe to embed in iStore-based integration flows and custom concurrent programs. Consumers should note that QUOTE_TOTAL is returned as 0.0 when the underlying TOTAL_QUOTE_PRICE is null, and that results are automatically restricted to the operating unit derived from the session context.