Search Results ast_lm_quotes_v




Overview
Explore in AI Chat

Overview

AST_LM_QUOTES_V is a reporting view owned by the APPS schema and delivered as part of the Oracle TeleSales (AST) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to present a denormalized, read-only projection of quote data originating from Oracle Quoting (ASO), enriched with customer, contact, sales representative, order, and operating unit attributes. Because quoting activities in TeleSales span multiple functional schemas, the view provides a single consolidated access point that shields report developers and integrators from the underlying join complexity. It is typically consumed for quote pipeline analysis, telesales agent dashboards, and outbound/inbound integration extracts that require quote header, status, expiration, and converted-order information in one record set. The view is marked VALID in the ETRM metadata, and because it is defined with outer joins against several reference tables, it does not enforce referential integrity on the quote header; orphaned or partially populated quote rows are still returned.

Underlying Base Objects

The view is defined over the following documented objects: ASO_QUOTE_HEADERS_ALL (synonym) as the driving table, OE_ORDER_HEADERS_ALL (synonym) for converted orders, ASO_QUOTE_STATUSES_VL (view) for status meaning and code, HZ_CUST_ACCOUNTS (synonym) for account number, HZ_PARTIES (synonym, aliased PARTY) for the bill-to party name, JTF_RS_SALESREPS (synonym) for the sales resource, HZ_RELATIONSHIPS (synonym) with HZ_PARTIES (aliased PART) to resolve the person contact linked to the organization, and HR_OPERATING_UNITS (view) for the operating unit name. ASO_QUOTE_HEADERS_ALL is joined to OE_ORDER_HEADERS_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES, and JTF_RS_SALESREPS using outer joins, so missing orders or accounts do not suppress quote rows. The join to HR_OPERATING_UNITS is an inner join on ORG_ID, meaning every returned row must resolve to a valid operating unit. A distinguishing filter restricts PARTY.STATUS to 'A' or 'I', excluding parties in other lifecycle states.

Key Columns

The SELECT list exposes the following documented columns:

Common Use Cases and Queries

Typical usage includes open quote pipelines, quote-to-order conversion tracking, and per-operating-unit reporting.

  • Active quote pipeline by salesrep: 
    SELECT SALESREP_NAME, QUOTE_NUMBER, QUOTE_TOTAL, QUOTE_EXPIRATION_DATE
FROM APPS.AST_LM_QUOTES_V
WHERE QUOTE_STATUS_CODE = 'OPEN';
  • Conversion analysis comparing quoted versus ordered dates: 
    SELECT QUOTE_NUMBER, QUOTE_EXPIRATION_DATE, ORDER_NUMBER, ORDERED_DATE
FROM APPS.AST_LM_QUOTES_V
WHERE ORDER_NUMBER IS NOT NULL;
  • Operating unit rollup: 
    SELECT OPERATING_UNIT, COUNT(*), SUM(QUOTE_TOTAL)
FROM APPS.AST_LM_QUOTES_V
GROUP BY OPERATING_UNIT;

Because of the DISTINCT clause in the view definition, aggregations are performed over already-distinct rows, which can affect counts when relationships produce duplicates. Reports should filter on ORG_ID for multi-org security.