Results for “aso_quote_headers_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO.ASO_QUOTE_HEADERS_ALL is the master header table for Order Capture (ASO) quotation information in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents the header of a single quote, holding customer, pricing, status, contract, and versioning information. A quote header may be associated with zero to many quote lines, which are stored in the child table ASO_QUOTE_LINES_ALL. The table is owned by the ASO schema and is classified as VALID in the ETRM repository.

The heuristic Data Vault classification mined from the foreign-key structure is hub. This suggests the table functions as a central business-key repository, where QUOTE_HEADER_ID serves as the durable identifier around which links (relationships to parties, order types, statuses) and satellites (descriptive attributes, pricing, contract details) are modeled. The table carries a high column count (109 documented columns), with descriptive attributes suitable for satellite modeling.

Key Information Stored

The surrogate primary key is QUOTE_HEADER_ID, enforced by the constraint ASO_QUOTE_HEADERS_ALL_PK. Two unique indexes are documented:

• ASO_QUOTE_HEADERS_ALL_U1 on (QUOTE_NUMBER, QUOTE_VERSION) — a business-key candidate that identifies a specific version of a quote.
• ASO_QUOTE_HEADERS_ALL_U2 on (QUOTE_HEADER_ID) — supporting the surrogate key.

The most significant columns include:

• QUOTE_NUMBER and QUOTE_VERSION — the business identifier and version of the quote.
• QUOTE_NAME and QUOTE_DESCRIPTION — descriptive labels for the quote.
• QUOTE_STATUS_ID — foreign key to ASO_QUOTE_STATUSES_B, indicating the current lifecycle status.
• PARTY_ID, CUST_ACCOUNT_ID, CUST_PARTY_ID — customer identity, referencing HZ_PARTIES and HZ_CUST_ACCOUNTS.
• INVOICE_TO_PARTY_ID, INVOICE_TO_PARTY_SITE_ID, SOLD_TO_PARTY_SITE_ID — ship-to and bill-to party site references.
• CURRENCY_CODE — currency of the quote.
• TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_TAX, TOTAL_QUOTE_PRICE — monetary totals for the quote.
• ORDER_TYPE_ID — foreign key to SO_ORDER_TYPES_115_ALL, defining the order type applied to the quote.
• ORG_ID and SECURITY_GROUP_ID — multi-org and security group context.
• MAX_VERSION_FLAG — indicates whether this is the latest version of the quote.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the latest active version of a quote, listing all quotes for a customer, and reconciling quote totals against order totals.

A common pattern for obtaining the current version of a quote:

SELECT h.quote_number, h.quote_version, h.quote_name,
       h.total_quote_price, s.quote_status_code
  FROM aso_quote_headers_all h,
       aso_quote_statuses_b s
 WHERE h.quote_status_id = s.quote_status_id
   AND h.max_version_flag = 'Y'
   AND h.cust_account_id = :p_cust_account_id;

CRM and quoting extensions frequently join ASO_QUOTE_HEADERS_ALL to ASO_QUOTE_LINES_ALL to produce line-level detail reports, and to HZ_PARTIES to display customer names. The PRP_PROPOSAL_OBJECTS table references OBJECT_ID against this table's QUOTE_HEADER_ID, so users searching for "prp_proposal_objects" are typically tracing how proposals link to quotes. A sample join:

SELECT p.proposal_object_id, h.quote_number, h.quote_name
  FROM prp_proposal_objects p, aso_quote_headers_all h
 WHERE p.object_id = h.quote_header_id;

Related Objects

The following objects have the most significant dependencies on ASO_QUOTE_HEADERS_ALL:

• ASO_QUOTE_LINES_ALL — child lines referencing QUOTE_HEADER_ID.
• ASO_QUOTE_STATUSES_B — status lookup via QUOTE_STATUS_ID.
• HZ_PARTIES and HZ_PARTY_SITES — customer and site references.
• HZ_CUST_ACCOUNTS — customer account referencing CUST_ACCOUNT_ID.
• ASO_QUOTE_PARTIES — party roles for the quote.
• ASO_PRICE_ADJUSTMENTS and ASO_PRICE_ATTRIBUTES — pricing detail.
• ASO_TAX_DETAILS — tax lines associated with the quote.
• ASO_PAYMENTS — payment information.
• PRP_PROPOSAL_OBJECTS — links proposals to quote headers via OBJECT_ID.
• ASO_HEADER_RELATIONSHIPS — relationships between quote headers.

These dependencies confirm the hub role of ASO_QUOTE_HEADERS_ALL within the Order Capture quotation model.