Search Results cs_sr_link_types_tl




Overview
Explore in AI Chat

Overview

The CS_SR_LINK_TYPES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the multilingual repository for user-facing text associated with service request link types. Its primary role is to store the translated name and description for each link type defined in the base table, CS_SR_LINK_TYPES_B. This architecture enables the application to present link type information in the language of the user's session, supporting global deployments. The table is a critical component for maintaining data integrity and user experience in the service request linking functionality.

Key Information Stored

The table's structure is designed to support multi-language data. The primary key uniquely identifies a translation record for a specific link type and language. Key columns include:

  • LINK_TYPE_ID: The foreign key to the base table CS_SR_LINK_TYPES_B. It identifies the core link type being translated.
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translated text. Combined with LINK_TYPE_ID, it forms the table's primary key.
  • NAME: The translated, user-displayable name for the link type (e.g., "Related To", "Caused By").
  • DESCRIPTION: The translated description providing further detail about the purpose and usage of the link type.
  • SOURCE_LANG: A standard column in EBS translation tables that records the original language in which the data was entered.

Common Use Cases and Queries

This table is primarily accessed to retrieve localized link type information for UI display and reporting. A common use case is populating a list of values (LOV) for selecting a link type when creating a relationship between service requests. For reporting, it is used to join translated names onto base data. A typical query pattern retrieves translations for the current session language using the NLS_LANGUAGE parameter or a specific language code.

Sample Query:
SELECT lt_b.LINK_TYPE_CODE,
       lt_tl.NAME,
       lt_tl.DESCRIPTION
FROM CS_SR_LINK_TYPES_B lt_b,
     CS_SR_LINK_TYPES_TL lt_tl
WHERE lt_b.LINK_TYPE_ID = lt_tl.LINK_TYPE_ID
AND lt_tl.LANGUAGE = USERENV('LANG');

Related Objects

The table has a direct and singular dependency on the base definition table, as documented in the provided metadata. The relationship is enforced via a foreign key constraint.

  • CS_SR_LINK_TYPES_B: This is the primary related object. The CS_SR_LINK_TYPES_TL table references it through the foreign key column LINK_TYPE_ID. All translation records are child records of a parent row in this base table, which holds the seed code and non-translatable attributes for each link type.