Search Results sales_stage_name




Overview
Explore in AI Chat

Overview

The AS_SALES_OPP_UWQ_V view is a reporting and integration object owned by the APPS schema within the Oracle E-Business Suite Sales Foundation (AS) product family. Its documented purpose is to support the Universal Work Queue (UWQ), the framework that surfaces actionable work items to sales users through a consolidated interface. The view presents a curated, denormalized projection of sales opportunity data, drawing together opportunity attributes, customer information, sales stage, status, forecast probability, resource assignments, and channel details into a single queryable structure.

Because it is a view rather than a table, it carries no independent storage; instead it derives its content dynamically from a set of base objects each time it is queried. Status is documented as VALID in the ETRM 12.2.2 metadata, confirming that the object is available and operational in both Oracle EBS 12.1.1 and 12.2.2 environments. A distinguishing characteristic is its reliance on USERENV('LANG') for translated columns, meaning the view returns language-specific labels based on the session language of the querying user.

Underlying Base Objects

The view is defined over ten documented base objects spanning opportunity, resource, access, and reference data:

Joins are driven primarily by STATUS, CUSTOMER_ID, SALES_STAGE_ID, WIN_PROBABILITY, LEAD_ID, and CHANNEL_CODE. A notable filter is STB.OPP_OPEN_STATUS_FLAG = 'Y', which restricts the result set to open opportunities only.

Key Columns

Common Use Cases and Queries

The primary use case is populating the Universal Work Queue with open sales opportunities. Reporting scenarios include pipeline reviews, probability-weighted forecasting, and resource workload analysis. A representative query lists open opportunities with their probability and status labels:

  • SELECT lead_id, lead_number, party_name, sales_stage_name, status_meaning, probability_meaning, total_amount FROM as_sales_opp_uwq_v;
  • SELECT resource_id, COUNT(*) opp_count, SUM(total_amount) pipeline_value FROM as_sales_opp_uwq_v GROUP BY resource_id;
  • SELECT probability_meaning, SUM(total_amount) weighted_value FROM as_sales_opp_uwq_v GROUP BY probability_meaning ORDER BY probability_meaning;

Because translated columns depend on USERENV('LANG'), results vary by session language, and queries should be executed under an appropriately configured session to return expected labels.