Search Results lead_classification_flag




Overview
Explore in AI Chat

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

Overview

AS_INTEREST_TYPES_B is the base (non-translated) definition table for Interest Types in the Oracle E-Business Suite AS – Sales Foundation product family. It resides in the OSM schema and stores the master list of interest types used throughout the Sales, Marketing, TeleSales, Quoting, and Territory Management modules to classify a party's, lead's, or opportunity's area of interest. In ETRM 12.2.2 the table is documented as VALID with 17 columns.

From a Data Vault modeling perspective, this table is best characterized as hub-leaning. Its immutable business entity is the interest type itself, keyed by a stable surrogate identifier and referenced by a large number of surrounding transactional and cross-reference tables.

Key Information Stored

The table's primary key is the single-column constraint AS_INTEREST_TYPES_B_PK defined on INTEREST_TYPE_ID, which is also the unique index business-key candidate (AS_INTEREST_TYPES_B_U1). Because the surrogate key and the business key are the same column, INTEREST_TYPE_ID functions as both the technical identity and the operational reference used by every dependent table.

Common Use Cases and Queries

Typical queries resolve enabled interest types for picklists, validate references before insert into child tables, and join to the translated table for display names.

  • List active interest types: 
    SELECT interest_type_id, enabled_flag
FROM   as_interest_types_b
WHERE  enabled_flag = 'Y';
  • Display interest types with translations: 
    SELECT b.interest_type_id, t.interest_type
FROM   as_interest_types_b b, as_interest_types_tl t
WHERE  b.interest_type_id = t.interest_type_id
AND    t.language = USERENV('LANG');
  • Reporting and integration extracts commonly join AS_INTEREST_TYPES_ALL to transaction lines for classification analysis.

Related Objects

The table is heavily referenced, confirming its hub role. Significant dependents and the join columns include: