Results for “as_interest_codes_tl”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AS_INTEREST_CODES_TL is a translated (multi-language support, or MLS) table residing in the OSM schema within the AS – Sales Foundation product family of Oracle E-Business Suite. Its documented purpose is to hold the translated columns for Interest Codes, which are reference values used by Oracle Sales and its related modules to classify interest categories associated with customers, opportunities, or leads. Because Oracle EBS stores user-facing descriptive text in translatable columns while keeping language-neutral attributes in the base table, AS_INTEREST_CODES_TL functions as the translation storefront of the Interest Codes entity, carrying one row per language for a given interest code identifier.

The ETRM metadata classifies this object heuristically as satellite-leaning within a Data Vault modeling exercise. In that interpretation, AS_INTEREST_CODES_B would serve as the hub holding the durable business key (the interest code identifier), while AS_INTEREST_CODES_TL behaves as a satellite capturing descriptive, language-dependent attributes attached to that hub. This classification is a modeling suggestion, not a physical designation, since the table is an ordinary normalized EBS base table with foreign keys and unique indexes rather than a formal Data Vault construct.

Key Information Stored

The table contains eleven documented columns. The following are the most significant for querying, integration, and reporting:

  • INTEREST_CODE_ID — Surrogate identifier for the interest code. Part of the primary key AS_INTEREST_CODES_ALL_TL_PK together with LANGUAGE, and the column joined back to the base table AS_INTEREST_CODES_B.
  • LANGUAGE — The language code identifying which translation this row supplies. Also part of the primary key.
  • SOURCE_LANG — The source language from which this translation was derived, used by the MLS translation mechanism to track the origin language of the text.
  • CODE — The interest code value itself; included in the unique business-key candidate AS_INTEREST_CODES_TL_U2 (CODE, INTEREST_CODE_ID, LANGUAGE) and in AS_INTEREST_CODES_TL_UK.
  • DESCRIPTION — The translated descriptive text of the interest code, the principal user-facing attribute of this table.
  • SECURITY_GROUP_ID — Multi-org / security grouping reference, with a documented foreign key to FND_SECURITY_GROUPS, controlling row-level access.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each translation row and when.

The surrogate primary key is AS_INTEREST_CODES_ALL_TL_PK on (INTEREST_CODE_ID, LANGUAGE). The documented unique indexes serve as business-key candidates: AS_INTEREST_CODES_TL_U1 on (INTEREST_CODE_ID, LANGUAGE) and AS_INTEREST_CODES_TL_U2 on (CODE, INTEREST_CODE_ID, LANGUAGE).

Common Use Cases and Queries

The primary use case is retrieving the user-facing description of an interest code in the session language, typically by joining to the base table and filtering on LANGUAGE. A representative query pattern:

  • SELECT b.INTEREST_CODE_ID, t.DESCRIPTION FROM AS_INTEREST_CODES_B b, AS_INTEREST_CODES_TL t WHERE b.INTEREST_CODE_ID = t.INTEREST_CODE_ID AND t.LANGUAGE = USERENV('LANG').
  • Reporting on all available translations for a given code by selecting across LANGUAGE, e.g. WHERE INTEREST_CODE_ID = :id ORDER BY LANGUAGE.
  • Data-audit queries reconciling CREATION_DATE and LAST_UPDATE_DATE to identify recently added or modified translations.
  • Integration or extract scripts that pull CODE and DESCRIPTION pairs for downstream CRM or data-warehouse loads, constrained by SECURITY_GROUP_ID where operating in a multi-org context.

Related Objects

The following objects are most significant in relation to this table, based on the documented foreign-key and primary-key relationships:

  • AS_INTEREST_CODES_B — The base (language-neutral) table; join key AS_INTEREST_CODES_TL.INTEREST_CODE_ID → AS_INTEREST_CODES_B.INTEREST_CODE_ID.
  • AS_INTEREST_CODES_ALL_TL_PK — The primary key constraint on (INTEREST_CODE_ID, LANGUAGE).
  • AS_INTEREST_CODES_TL_U1 / AS_INTEREST_CODES_TL_U2 — Unique indexes defining business-key candidates.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for row-level security.
  • AS_INTEREST_CODES_VL — The MLS view that typically unions or joins the base and translated tables to present a single logical view of interest codes with descriptions.

Together these objects form the Interest Codes entity within the AS – Sales Foundation module, with AS_INTEREST_CODES_TL supplying the translated descriptive layer.