Search Results quote_total




Overview
Explore in AI Chat

Overview

APPS.ASO_I_QUOTE_HEADERS_BALI_V is an Oracle E-Business Suite internal view owned by the APPS schema. It exposes a denormalized, reporting-oriented projection of Oracle Advanced Pricing / Oracle Quoting quote header information, joining quote header records to operating unit data and resolving party, account, customer, currency, and resource attributes into a single queryable structure. The view carries an Oracle Internal Use Only designation, and Oracle does not support direct access to this object except through standard Oracle Applications programs. Despite that restriction, the view is widely recognized as an integration and reporting interface used by internal Oracle application flows, particularly list-of-values, worklist, and work-action processing within the Quoting and Trade Management (AST) stack. Notably, the view is referenced by APPS.AST_UWQ_OLIST_WORK_ACTION, confirming its role as a supporting source for Oracle Workflow and Universal Work Queue processing. It exposes the quote_total metric as the column QUOTE_TOTAL, which is the attribute most commonly sought by users searching for quote totals in EBS 12.1.1 and 12.2.2.

Underlying Base Objects

Per the documented metadata, ASO_I_QUOTE_HEADERS_BALI_V is defined over exactly two referenced objects:

  • ASO_QUOTE_HEADERS_ALL (exposed through an APPS synonym) — the core transactional table holding quote header records, including quote name, number, version, status, currency, expiration date, and header identifiers.
  • HR_OPERATING_UNITS (a view) — used to resolve the operating unit name associated with each quote header, enabling multi-org reporting through the OPERATING_UNIT column of type VARCHAR2(240).

The view is itself referenced by APPS.AST_UWQ_OLIST_WORK_ACTION. The view type is documented as Internal, and its FND Design Data identifier is ASO.ASO_I_QUOTE_HEADERS_BALI_V.

Key Columns

Common Use Cases and Queries

Typical scenarios include reporting quote totals by operating unit, currency, or status; driving worklists and work actions; and supporting LOV queries for quote selection.

Retrieve the highest-value quotes:

  • SELECT QUOTE_NUMBER, QUOTE_NAME, QUOTE_STATUS, QUOTE_TOTAL, CURRENCY_CODE, OPERATING_UNIT FROM APPS.ASO_I_QUOTE_HEADERS_BALI_V ORDER BY QUOTE_TOTAL DESC;

Aggregate totals by operating unit:

  • SELECT OPERATING_UNIT, CURRENCY_CODE, SUM(QUOTE_TOTAL) TOTAL_VALUE FROM APPS.ASO_I_QUOTE_HEADERS_BALI_V WHERE QUOTE_STATUS = 'ACTIVE' GROUP BY OPERATING_UNIT, CURRENCY_CODE;

Locate a quote by number or account:

  • SELECT QUOTE_HEADER_ID, QUOTE_NUMBER, ACCOUNT_NUMBER, SOLD_TO_CONTACT_NAME, QUOTE_TOTAL FROM APPS.ASO_I_QUOTE_HEADERS_BALI_V WHERE QUOTE_NUMBER = :quote_number;

Because the object is documented as Internal and unsupported for direct access, queries should be limited to diagnostic or reporting purposes and governed accordingly.