Search Results backorder_flag




Overview
Explore in AI Chat

Overview

ASO_QUOTE_LINES_ALL_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ASO – Order Capture product family. It exposes quote line information captured in the Oracle Quoting and Order Capture modules and is documented with a status of VALID in ETRM for releases 12.1.1 and 12.2.2. Because the view is defined over a synonym that resolves to the base transactional entity, it provides a stable, read-oriented projection of quote lines without requiring consumers to reference the underlying table directly.

The view is multi-organization aware: ORG_ID is exposed as a column, so a single query can address quote lines across operating units when the appropriate MO security profile or explicit predicate is supplied. This makes the view suitable for operational reports, order-to-quote reconciliation, pricing analysis, and outbound interfaces that must read committed quote line data.

Underlying Base Objects

The documented metadata identifies a single referenced base object: the synonym ASO_QUOTE_LINES. In a standard 12.1.1 or 12.2.2 environment this synonym resolves to the APPS-owned base table that stores quote lines. The view text is a straight column projection — every column listed in the definition is drawn unchanged from that base object, with no joins, unions, or aggregation applied. Consequently, the view adds no transformation or filtering layer; it serves as a naming and access abstraction over the physical table, and row counts and cardinality match the underlying entity exactly. Because no outer joins are present, records are returned one-for-one for each quote line stored.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on quote line pricing, exporting quote lines to a data warehouse, and auditing shipment-splitting and backorder settings. A representative query retrieving lines for a specific quote is:

  • SELECT quote_line_id, quote_header_id, line_number, inventory_item_id, quantity, uom_code, line_quote_price, split_shipment_flag, backorder_flag FROM aso_quote_lines_all_v WHERE quote_header_id = :p_quote_header_id ORDER BY line_number;
  • SELECT quote_line_id, quote_header_id, currency_code, line_list_price, line_adjusted_amount, line_quote_price FROM aso_quote_lines_all_v WHERE org_id = :p_org_id AND last_update_date >= :p_since;
  • SELECT inventory_item_id, COUNT(*) FROM aso_quote_lines_all_v WHERE split_shipment_flag = 'Y' GROUP BY inventory_item_id;