Search Results as_quotes_all




Overview
Explore in AI Chat

Overview

The AS_QUOTES_ALL table is a core transactional data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). As its description states, it defines quotations. This table serves as the primary repository for all sales quotation headers across the enterprise, storing the master record for each quote created. Its role is central to the sales cycle, capturing the initial formal offer of goods or services to a customer, including pricing, terms, and validity. The '_ALL' suffix indicates it is a multi-organization table, meaning it stores data for all operating units, with access typically controlled by a security profile or the MOAC (Multi-Org Access Control) framework in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is QUOTE_ID, a unique system-generated identifier for each quotation record. While the provided metadata does not list specific columns, based on its function and standard EBS design, the table typically contains a comprehensive set of attributes that define the quotation's context and metadata. Key columns generally include fields for the quote number, status (e.g., DRAFT, ACTIVE, EXPIRED, ACCEPTED), the customer and ship-to/sold-to party identifiers, the operating unit (ORG_ID), currency code, terms and conditions references, the sales representative, effective start and end dates, and total amounts. It also contains standard EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.

Common Use Cases and Queries

This table is fundamental for reporting on the sales pipeline, quote lifecycle management, and historical analysis. Common operational queries involve joining with related detail and party tables to generate comprehensive quote reports. For instance, a basic query to list active quotes for a specific operating unit would filter on STATUS and ORG_ID. Performance reporting often aggregates data from this table, counting quotes or summing amounts by period, sales rep, or customer. A typical analytical SQL pattern might join AS_QUOTES_ALL to HZ_CUST_ACCOUNTS for customer details and AS_SALES_CREDITS for representative information. Integration and data migration processes also interact heavily with this table, often via the public Oracle Sales API (AS_SALES_ORDERS_PUB), which provides the sanctioned method for creating and updating quotation data programmatically.

Related Objects

  • AS_QUOTE_LINES_ALL: The primary child table, storing individual line items (products, services) associated with each quotation header from AS_QUOTES_ALL.
  • AS_SALES_CREDITS: Stores sales team member credit assignments for quotations.
  • HZ_CUST_ACCOUNTS: The Trading Community Architecture (TCA) table for customer information, linked via the CUSTOMER_ID or similar foreign key.
  • AS_QUOTES: A single-organization view (filtered by MOAC security) built upon AS_QUOTES_ALL, commonly used for application reporting.
  • APIs (AS_SALES_ORDERS_PUB): The supported public API package for creating, updating, and managing quotation data, which performs validations and business logic before modifying base tables like AS_QUOTES_ALL.