Results for “asbv_sales_stages”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view ASBV_SALES_STAGES is a sales foundation object within the Oracle E-Business Suite AS (Sales Foundation) module. It presents sales stage definitions used to qualify opportunities and forecast revenue. Sales stages represent the progression of a sales opportunity through a defined pipeline, with each stage associated with a minimum and maximum win probability range. This view serves as the reporting and integration layer through which sales stage reference data is exposed to reporting tools, business intelligence dashboards, and external interfaces.

The name prefix "ASBV" follows the convention for a view built on a "BV" (business view) designation, indicating an Oracle-maintained, read-only projection intended primarily for query and integration use rather than for direct transactional maintenance. The underlying base table referenced in the ETRM metadata is AS_SALES_STAGES_ALL, which is the user search term most frequently associated with this object. The view is explicitly defined WITH READ ONLY, reflecting its purpose as a consumption-only interface.

Underlying Base Objects

The view is defined over the base table AS_SALES_STAGES_ALL, aliased as STAGE in the view text. This table stores the complete set of sales stage records, including multi-org (ORG_ID) partitioning and multilingual (_ALL) table-name conventions used throughout EBS. The ETRM metadata records that no referenced base objects were formally documented for this view; however, the view text itself identifies AS_SALES_STAGES_ALL as the single source table, joined to nothing else. The view applies a filtering predicate: the WHERE clause restricts output to records where the security-resolved value of STAGE.ORG_ID is not null, effectively enforcing that the operating unit context be resolvable. No joins or aggregations are performed, so the view is a direct, denormalized projection of the base table.

Key Columns

• NAME — The descriptive name of the sales stage (for example, "Qualified" or "Proposal").
• MIN_WIN_PROBABILITY / MAX_WIN_PROBABILITY — The lower and upper bounds of the win probability associated with the stage, used in forecasting calculations.
• "_LA:ENABLED" — A lookups-derived column rendering the enabled status. The view text references AS_LOOKUPS, meaning the flag is translated through a lookup join defined via the formatting directive.
• START_DATE_ACTIVE / END_DATE_ACTIVE — The effective date range during which the stage is active.
• DESCRIPTION — Free-text description of the stage.
• "_DF" — A descriptive flexfield column referencing AS_SALES_STAGES:STAGE, exposing the context and attribute segments defined for the stage flexfield.
• SALES_STAGE_ID — The primary key identifier for the stage record.
• ORG_ID — The operating unit identifier supporting multi-org partitioning.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard EBS WHO columns capturing audit and concurrency information.

Common Use Cases and Queries

Typical use cases include populating stage selection lists in custom forms, validating stage values during data migration, and reporting on pipeline progression by win probability band. Because the view is read-only, it is well suited to integration extracts.

A representative query listing active stages with their probability bands is:

SELECT name, min_win_probability, max_win_probability, start_date_active, end_date_active FROM asbv_sales_stages WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY min_win_probability;

To retrieve the winning-probability configuration for a specific operating unit:

SELECT sales_stage_id, name, max_win_probability FROM asbv_sales_stages WHERE org_id = :org_id;

The view is not implemented in all databases, as indicated by the ETRM metadata, so availability should be confirmed against the target environment before deployment.