Results for “interest_use_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AS_INTERESTS_ALL is a Sales Foundation (AS) table owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores product interests, customer classifications, and opportunity classifications captured against parties, contacts, addresses, and leads. In practice, the table acts as the central repository that links a party or prospect to the specific product interest codes and interest types that describe their buying behavior or area of interest. This information supports marketing segmentation, lead qualification, opportunity management, and customer profiling within the Oracle Sales and TeleSales modules.
The documented physical schema contains 43 columns and is classified heuristically as a link table in a Data Vault modeling sense. This classification is a modeling suggestion rather than a functional designation: the table primarily resolves many-to-many relationships between business entities (parties, customers, contacts, addresses, leads) and reference classifications (interest types and interest codes), which is characteristic of a link structure.
Key Information Stored
The surrogate primary key is INTEREST_ID, enforced by the AS_INTERESTS_ALL_PK constraint. A second unique index, AS_INTERESTS_U1, covers INTEREST_ID together with ORG_ID, indicating that the operating unit context is a business-key candidate for uniqueness.
- INTEREST_TYPE_ID — foreign key to AS_INTEREST_TYPES_B (and AS_INTEREST_TYPES_ALL), defining the category of interest being recorded.
- PRIMARY_INTEREST_CODE_ID and SECONDARY_INTEREST_CODE_ID — foreign keys to AS_INTEREST_CODES_B and AS_INTEREST_CODES_ALL, describing the specific interests assigned.
- CUSTOMER_ID — identifies the party or customer; it references both HZ_PARTIES and RA_CUSTOMERS depending on context.
- CONTACT_ID — references HZ_ORG_CONTACTS, associating the interest with a specific contact.
- ADDRESS_ID — references HZ_PARTY_SITES and RA_ADDRESSES_ALL, tying the interest to a party site or address.
- LEAD_ID — references AS_LEADS_ALL, linking the interest to a sales lead.
- INTEREST_USE_CODE — indicates how the interest record is used within the sales process.
- STATUS_CODE — tracks the lifecycle or active status of the interest record.
- DESCRIPTION — free-text detail about the interest.
- ORG_ID — the operating unit that owns the record; SECURITY_GROUP_ID provides additional access control via FND_SECURITY_GROUPS.
- PRODUCT_CATEGORY_ID and PRODUCT_CAT_SET_ID — identify the product category and category set associated with the interest.
- The standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the extensibility columns ATTRIBUTE_CATEGORY through ATTRIBUTE15 support auditing and custom attributes, while OBJECT_VERSION_NUMBER supports optimistic locking.
Common Use Cases and Queries
Typical reporting scenarios include customer interest profiling, lead qualification analysis, and marketing segmentation by product interest. A representative query joining the table to its reference lookup is:
SELECT i.interest_id, i.customer_id, i.lead_id, t.interest_type, c.interest_code
FROM as_interests_all i, as_interest_types_b t, as_interest_codes_b c
WHERE i.interest_type_id = t.interest_type_id
AND i.primary_interest_code_id = c.interest_code_id
AND i.org_id = :p_org_id;
Another common pattern identifies all interests associated with a given customer or lead by filtering on CUSTOMER_ID or LEAD_ID, often restricted by STATUS_CODE to return only active classifications. Marketing users frequently extract records by PRIMARY_INTEREST_CODE_ID to build targeted campaign lists, and by ORG_ID for multi-org reporting.
Related Objects
- AS_LEADS_ALL — joined on LEAD_ID; the lead to which the interest applies.
- HZ_PARTIES — joined on CUSTOMER_ID; the party or customer record.
- RA_CUSTOMERS — joined on CUSTOMER_ID; the receivables customer view of the same party.
- HZ_ORG_CONTACTS — joined on CONTACT_ID; the contact associated with the interest.
- HZ_PARTY_SITES and RA_ADDRESSES_ALL — joined on ADDRESS_ID; the location tied to the interest.
- AS_INTEREST_CODES_B / AS_INTEREST_CODES_ALL — joined on PRIMARY_INTEREST_CODE_ID and SECONDARY_INTEREST_CODE_ID.
- AS_INTEREST_TYPES_B / AS_INTEREST_TYPES_ALL — joined on INTEREST_TYPE_ID.
- FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for access control.
-
Stores product interests, customer and opportunity classifications
-
View: AS_INTERESTS_V 12.2.2
Interests view
APPS.AS_INTERESTS_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
Sales opportunity classifications view
APPS.AS_OPP_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_VL·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
APPS.AST_CONTACT_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AST module →
-
Stores product interests, customer and opportunity classifications
-
View: AS_INTERESTS 12.1.1
Interests (multi-org)
-
View: AS_INTERESTS 12.2.2
Interests (multi-org)
-
Sales opportunity classifications view
APPS.AS_OPP_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_VL·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
View: AS_INTERESTS_V 12.1.1
Interests view
APPS.AS_INTERESTS_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
APPS.AST_CONT_CLASSIFICATION_INT_V·↳ AS_INTERESTS_ALL·↳ AS_LOOKUPS·↳ ENI_PROD_DEN_HRCHY_PARENTS_V·Explore AST module →
-
APPS.AST_CONT_CLASSIFICATION_INT_V·↳ AS_INTERESTS_ALL·↳ AS_LOOKUPS·↳ ENI_PROD_DEN_HRCHY_PARENTS_V·Explore AST module →
-
Site Classification View
APPS.AS_SITE_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
APPS.AST_CONTACT_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AST module →
-
Site Classification View
APPS.AS_SITE_CLASSIFICATION_V·↳ AS_INTERESTS·↳ AS_INTEREST_CODES_V·↳ AS_INTEREST_TYPES_VL·Explore AS module →
-
VIEW: OSM.AS_INTERESTS_ALL# 12.2.2
-
TABLE: OSM.AS_INTERESTS_ALL 12.2.2
-
TABLE: OSM.AS_INTERESTS_ALL 12.1.1
-
VIEW: OSM.AS_INTERESTS_ALL# 12.2.2
-
VIEW: APPS.AST_PRODINTS_MV 12.2.2
-
VIEW: APPS.AS_INTERESTS 12.1.1
-
VIEW: APPS.AS_INTERESTS 12.2.2
-
VIEW: APPS.AST_INTERESTS_MV 12.2.2
-
VIEW: APPS.AS_INTERESTS 12.2.2
-
VIEW: APPS.AS_INTERESTS_V 12.1.1
-
VIEW: APPS.AS_INTERESTS_V 12.2.2
-
VIEW: APPS.AS_INTERESTS 12.1.1