Search Results job_title_code




Overview
Explore in AI Chat

Overview

AS_LIST_ENTRIES 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 the individual rows, or entries, that make up a marketing list or promotion list, capturing the customer, address, contact, phone, and lead details associated with each listed party. The documented description is simply "Holds list entries," reflecting its function as the transactional detail store for list-based marketing, telemarketing, and collateral distribution activity.

The table is registered as VALID with a documented physical schema spanning 197 columns, making it one of the wider list-management tables in the AS module. Following the heuristic Data Vault classification derived from its foreign-key structure, AS_LIST_ENTRIES is satellite-leaning: it carries descriptive attributes and denormalized snapshot data (names, addresses, phone numbers, fiscal metrics, user-defined columns) tied to a parent list and to referenced master entities, rather than acting as a pure hub or link.

Key Information Stored

The surrogate primary key is LIST_ENTRY_ID, enforced by AS_LIST_ENTRIES_PK and backed by the unique index AS_LIST_ENTRIES_U1, which serves as the documented business-key candidate. Core identifying and relationship columns include:

Additional denormalized clusters include customer, address, and contact user-defined columns (CUSTOMER_USER_DEFINED1–15, ADDRESS_USER_DEFINED1–15, CONTACT_USER_DEFINED1–26), plus up to five address phone and five contact phone slot groups, confirming the table's role as a flattened working set rather than a normalized master.

Common Use Cases and Queries

Typical scenarios include retrieving all entries for a promotion, reconciling list membership to customer master, and reporting on list coverage or potential revenue. A common query pattern joins the entry to its parent promotion and customer:

  • SELECT le.list_entry_id, le.company_name, le.last_name, le.email_address FROM as_list_entries le WHERE le.list_id = :p_list_id
  • SELECT le.list_entry_id, c.customer_name FROM as_list_entries le, ra_customers c WHERE le.customer_id = c.customer_id
  • SELECT le.list_id, COUNT(*) FROM as_list_entries le GROUP BY le.list_id for list-volume reporting.
  • Filtering on MARKED_FLAG or TRANSFER_FLAG to isolate entries selected for a campaign run or transfer batch.

Related Objects

  • AS_PROMOTIONS_ALL — parent list/promotion; joined on LIST_ID.
  • RA_CUSTOMERS — customer master; joined on CUSTOMER_ID.
  • RA_ADDRESSES_ALL — address master; joined on ADDRESS_ID.
  • RA_PHONES — phone master; joined on PHONE_ID.
  • AS_LEADS_ALL — lead master; joined on LEAD_ID.
  • AS_COLLATERAL_REQ_ALL — references AS_LIST_ENTRIES.LIST_ENTRY_ID.
  • AMS_LIST_ENTRY_USAGES — tracks usage of each entry; joined on LIST_ENTRY_ID.
  • IES_SVY_LIST_ENTRIES and IES_SVY_RESPONSES — survey integration referencing LIST_ENTRY_ID.
  • EGO_REPORT_LIST_ENTRIES — reporting integration referencing the same key.
  • AMS_TCOP_FATIGUED_BY — telemarketing fatigue tracking referencing LIST_ENTRY_ID.