Search Results pricing_attribute1




Overview
Explore in AI Chat

Overview

The AS_QUOTE_LINES view is a multi-organization (multi-org) reporting and integration object within the Oracle E-Business Suite Sales Foundation (AS) module. It exposes quote line data from the Oracle Sales and Oracle Order Management quotation functionality, presenting one row per quotation line. Because quotations represent pre-order pricing and configuration records, this view is the canonical read-only interface for extracting line-level quote detail for downstream reporting, pricing analysis, and integration into external systems.

The object is described in ETRM documentation as "Quotation lines view (multi-org)" and is documented as not implemented in the reference database — meaning it exists in typical EBS 12.1.1 / 12.2.2 installations as a seeded view but may be absent in stripped or non-AS environments. Its multi-org behavior is enforced through the ORG_ID column and the standard USERENV('CLIENT_INFO') predicate, restricting visible rows to the operating unit context of the session.

The search term line_list_price maps directly to the LINE_LIST_PRICE column exposed by this view, which is one of the core pricing attributes available for each quotation line.

Underlying Base Objects

The view is defined entirely over a single base table, AS_QUOTE_LINES_ALL, which stores quotation line records for all operating units. The view predicate applies the standard multi-org security filter:

  • The WHERE clause compares NVL(ORG_ID, -99) against the operating unit derived from SUBSTRB(USERENV('CLIENT_INFO'), 1, 10), defaulting to -99 when no context is set.
  • This pattern is consistent with Oracle's Multi-Org architecture, where the _ALL table holds data across organizations and the non-suffixed view restricts access to the current organization.
  • No additional joins, base views, or synonyms are documented in the ETRM metadata; the projection is a direct column pass-through from AS_QUOTE_LINES_ALL.

Key Columns

Common Use Cases and Queries

Typical uses include quote-to-order reconciliation, list price versus net price margin analysis, and loading quote lines into a data warehouse or CRM. A representative query retrieving list price and discount detail for a quotation is:

  • SELECT quote_line_id, quote_id, inventory_item_id, line_list_price, line_quote_price, line_discount_percent FROM as_quote_lines WHERE quote_id = :quote_id ORDER BY line_number;
  • SELECT line_list_price, line_quote_price, (line_list_price - line_quote_price) AS line_discount FROM as_quote_lines WHERE org_id = :org_id AND creation_date >= :start_date;
  • SELECT ql.quote_line_id, ql.line_list_price, pl.name FROM as_quote_lines ql, qp_price_lists_vl pl WHERE ql.price_list_id = pl.price_list_id;

Because the view enforces multi-org security, queries executed without an initialized CLIENT_INFO context resolve to ORG_ID = -99 and return no rows. Integrations must therefore set the operating unit context (for example, via FND_GLOBAL.APPS_INITIALIZE or MO_GLOBAL.SET_POLICY_CONTEXT) before querying. All columns are read-only; inserts and updates must target AS_QUOTE_LINES_ALL directly through supported AS APIs.