Search Results aso_quote_line_details




Overview
Explore in AI Chat

Overview

The ASO_QUOTE_LINE_DETAILS table, owned by the ASO (Order Capture) module, is a core transactional table within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a child table to ASO_QUOTE_LINES_ALL, designed to store extended, type-specific attributes for individual quote lines. This structure allows the Order Capture application to manage complex quoting scenarios where standard line attributes are insufficient. The table's role is to provide a normalized, extensible data model for capturing detailed information that qualifies or further defines a quoted item or service, thereby supporting sophisticated pricing, configuration, and proposal generation processes.

Key Information Stored

The table's primary key is the system-generated identifier QUOTE_LINE_DETAIL_ID. Its most critical foreign key is QUOTE_LINE_ID, which links each detail record to its parent line in ASO_QUOTE_LINES_ALL. While the provided metadata does not list all columns, the table's purpose indicates it holds supplementary fields relevant to specific product or service types. This could include attributes such as serial numbers, configuration IDs, service period details, asset references, or custom descriptive flexfield data. The data stored here is essential for transforming a high-level quote line into a fully specified order line during the order import and fulfillment process.

Common Use Cases and Queries

A primary use case is extracting a complete quote for reporting or integration, requiring a join between the quote header, lines, and their details. Technical consultants often query this table to debug quote-to-order conversion issues or to build custom reports on quoted product configurations. A common SQL pattern retrieves all detail records for a specific quote line:

  • SELECT * FROM ASO.ASO_QUOTE_LINE_DETAILS WHERE QUOTE_LINE_ID = <line_id>;

Another frequent scenario involves validating data integrity before a major migration or upgrade, using a query to identify orphaned detail records:

  • SELECT aqld.* FROM ASO.ASO_QUOTE_LINE_DETAILS aqld WHERE NOT EXISTS (SELECT 1 FROM ASO.ASO_QUOTE_LINES_ALL aqla WHERE aqla.QUOTE_LINE_ID = aqld.QUOTE_LINE_ID);

Related Objects

The table maintains a direct, documented foreign key relationship with ASO_QUOTE_LINES_ALL. This is the principal relationship, enforcing that every detail record must correspond to a valid parent quote line. The join is performed on the column ASO_QUOTE_LINE_DETAILS.QUOTE_LINE_ID to ASO_QUOTE_LINES_ALL.QUOTE_LINE_ID. As a transactional table, it is also referenced by various Order Capture APIs and is the base table for the public view ASO_QUOTE_LINE_DETAILS (without the _ALL suffix), which typically filters data by the operating unit's security profile (MO_GLOBAL.ORG_SECURITY). Developers should use the public APIs, such as those in the ASO_QUOTE_PUB package, for any data manipulation to maintain business logic integrity.