Search Results mtl_item_catalog_groups_tl




Overview
Explore in AI Chat

Overview

The MTL_ITEM_CATALOG_GROUPS_TL table is a core data object within the Oracle E-Business Suite Inventory (INV) module, specifically designed to support multilingual implementations. It functions as the translation table for the MTL_ITEM_CATALOG_GROUPS_B base table. Its primary role is to store language-specific textual descriptions for Item Catalog Groups, enabling the display of group descriptions in a user's preferred language within the application interface. This separation of translatable data from the core transactional data is a standard architectural pattern in Oracle EBS that facilitates global deployment and localization.

Key Information Stored

The table's structure is optimized for storing translated content. Its primary key is a composite of ITEM_CATALOG_GROUP_ID and LANGUAGE, ensuring a unique description for each group per language. The most critical column is DESCRIPTION, which holds the translated text for the catalog group. Other standard translation table columns include SOURCE_LANG, which records the original language of the entered data, and CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for tracking row history. The LANGUAGE column typically uses Oracle's language codes (e.g., 'US' for American English, 'D' for German).

Common Use Cases and Queries

The primary use case is retrieving a catalog group's description in the current session language for UI display or reporting. A typical query joins this table with its base table, filtering on the LANGUAGE column using the database session's language context. For example, to list all catalog groups with their translated descriptions, one might use:

  • SELECT b.ITEM_CATALOG_GROUP_ID, tl.DESCRIPTION, tl.LANGUAGE
  • FROM INV.MTL_ITEM_CATALOG_GROUPS_B b,
  • INV.MTL_ITEM_CATALOG_GROUPS_TL tl
  • WHERE b.ITEM_CATALOG_GROUP_ID = tl.ITEM_CATALOG_GROUP_ID
  • AND tl.LANGUAGE = userenv('LANG');

Data maintenance for this table is typically performed via the Oracle Applications' standard translation forms or APIs, not via direct SQL manipulation, to ensure integrity with the base table and the EBS translation architecture.

Related Objects

This table has a direct and essential relationship with the MTL_ITEM_CATALOG_GROUPS_B table, as indicated by its foreign key. The foreign key constraint on ITEM_CATALOG_GROUP_ID enforces referential integrity, ensuring every translated description corresponds to a valid base catalog group record. The table is also integral to the overall Item Catalog functionality, which may involve other entities like MTL_ITEM_CATALOGS and MTL_ITEM_CATALOG_GROUP_VALUES. Any application forms, reports, or APIs that display catalog group descriptions will inherently depend on this translation table when operating in a multi-language environment.