Search Results aso_quote_lines_all

Overview

The ASO_QUOTE_LINES_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Advanced Sales Order (ASO) or Order Capture module. It serves as the central transactional table for storing detailed information pertaining to individual lines of a sales quote or an order. Every line item added to a quote or order header in ASO_QUOTE_HEADERS_ALL is recorded as a distinct row in this table. Its role is fundamental to the quote-to-order lifecycle, capturing the product, quantity, pricing, and fulfillment specifics for each line, which can later be converted into an order line in the Order Management module. The '_ALL' suffix indicates it is a multi-organization table, storing data for all operating units.

Key Information Stored

Each record is uniquely identified by the QUOTE_LINE_ID, which serves as the primary key. The table's structure is designed to capture comprehensive line-level details. The QUOTE_HEADER_ID column is a critical foreign key that links the line to its parent document in ASO_QUOTE_HEADERS_ALL. Other significant columns include those for product identification (INVENTORY_ITEM_ID), pricing (UNIT_LIST_PRICE, UNIT_SELLING_PRICE), quantities (ORDERED_QUANTITY), and scheduling (SCHEDULE_SHIP_DATE). The table also holds key party and site identifiers, such as INVOICE_TO_PARTY_ID and SHIP_TO_PARTY_SITE_ID, linking to the Trading Community Architecture (TCA) via HZ_PARTIES and HZ_PARTY_SITES. Additional attributes track line status, source types, and configuration details.

Common Use Cases and Queries

This table is central to reporting and data extraction for sales operations. Common use cases include analyzing quote line performance, auditing pricing adjustments, and generating fulfillment reports. A typical query involves joining to the header table and TCA to retrieve a comprehensive line-level dataset. For example, to list all lines for a specific quote number, one might use a pattern such as:

• SELECT aql.quote_line_id, aql.ordered_item, aql.ordered_quantity, aql.unit_selling_price FROM aso_quote_lines_all aql, aso_quote_headers_all aqh WHERE aql.quote_header_id = aqh.quote_header_id AND aqh.quote_number = '<QUOTE_NUMBER>';

Another frequent scenario is tracing the lineage of price adjustments or tax calculations for a specific line by joining to child tables like ASO_PRICE_ADJUSTMENTS or ASO_TAX_DETAILS using the QUOTE_LINE_ID.

Related Objects

As indicated by the extensive foreign key relationships, ASO_QUOTE_LINES_ALL is a pivotal hub for numerous child transactional tables. Its most direct parent is ASO_QUOTE_HEADERS_ALL. Key child tables that store line-specific extensions include ASO_PRICE_ADJUSTMENTS for discounts, ASO_SHIPMENTS for scheduling, ASO_QUOTE_LINE_DETAILS for additional attributes, and ASO_TAX_DETAILS. It also has relationships to tables managing line associations (ASO_LINE_RELATIONSHIPS), parties (ASO_QUOTE_PARTIES), and payments (ASO_PAYMENTS). For integration with Order Management, the line data is typically processed through public APIs, which may internally reference this table to create order lines in OE_ORDER_LINES_ALL.