Search Results quote_lines




Overview
Explore in AI Chat

Overview

APPS.ASO_QUOTE_LINES_V is a reporting and integration view in the Oracle E-Business Suite Order-to-Cash (formerly ETRM / Advanced Pricing and Sales) module. It exposes quote line information maintained by Oracle Quoting (ASO), presenting one row per quote line along with denormalized descriptive attributes such as item type meaning. The view is defined in the APPS schema and is intended primarily for query, reporting, and downstream integration consumption rather than for direct transactional DML. It surfaces the core pricing, quantity, and reference columns needed to reconstruct a quote line without repeatedly joining to lookup and price list tables.

Underlying Base Objects

The view is defined over the following documented base objects:

The view therefore consolidates transactional quote line data with descriptive lookups and pricing metadata, shielding consumers from the underlying join complexity.

Key Columns

Common Use Cases and Queries

Typical uses include quote line extracts for BI Publisher reports, pricing analysis, and integration feeds into order capture. Because the view already joins item type meaning and price list name, it is convenient for reporting without additional lookups. A representative query retrieving active quote lines for a header follows:

  • SELECT quote_line_id, line_number, item_type, quantity, uom_code, currency_code, line_quote_price FROM apps.aso_quote_lines_v WHERE quote_header_id = :p_header_id ORDER BY line_number;
  • SELECT ql.quote_header_id, ql.line_number, ql.price_list_name, ql.line_adjusted_amount FROM apps.aso_quote_lines_v ql WHERE ql.org_id = :p_org_id AND ql.start_date_active <= SYSDATE AND NVL(ql.end_date_active, SYSDATE) >= SYSDATE;

Reports commonly filter on ORG_ID for multi-org security and on START_DATE_ACTIVE/END_DATE_ACTIVE for effective-dated selections. As the view is read-oriented, integrations should consume it for extraction only.