Search Results okl_fe_std_rt_tmp_all_tl




Overview
Explore in AI Chat

Overview

The OKL_FE_STD_RT_TMP_ALL_TL table is a core translation table within the Oracle E-Business Suite (EBS) module OKL - Lease and Finance Management. It functions as the repository for multilingual text associated with Standard Rate Templates. In a global deployment, this table enables the application to store and serve the name and description of a rate template in multiple languages, supporting the NLS (National Language Support) capabilities of Oracle EBS. Its existence is critical for ensuring that financial products and rate structures are presented correctly in the user's preferred language across versions 12.1.1 and 12.2.2. The table operates in conjunction with its base table, storing language-specific translations while the base table holds language-independent data.

Key Information Stored

The table's primary purpose is to store translated textual attributes for a Standard Rate Template. Its structure is defined by a composite primary key and columns for the translated data. The most critical columns include:

  • STD_RATE_TMPL_ID: The foreign key identifier that links the translation row to its corresponding master record in the base Standard Rate Template table. This is a core component of the primary key.
  • LANGUAGE: The code representing the language of the translated text (e.g., 'US' for American English). This column, combined with STD_RATE_TMPL_ID, forms the table's primary key (OKL_FE_STD_RT_TMP_ALL_TL_PK).
  • SOURCE_LANG: A column typically present in EBS translation tables that indicates the original language in which the data was entered.
  • NAME: The translated name of the Standard Rate Template as it should appear in the application interface for the specified language.
  • DESCRIPTION: The translated, detailed description of the Standard Rate Template's purpose and use.

Common Use Cases and Queries

This table is primarily accessed by the Oracle application's internal logic to display template information in a user session's language. For reporting and data extraction, common use cases involve joining to the base table to produce multilingual or language-specific reports on rate templates. A typical query pattern retrieves all translations for a specific template or fetches the template name in a desired language for a list of IDs.

Sample Query: Retrieving the English and French names for a specific set of rate template IDs. 

SELECT b.template_number,
       nls_tl.name as name_en,
       fr_tl.name as name_fr
FROM   okl_fe_std_rt_tmp_all_b b,
       okl_fe_std_rt_tmp_all_tl nls_tl,
       okl_fe_std_rt_tmp_all_tl fr_tl
WHERE  b.std_rate_tmpl_id = nls_tl.std_rate_tmpl_id
AND    nls_tl.language = USERENV('LANG')
AND    b.std_rate_tmpl_id = fr_tl.std_rate_tmpl_id
AND    fr_tl.language = 'F'
AND    b.std_rate_tmpl_id IN (1001, 1002, 1003);

Related Objects

The OKL_FE_STD_RT_TMP_ALL_TL table has a direct and dependent relationship with its corresponding base table. The documented primary key relationship defines the join condition.

  • Base Table (OKL_FE_STD_RT_TMP_ALL_B): This is the primary related object. The STD_RATE_TMPL_ID column in the translation table (TL) is a foreign key referencing the primary key of the base table (B). All translations are child records of a single master record in the base table. A standard join is performed on OKL_FE_STD_RT_TMP_ALL_B.STD_RATE_TMPL_ID = OKL_FE_STD_RT_TMP_ALL_TL.STD_RATE_TMPL_ID.