Search Results close_date




Overview
Explore in AI Chat

Overview

AST_LM_OPP_QUICK_RESULTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the AST (TeleSales) product family. It presents a consolidated, denormalized projection of opportunity records drawn from the AS_LEADS_ALL base table, joined to customer, status, sales stage, and channel lookup sources. In ETRM 12.1.1 and 12.2.2 the object carries a status of VALID, indicating it is a supported, functioning dictionary object available for query and reporting use.

The view is designed to support rapid retrieval of opportunity-level summary information for TeleSales agents and administrators. Rather than requiring the caller to assemble joins across multiple base tables, the view exposes human-readable descriptions for coded values — status meaning, sales stage description, and channel meaning — alongside raw codes. This makes it particularly suitable for inquiry screens, ad hoc reporting, and lightweight integrations where opportunity context must be presented without exposing internal code values to the end user. The column name the user searched for, opportunity_name, is exposed directly by this view.

Underlying Base Objects

The view is defined over the following documented base objects:

The join structure uses inner joins for the party and status relationships, and outer joins for the sales stage and channel lookups, ensuring opportunity rows are retained even where the stage or channel translation is absent. The language predicates restrict translated columns to the session language of the executing user.

Key Columns

Common Use Cases and Queries

The view is typically used to power opportunity quick-search results, pipeline summaries, and channel or stage reporting. Because ORG_ID is exposed, queries should be constrained by the appropriate operating unit in multilanguage environments.

A representative query retrieving opportunity names by customer:

  • SELECT opportunity_name, lead_number, customer_name, status, sales_stage FROM apps.ast_lm_opp_quick_results_v WHERE customer_name LIKE :p_name;

A pipeline summary query aggregating by stage and channel:

  • SELECT sales_stage, channel, SUM(total_amount), AVG(win_probability) FROM apps.ast_lm_opp_quick_results_v WHERE org_id = :p_org GROUP BY sales_stage, channel;

Because the view contains no aggregation or filtering logic of its own, it can be joined freely to additional TeleSales or customer tables, and its translated columns adapt automatically to the session language of the querying user.