Search Results as_sales_lead_ranks_tl




Overview
Explore in AI Chat

Overview

The AS_SALES_LEAD_RANKS_TL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing in the OSM schema. Its primary function is to provide multi-lingual support for sales lead ranking data, a critical component of the AS (Sales Foundation) module. As a translation table (denoted by the "_TL" suffix), it stores language-specific descriptions and names for lead rank codes defined in its base table. This enables the application to present lead rank information, such as "Hot," "Warm," or "Cold," in the language of the user's session, supporting global deployments.

Key Information Stored

The table's structure is designed to manage translated text linked to a specific rank identifier and language. The primary key is a composite of RANK_ID and LANGUAGE, ensuring a unique translation entry per rank per language. Key columns include RANK_ID, which is a foreign key linking to the base table AS_SALES_LEAD_RANKS_B, and LANGUAGE, which holds the language code (e.g., 'US', 'FR', 'DE'). The table typically contains columns for the translated name (RANK_NAME) and description (DESCRIPTION), along with standard EBS columns for tracking creation and last update dates, though these specific column names are inferred from common TL table patterns as the provided metadata focuses on relationships.

Common Use Cases and Queries

This table is primarily accessed by the application's runtime engine to display localized lead rank values on forms and reports. A common reporting use case is to generate a list of all lead ranks with their translations for a specific language for auditing or setup purposes. A typical query would join the translation table to its base table to retrieve the code and its translated meaning.

  • Sample Query for Session Language:
    SELECT b.RANK_CODE, tl.RANK_NAME
    FROM AS_SALES_LEAD_RANKS_B b,
         AS_SALES_LEAD_RANKS_TL tl
    WHERE b.RANK_ID = tl.RANK_ID
    AND tl.LANGUAGE = USERENV('LANG');
  • Data Fix Scenario: Updating a specific rank's French translation would target the record where RANK_ID equals the specific identifier and LANGUAGE = 'FR'.

Related Objects

The AS_SALES_LEAD_RANKS_TL table has a direct and essential relationship with its base table, as documented in the provided metadata.

  • AS_SALES_LEAD_RANKS_B: This is the primary related table. AS_SALES_LEAD_RANKS_TL references it via a foreign key constraint where AS_SALES_LEAD_RANKS_TL.RANK_ID = AS_SALES_LEAD_RANKS_B.RANK_ID. The base table (denoted by the "_B" suffix) holds the seed data and code values for which this table provides translations.

In practice, application views (often named without the _B or _TL suffixes) are built upon these tables to present a unified, language-aware interface to other modules and custom reports.