Search Results aso_quote_headers_all_v




Overview
Explore in AI Chat

Overview

ASO_QUOTE_HEADERS_ALL_V is an Oracle E-Business Suite view owned by the APPS schema and validated against the ASO (Order Capture) product family. Its documented description is simply "quotations," and it exposes the header-level attributes of sales quotations captured through Oracle Quoting / Order Capture. The view is a direct, unrestricted projection of its base synonym, presenting every column of the quotation header without joins, filters, or aggregation. This makes it the canonical reporting and integration surface for quote-header data in EBS 12.1.1 and 12.2.2: because it is a view layered over the underlying table, its structure documents the physical header entity itself.

The "_V" suffix conventionally signals a view, and its presence alongside the base synonym is what reporting tools, concurrent programs, interfaces, and custom extensions rely on. Any attribute physically present on the quotation header — including the cost, currency, contract, and party identifiers — is available here through a single SELECT.

Underlying Base Objects

The view is defined over the documented referenced base object ASO_QUOTE_HEADERS (exposed in the APPS schema as a synonym), and its view text is a plain column list drawn from ASO_QUOTE_HEADERS_ALL. The trailing "_ALL" naming denotes an organization-enabled entity; the header carries ORG_ID, consistent with Multi-Org Access Control (MOAC). The projection spans the complete header record, from primary key and audit columns through financial totals, party and site references, currency and exchange attributes, contract identifiers, descriptive flexfield columns (ATTRIBUTE1–15 and ATTRIBUTE_CATEGORY), and control columns such as SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, PUBLISH_FLAG, MAX_VERSION_FLAG, and QUOTE_TYPE. Each column maps one-to-one to a base column, and no data transformation or business logic is applied within the view.

Key Columns

Common Use Cases and Queries

Typical scenarios include extracting quote headers for a data warehouse, feeding a custom quotation report, or reconciling pricing totals. Because the view carries MOAC filtering, org-scoped queries should always constrain ORG_ID (or rely on the SQL enforcement of the reporting tool). A representative query filtering on the searched column is:

  • SELECT QUOTE_NUMBER, QUOTE_NAME, CURRENCY_CODE, TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_ADJUSTED_PERCENT, TOTAL_QUOTE_PRICE FROM ASO_QUOTE_HEADERS_ALL_V WHERE ORG_ID = :p_org_id AND TOTAL_ADJUSTED_PERCENT IS NOT NULL ORDER BY LAST_UPDATE_DATE DESC;
  • Version control: joining the view to itself on QUOTE_HEADER_ID filtered by MAX_VERSION_FLAG = 'Y' or PUBLISH_FLAG to report only the current published quotation.
  • Order conversion tracking: filtering on ORDER_ID IS NOT NULL to list quotations already converted to orders, keyed by ORDER_TYPE_ID and SALES_CHANNEL_CODE.
  • Flexfield reporting: selecting ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for organization-specific quotation attributes.