Search Results aso_quote_headers_all




Overview
Explore in AI Chat

Overview

The ASO_QUOTE_HEADERS_ALL table is the central repository for quotation header information within the Oracle E-Business Suite Order Capture (ASO) module. It serves as the master record for a commercial quotation, encapsulating the overarching business agreement before it is converted into a sales order. This table is fundamental to the quote-to-order business flow in releases 12.1.1 and 12.2.2. As a multi-org enabled table (indicated by the "_ALL" suffix), it stores data for all operating units, with access typically controlled by the MO_GLOBAL.ORG_SECURITY security profile. Each record in this table can have zero or more associated quote lines, which are stored in the related ASO_QUOTE_LINES_ALL table.

Key Information Stored

The table's primary key is the QUOTE_HEADER_ID, a unique system-generated identifier for the quotation. Critical columns include business identifiers like QUOTE_NUMBER and status management fields such as QUOTE_STATUS_ID, which links to the ASO_QUOTE_STATUSES_B table. It holds comprehensive party and customer information through foreign key relationships to the HZ_PARTIES and HZ_PARTY_SITES tables, including columns for CUST_PARTY_ID, SOLD_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_ID, and INVOICE_TO_PARTY_SITE_ID. The table also stores transactional metadata like ORG_ID for operating unit context, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and currency details. Pricing, terms, and shipping information pertinent to the entire quote are also maintained at this header level.

Common Use Cases and Queries

This table is central for reporting on the quote pipeline, analyzing conversion rates, and auditing the quotation process. Common operational queries involve retrieving active quotes for a customer or sales representative, or identifying quotes pending approval. A typical reporting query joins to related tables to provide a comprehensive view:

  • Joining with ASO_QUOTE_LINES_ALL to aggregate line-level details like total quoted quantity or value.
  • Joining with HZ_PARTIES to retrieve customer names and details.
  • Joining with ASO_QUOTE_STATUSES_B to filter quotes by their lifecycle status (e.g., 'ENTERED', 'ACCEPTED', 'EXPIRED').

For data integrity, updates or deletions should be performed through the standard Order Capture APIs (e.g., ASO_QUOTE_PUB) rather than via direct SQL DML operations.

Related Objects

ASO_QUOTE_HEADERS_ALL has extensive relationships within the ASO schema, acting as a parent to numerous transactional child tables. Key related objects include:

  • ASO_QUOTE_LINES_ALL: The primary child table storing individual line items for the quote.
  • ASO_PRICE_ADJUSTMENTS, ASO_TAX_DETAILS, ASO_SHIPMENTS: Tables storing header-level pricing, tax, and fulfillment details.
  • ASO_QUOTE_PARTIES and ASO_SALES_CREDITS: Tables for managing involved parties and sales compensation.
  • ASO_HEADER_RELATIONSHIPS: Manifies relationships between different quote headers.
  • Foreign Key References: Critical foreign keys link to foundational Trading Community Architecture (TCA) tables like HZ_PARTIES and HZ_PARTY_SITES for customer data, and to ASO_QUOTE_STATUSES_B for status definitions.