Search Results as_interest_types_tl




Overview
Explore in AI Chat

Overview

The AS_INTEREST_TYPES_TL table is a core translation table within the Oracle E-Business Suite Sales Foundation module (AS). It is owned by the OSM schema and is integral to the Multi-Language Support (MLS) architecture. Its primary role is to store translated, language-specific descriptions for Interest Types, enabling the application to display user-facing text in the language of the user's session. This table operates in conjunction with its base table, AS_INTEREST_TYPES_B, which holds the language-independent, seed data for Interest Types. The existence of this TL table is a standard Oracle Applications pattern, ensuring the global usability of the Sales Foundation module.

Key Information Stored

The table stores the translated attributes for Interest Types. Its structure is defined by a composite primary key that uniquely identifies a translation row for a specific Interest Type in a specific language. The key columns are INTEREST_TYPE_ID, which links to the base table, and LANGUAGE, which holds the language code (e.g., 'US' for American English). The primary translated column is INTEREST_TYPE, which holds the descriptive name of the interest type (e.g., "Product Interest," "Service Inquiry") in the corresponding language. Other standard translation table columns, such as SOURCE_LANG, CREATION_DATE, and LAST_UPDATE_DATE, are also present to manage data lineage and synchronization.

Common Use Cases and Queries

The primary use case is the dynamic rendering of translatable strings within the Sales Foundation application's user interface and reports. When a user queries a list of interest types, the application joins this table to the base table, filtering by the user's session language. A common reporting query involves selecting all translations for a given interest type or verifying translation coverage. For example, to retrieve the Spanish translation for all active interest types, a developer might use a query such as:

  • SELECT b.SEEDED_FLAG, tl.INTEREST_TYPE, tl.LANGUAGE FROM AS_INTEREST_TYPES_B b, AS_INTEREST_TYPES_TL tl WHERE b.INTEREST_TYPE_ID = tl.INTEREST_TYPE_ID AND tl.LANGUAGE = 'ES';

Data maintenance is typically performed via the application's MLS administration screens or dedicated seed data scripts, not via direct DML.

Related Objects

AS_INTEREST_TYPES_TL has a direct and critical relationship with its base table, as defined by the documented foreign key. The relationships are as follows:

  • Primary Foreign Key Relationship: AS_INTEREST_TYPES_TL.INTEREST_TYPE_ID references AS_INTEREST_TYPES_B.INTEREST_TYPE_ID. This is a mandatory relationship; every translation row must correspond to a valid record in the base table.
  • Base Table: AS_INTEREST_TYPES_B contains the non-translatable, seed data for Interest Types. All transactional data and application logic that references an Interest Type will use the INTEREST_TYPE_ID from this base table, with the TL table providing the appropriate description based on context.

Given its function, this table is also indirectly related to any application forms, reports, or APIs within the Sales Foundation module that present or manage Interest Type data.