Results for “max_score”

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

Overview

AS_SALES_LEAD_RANKS_VL is an Oracle E-Business Suite view owned by the APPS schema and delivered as part of the AS - Sales Foundation product family. It presents sales lead ranking definitions in a multi-language support (MLS) format, combining the language-independent attributes of a lead rank with its translated descriptive text. The view is classified as VALID in Oracle EBS 12.1.1 and 12.2.2, which confirms that it is a supported, queryable object for reporting, integration, and extension purposes.

The "_VL" suffix follows the standard EBS naming convention for views that join a base table (the "_B" table) with a translation table (the "_TL" table). In the context of a search for "max_score," this view is significant because it directly exposes the MAX_SCORE column, which defines the upper boundary of a lead scoring range. Lead ranks allow sales organizations to bucket leads by score, and the MIN_SCORE and MAX_SCORE columns together define each rank's scoring band.

Underlying Base Objects

AS_SALES_LEAD_RANKS_VL is defined over two documented base objects, both exposed to the APPS schema as synonyms:

• AS_SALES_LEAD_RANKS_B — the base table holding language-independent rank attributes, including the scoring range (MIN_SCORE, MAX_SCORE), enabled status, and standard WHO audit columns.
• AS_SALES_LEAD_RANKS_TL — the translation table holding language-specific descriptive text (MEANING and DESCRIPTION) keyed by RANK_ID and LANGUAGE.

The view joins these objects on the RANK_ID key and filters the translation side on T.LANGUAGE = USERENV('LANG'), ensuring each session returns only the rows appropriate to the current language environment. This MLS pattern is standard across EBS reference and setup data.

Key Columns

• RANK_ID — primary identifier and the join key between the base and translation tables.
• MIN_SCORE — the lower bound of the score range assigned to the rank.
• MAX_SCORE — the upper bound of the score range. This is the column most directly relevant to a search for "max_score" and is commonly used to determine the highest-scoring rank band.
• ENABLED_FLAG — indicates whether the rank definition is active and available for use.
• MEANING — the translated display name of the rank.
• DESCRIPTION — the translated longer description of the rank.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard WHO tracking.

Common Use Cases and Queries

Because the view resolves translation automatically, it is preferable to querying the base tables directly for any reporting that requires user-facing labels. Typical scenarios include validating score bands, listing active ranks, and identifying the highest max score configured.

List all enabled ranks with their score ranges:

SELECT rank_id, meaning, min_score, max_score
FROM   apps.as_sales_lead_ranks_vl
WHERE  enabled_flag = 'Y'
ORDER BY min_score;

Return the highest configured max score:

SELECT MAX(max_score) AS highest_score
FROM   apps.as_sales_lead_ranks_vl
WHERE  enabled_flag = 'Y';

Locate the rank band covering a specific lead score:

SELECT meaning, min_score, max_score
FROM   apps.as_sales_lead_ranks_vl
WHERE  :lead_score BETWEEN min_score AND max_score
AND    enabled_flag = 'Y';