Search Results quote_status_code




Overview
Explore in AI Chat

Overview

APPS.AST_LM_QUOTES_V is a supplementary view in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema and registered under FND Design Data AST.AST_LM_QUOTES_V. It provides a denormalized, form-oriented representation of Oracle Quoting (ASO/TeleSales) data, consolidating header-level quote information with related party, customer account, sales representative, resource, and order data into a single row per quote. Its status is VALID, and its documented view type is a supplementary view used to simplify forms coding.

Oracle explicitly classifies this object as Internal Use Only. Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs, and the documentation warns that the view may change dramatically in subsequent minor or major releases. Consequently, the view is best treated as a reporting and integration convenience rather than a stable public API; consumers should expect to revalidate column lists and join semantics on upgrade.

The column of primary interest to the reporting user community — and the term most commonly searched against this object — is QUOTE_STATUS_CODE. This column exposes the coded status of the quote, complementing the descriptive QUOTE_STATUS column, which carries the translated or user-facing status text.

Underlying Base Objects

AST_LM_QUOTES_V is defined over the following documented base objects:

The view therefore functions as a join hub across the quoting, order management, trading community, and resource schemas, collapsing these sources into a single form-friendly result set.

Key Columns

The view exposes the following principal columns:

  • QUOTE_STATUS_CODE (VARCHAR2, 30) — the coded status of the quote, suitable for filtering and programmatic logic.
  • QUOTE_STATUS (VARCHAR2, 240) — the translated status description corresponding to the status code.
  • QUOTE_NAME (VARCHAR2, 240), QUOTE_NUMBER (NUMBER), and QUOTE_VERSION (NUMBER) — the quote identifier and version.
  • QUOTE_HEADER_ID (NUMBER) — the primary key of the underlying ASO_QUOTE_HEADERS_ALL record; the correct key for joining to base objects.
  • QUOTE_EXPIRATION_DATE (DATE) — the date the quote expires.
  • PARTY_NAME (VARCHAR2, 360), ACCOUNT_NUMBER (VARCHAR2, 30), CUST_ACCOUNT_ID, PARTY_ID, ORG_PARTY_ID — customer account and party identification.
  • RELATIONSHIP_NAME (VARCHAR2, 360), CONTACT_FIRST_NAME, CONTACT_LAST_NAME, CONTACT_NAME — relationship and contact details.
  • SALESREP_NAME (VARCHAR2, 240) — the owning sales representative.
  • ORDER_NUMBER (NUMBER) and ORDERED_DATE (DATE) — the sales order generated from the quote.
  • QUOTE_TOTAL and CURRENC(Y) — the quote value and currency.
  • ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2, 240) — descriptive flexfield segments.

Common Use Cases and Queries

Typical uses include quote pipeline reporting, status tracking by sales representative, quote-to-order conversion analysis, and extraction of quote data into external reporting marts.

Retrieve all open quotes by status code:

  • SELECT quote_number, quote_name, quote_status_code, quote_status, quote_total FROM apps.ast_lm_quotes_v WHERE quote_status_code = 'OPEN';

Summarize quote counts and value by status:

  • SELECT quote_status_code, COUNT(*) quote_count, SUM(quote_total) total_value FROM apps.ast_lm_quotes_v GROUP BY quote_status_code;

Identify quotes converted to orders:

  • SELECT q.quote_number, q.quote_status_code, q.order_number, q.ordered_date FROM apps.ast_lm_quotes_v q WHERE q.order_number IS NOT NULL;

Join to base quote headers for additional detail:

  • SELECT v.quote_number, v.quote_status_code, h.attribute_category FROM apps.ast_lm_quotes_v v, apps.aso_quote_headers_all h WHERE v.quote_header_id = h.quote_header_id;

Given the documented internal-use restriction, these queries are appropriate for read-only reporting and diagnostics, with the caveat that the view definition may change across releases.