Search Results ams_list_headers_vl




Overview
Explore in AI Chat

Overview

AMS_LIST_HEADERS_VL is a Marketing (AMS) module view owned by the APPS schema and registered as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a translation ("_VL", or view-language) view built over the list header entity in Oracle Marketing, specifically over AMS_LIST_HEADERS_ALL and its translation table AMS_LIST_HEADERS_ALL_TL. The view presents master list definition data together with the language-specific list name and description resolved for the current session language.

In the EBS reporting and integration layer, this view functions as the standard read interface for list headers. Marketing list headers define the identity, ownership, type, status, and generation parameters of a marketing list, along with the aggregate row counts produced during list generation and deduplication. External reports, concurrent programs, and integration extracts that need a user-readable list name (rather than an untranslated identifier) query the _VL view rather than the underlying _ALL table. This behavior is consistent with EBS multi-language support conventions, where the translatable attributes are stored in a separate _TL table and exposed through a _VL view.

Underlying Base Objects

According to the documented ETRM 12.2.2 metadata, AMS_LIST_HEADERS_VL is defined over two referenced base objects, both exposed as synonyms:

  • AMS_LIST_HEADERS_ALL (SYNONYM) — the core list header table storing non-translatable attributes such as identifiers, status, type, generation parameters, row counts, and descriptive flexfield attributes.
  • AMS_LIST_HEADERS_ALL_TL (SYNONYM) — the translation table storing language-dependent values, principally LIST_NAME and DESCRIPTION.

The view joins the two sources on the list header identifier, returning the column set of the header table plus the translated LIST_NAME and DESCRIPTION from the translation table. The view text documented for the object confirms this structure: the SELECT list references columns from the header alias (LH) and returns LT.LIST_NAME and LT.DESCRIPTION from the translation alias. Because it is a _VL view, it is designed to return one row per list header in the applicable language context.

Key Columns

The view exposes the complete attribute set of the list header entity. The most commonly referenced columns include:

Common Use Cases and Queries

The view is typically used to report on marketing list definitions, to audit generation results, and to feed downstream campaigns or extracts. A frequent requirement is identifying lists with an unusual number of inactive rows, which corresponds directly to the search term "no_of_rows_inactive". The following query lists such headers:

  • SELECT list_header_id, list_name, list_type, status_code, no_of_rows_in_list, no_of_rows_active, no_of_rows_inactive FROM apps.ams_list_headers_vl WHERE org_id = :p_org_id AND no_of_rows_inactive > 0 ORDER BY no_of_rows_inactive DESC;
  • SELECT list_header_id, list_name, generation_type, last_generation_success_flag FROM apps.ams_list_headers_vl WHERE list_type = :p_type AND enabled_flag = 'Y';
  • SELECT list_header_id, list_name, sent_out_date, no_of_rows_duplicates FROM apps.ams_list_headers_vl WHERE sent_out_date BETWEEN :p_from AND :p_to;

Because the view is owned by APPS and defined over synonyms to the base tables, reports should reference it with the APPS schema prefix or through a public synonym, and should generally filter by ORG_ID in multi-org environments. As a translation view, it provides the correct language-specific list name for interactive and printed output while retaining full access to the numeric generation counters, including NO_OF_ROWS_INACTIVE, required for list quality analysis.