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.
-
For MLS - Translated columns of Interest Codes.
-
For MLS - Translated columns of Interest Codes.
-
View: BIM_DIMV_PROD_LOV 12.1.1
Shows the relationship between interest types, primary interest codes and secondary interest codes.
APPS.BIM_DIMV_PROD_LOV·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·↳ BIM_SALES_CATEGORY_HIER·Explore BIM module →
-
View: BIM_DIMV_PROD_LOV 12.2.2
Shows the relationship between interest types, primary interest codes and secondary interest codes.
APPS.BIM_DIMV_PROD_LOV·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·↳ BIM_SALES_CATEGORY_HIER·Explore BIM module →
-
VIEW: APPS.BIM_DIMV_PROD_LOV 12.1.1
-
View: BIL_DIMV_PROD_LOV 12.1.1
List of values view of product hierarcy
APPS.BIL_DIMV_PROD_LOV·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·↳ BIM_SALES_CATEGORY_HIER·Explore BIL module →
-
View: BIL_DIMV_SLSPROD_HIER 12.1.1
Product hiearchy view
APPS.BIL_DIMV_SLSPROD_HIER·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·↳ AS_INV_ITEM_LOV_V·Explore BIL module →
-
VIEW: APPS.BIM_DIMV_PROD_LOV 12.2.2
-
View: BIL_DIMV_SLSPROD_HIER 12.2.2
Product hiearchy view
Not implemented in this database·Explore BIL module →
-
VIEW: APPS.BIL_DIMV_PROD_LOV 12.1.1
-
not used.
APPS.BIM_DIMV_INTEREST_CODES·↳ AS_INTEREST_CODES_ALL·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore BIM module →
-
View: BIL_DIMV_PROD_LOV 12.2.2
List of values view of product hierarcy
Not implemented in this database·Explore BIL module →
-
View: AMS_CONTACT_PRODUCTS_V 12.1.1
This view is used by Contact Preferences. This view store the interest Types and interet type codes
APPS.AMS_CONTACT_PRODUCTS_V·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_B·Explore AMS module →
-
Primary interest codes view
APPS.BIL_DIMV_PRIM_INT_CODES·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_B·Explore BIL module →
-
View: AS_SALES_LEAD_LINES_V 12.1.1
sales lead line foreign keys
APPS.AS_SALES_LEAD_LINES_V·↳ AMS_P_SOURCE_CODES_V·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·Explore AS module →
-
not used.
APPS.BIM_DIMV_INTEREST_CODES·↳ AS_INTEREST_CODES_ALL·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore BIM module →
-
View: AS_SALES_LEAD_LINES_V 12.2.2
sales lead line foreign keys
APPS.AS_SALES_LEAD_LINES_V·↳ AMS_P_SOURCE_CODES_V·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_TL·Explore AS module →
-
View: BIL_DIMV_SEC_INT_CODES 12.1.1
Secondary interest codes view
APPS.BIL_DIMV_SEC_INT_CODES·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_B·Explore BIL module →
-
View: AS_INTEREST_CODES_VL 12.2.2
MLS Compliant view on _B and _TL tables.
APPS.AS_INTEREST_CODES_VL·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore AS module →
-
Interest codes view
APPS.BIL_DIMV_INTEREST_CODES·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_B·Explore BIL module →
-
View: AMS_CONTACT_PRODUCTS_V 12.2.2
This view is used by Contact Preferences. This view store the interest Types and interet type codes
APPS.AMS_CONTACT_PRODUCTS_V·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·↳ AS_INTEREST_TYPES_B·Explore AMS module →
-
View: AS_INTEREST_CODES_VL 12.1.1
MLS Compliant view on _B and _TL tables.
APPS.AS_INTEREST_CODES_VL·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore AS module →
-
View: AS_INTEREST_CODES_V 12.1.1
Interest Codes (single language, no org-specific information)
APPS.AS_INTEREST_CODES_V·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore AS module →
-
VIEW: APPS.AST_INTERESTS_MV 12.2.2
-
View: AS_INTEREST_CODES_V 12.2.2
Interest Codes (single language, no org-specific information)
APPS.AS_INTEREST_CODES_V·↳ AS_INTEREST_CODES_B·↳ AS_INTEREST_CODES_TL·Explore AS module →