Search Results quote_lines




Overview
Explore in AI Chat

Overview

ASO_QUOTE_LINES_V is a read-only reporting view in the APPS schema belonging to the ASO – Order Capture (Oracle Quoting) product family. It exposes quote line data held in the Oracle Quoting tables and presents one row per quote line, enriched with derived descriptions such as the item type meaning and the price list name. In Oracle EBS 12.1.1 and 12.2.2, the view serves as the primary reference point for querying quote lines without joining to the underlying transactional tables directly. Its status is documented as VALID, and it is owned by APPS. Because it is a view rather than a table, it carries no independent storage; all reads are resolved against the base quote line tables and supporting lookups at query time. This makes it suitable for reporting, data extraction, and integration interfaces where consumers require a denormalised, business-friendly projection of quote line information.

Underlying Base Objects

The view text selects from ASO_QUOTE_LINES (exposed through a synonym), joined to ASO_LOOKUPS for the item type meaning and to ASO_I_PRICE_LISTS_V for the price list name. Documented dependencies also include ASO_I_ITEMS_V, ASO_QUOTE_LINE_DETAILS (SYNONYM), and the QP_PRICE_LIST_PVT package. ASO_QUOTE_LINES is the principal base object, contributing the transactional quote line attributes. ASO_LOOKUPS supplies the decoded meaning for ITEM_TYPE_CODE, and ASO_I_PRICE_LISTS_V provides the PRICE_LIST_NAME. The dependency on QP_PRICE_LIST_PVT reflects the pricing foundation that supplies list price and pricing context. Because the view references these supporting objects, a change in any of them can affect the view; in practice the view remains stable and is rarely recompiled manually.

Key Columns

The view exposes identifiers, descriptive attributes, and pricing measures. Principal columns include:

Common Use Cases and Queries

The view is typically queried to report quote line detail, to reconcile quoted prices against price lists, and to feed downstream order or analytics systems. A common pattern filters by header or operating unit:

  • Retrieve all lines for a quote: SELECT line_number, inventory_item_id, quantity, uom_code, line_quote_price FROM aso_quote_lines_v WHERE quote_header_id = :p_header_id ORDER BY line_number;
  • Report quoted versus list price by operating unit: SELECT quote_header_id, currency_code, SUM(line_list_price), SUM(line_quote_price) FROM aso_quote_lines_v WHERE org_id = :p_org_id GROUP BY quote_header_id, currency_code;
  • Identify price list usage: SELECT price_list_name, COUNT(*) FROM aso_quote_lines_v WHERE creation_date >= :p_from_date GROUP BY price_list_name;

Because ORG_ID is exposed, queries should include it to respect multi-org access. Joining to ASO_QUOTE_HEADERS for customer and status information is common when a full quote context is required.