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.

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.