Search Results as_sales_stages_all_b




Overview
Explore in AI Chat

Overview

The AS_SALES_STAGES_ALL_B table is a core master data table within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It serves as the central repository for defining and managing the discrete steps in a sales process, known as sales stages. These stages represent the progression of a sales opportunity from initial lead identification through to closure, whether won or lost. The table's role is foundational to the sales pipeline and forecasting functionality, as it provides the structural definition against which all sales activities, probabilities, and revenue projections are measured. Its multi-org enabled design, indicated by the "_ALL_" suffix, allows for the definition of sales stages at both the operating unit and enterprise levels.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is SALES_STAGE_ID, which uniquely identifies each stage record. Based on its description and foreign key relationships, the table is expected to store critical attributes that define each stage's behavior and role in the sales cycle. These typically include columns for the stage name or code, a sequence number to enforce progression order, and the minimum and maximum win probability percentages associated with the stage (as referenced by foreign keys to AS_FORECAST_PROB_ALL_B). Other common attributes may control whether the stage is considered active, open, or closed, and may link to a specific sales methodology.

Common Use Cases and Queries

The primary use case is the configuration and maintenance of the sales pipeline stages within the application's setup menus. This table is queried extensively for operational reporting and analytics. Common SQL patterns include retrieving the list of active stages for a forecast report, joining opportunity data to get stage-specific metrics, or calculating pipeline value by applying stage probability. For example, a report to show all open opportunities with their current stage and associated win probability would join AS_LEADS_ALL (or related opportunity tables) to AS_SALES_STAGES_ALL_B on SALES_STAGE_ID. Administrators may query this table directly to audit or update stage definitions, such as modifying probability percentages for more accurate forecasting.

Related Objects

As indicated by the foreign key metadata, AS_SALES_STAGES_ALL_B is a heavily referenced parent table. Key dependent objects include:

This network of relationships underscores the table's integral position in the sales data model.