Search Results csd_repair_types_tl




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_TYPES_TL table is a core data object within the Oracle E-Business Suite (EBS) Depot Repair (CSD) module, specifically in versions 12.1.1 and 12.2.2. As a translation (TL) table, its primary role is to store multilingual descriptions for repair types defined in the base table, CSD_REPAIR_TYPES_B. This structure is a standard Oracle Applications pattern, enabling a single repair type definition to be presented in multiple languages, which is critical for global deployments. The table is integral to the user interface, ensuring that repair type names and descriptions appear correctly in the language of the user's session, thereby supporting international operations.

Key Information Stored

The table holds language-specific textual attributes for repair types. Its structure is defined by a composite primary key and descriptive columns. The key columns are REPAIR_TYPE_ID, which links to the base table CSD_REPAIR_TYPES_B, and LANGUAGE, which contains the language code (e.g., 'US', 'DE') and references FND_LANGUAGES. The primary descriptive column is typically named REPAIR_TYPE_NAME or a similar variant, storing the translated name of the repair type. Additional columns may include a DESCRIPTION field for detailed explanations, and standard Oracle columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing purposes.

Common Use Cases and Queries

This table is primarily accessed to retrieve user-friendly, localized labels for reporting, data extracts, and application logic. A common scenario is generating a report of all active repair types in the user's current language. The following sample SQL pattern demonstrates a typical join to obtain translated data:

  • SELECT b.REPAIR_TYPE_CODE, tl.REPAIR_TYPE_NAME, tl.DESCRIPTION FROM CSD_REPAIR_TYPES_B b, CSD_REPAIR_TYPES_TL tl WHERE b.REPAIR_TYPE_ID = tl.REPAIR_TYPE_ID AND tl.LANGUAGE = USERENV('LANG') AND b.ENABLED_FLAG = 'Y';

Another critical use case is during data migration or setup, where seed data for repair types must be populated with translations for all supported languages. Application developers query this table to populate list of values (LOVs) and form fields within the Depot Repair application.

Related Objects

CSD_REPAIR_TYPES_TL has defined foreign key relationships with two key tables, as documented in the provided metadata:

  • CSD_REPAIR_TYPES_B: This is the base table for repair type definitions. The foreign key is on the column CSD_REPAIR_TYPES_TL.REPAIR_TYPE_ID, which references CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID. All translation records are child records of a master definition in this base table.
  • FND_LANGUAGES: This Oracle Applications Foundation table stores installed language information. The foreign key is on the column CSD_REPAIR_TYPES_TL.LANGUAGE, which references FND_LANGUAGES.LANGUAGE_CODE. This ensures that translations are only created for valid, active application languages.

The table's primary key constraint, CSD_REPAIR_TYPES_TL_PK, enforces uniqueness on the combination of REPAIR_TYPE_ID and LANGUAGE, preventing duplicate translations for the same language.