Search Results as_quote_lines_all

Overview

The AS_QUOTE_LINES_ALL table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It serves as the primary repository for storing detailed line-level information for sales quotations. In the context of the Oracle Sales (OSM) schema, this table is fundamental to the quotation management process, capturing the specific products, services, quantities, pricing, and terms offered to a prospective customer. As an "ALL" table, it is designed to support the Multi-Org architecture of EBS, meaning it stores data for all operating units and requires a security condition, such as the ORG_ID column, to filter records appropriately for a given session or report. Its integrity is enforced by the primary key constraint AS_QUOTE_LINES_PK on the QUOTE_LINE_ID column.

Key Information Stored

The table's structure is designed to comprehensively model a quotation line item. While the full column list is proprietary, based on its description and standard EBS patterns, it typically contains critical fields. The primary key, QUOTE_LINE_ID, uniquely identifies each line. A foreign key column, such as QUOTE_HEADER_ID, links the line to its parent quotation in the AS_QUOTE_HEADERS_ALL table. Other essential columns include LINE_NUMBER for sequencing, INVENTORY_ITEM_ID to identify the product or service, and QUANTITY. Pricing information is stored in columns like UNIT_LIST_PRICE, UNIT_SELLING_PRICE, and ADJUSTED_AMOUNT. The table also tracks status (e.g., STATUS_CODE), schedule information (e.g., SCHEDULE_SHIP_DATE), and the operating unit context via the mandatory ORG_ID column.

Common Use Cases and Queries

This table is central to quotation-related reporting, data extraction, and integration. Common operational reports include detailed line-item listings for a quotation, product-wise quotation pipeline analysis, and historical pricing comparisons. A typical query to retrieve active quotation lines for a specific operating unit would join to the header table and filter on status and ORG_ID. For performance, analysts often aggregate data from this table to calculate total quoted revenue, average discount per line, or most frequently quoted items. Data from AS_QUOTE_LINES_ALL is also critical for integrations, such as feeding quotation line details into downstream order management systems when a quote is converted to an order, or into business intelligence tools for sales analytics.

Related Objects

AS_QUOTE_LINES_ALL has intrinsic relationships with several other key EBS objects. Its most direct relationship is with the AS_QUOTE_HEADERS_ALL table, which stores the overarching quotation information like customer, quote number, and validity dates. It is also related to inventory tables (e.g., MTL_SYSTEM_ITEMS_B) for item details and pricing tables (e.g., QP_LIST_HEADERS) for list price sources. In transactional flow, data from this table is processed by Oracle Sales APIs and is often accessed through standard Oracle views which provide a more application-friendly layer. When a quotation is converted, its lines are typically transferred to the Order Management module, creating records in tables such as OE_ORDER_LINES_ALL.