Results for “ams_list_headers_vl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- LIST_HEADER_ID — primary identifier for the list header.
- LIST_NAME and DESCRIPTION — translated name and description from AMS_LIST_HEADERS_ALL_TL.
- LIST_TYPE, USER_STATUS_ID, STATUS_CODE, STATUS_DATE, GENERATION_TYPE, ROW_SELECTION_TYPE, REPEAT_EXCLUDE_TYPE — classification and lifecycle attributes.
- OWNER_USER_ID, ASSIGN_PERSON_ID, OWNER_PERSON_ID, ASSIGNED_TO, ACCESS_LEVEL — ownership and access attributes.
- ORG_ID — multi-org operating unit identifier.
- NO_OF_ROWS_INACTIVE — the count of list members that became inactive, along with companion row count columns: NO_OF_ROWS_DUPLICATES, NO_OF_ROWS_MIN_REQUESTED, NO_OF_ROWS_MAX_REQUESTED, NO_OF_ROWS_IN_LIST, NO_OF_ROWS_IN_CTRL_GROUP, NO_OF_ROWS_ACTIVE, NO_OF_ROWS_MANUALLY_ENTERED, NO_OF_ROWS_DO_NOT_CALL, NO_OF_ROWS_DO_NOT_MAIL, and NO_OF_ROWS_RANDOM. These counters summarize the outcome of list generation and deduplication runs.
- FORECASTED_START_DATE, FORECASTED_END_DATE, ACTUAL_END_DATE, SENT_OUT_DATE, LAST_DEDUPE_DATE, DEDUPE_START_DATE — scheduling and execution timestamps.
- ENABLED_FLAG, LIST_ONLINE_FLAG, ARCHIVED_BY, ARCHIVED_DATE — status and archival attributes.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 (and related descriptive flexfield columns) — flexfield support.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.
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.
-
View: AMS_LIST_HEADERS_VL 12.1.1
APPS.AMS_LIST_HEADERS_VL·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LIST_HEADERS_ALL_TL·Explore AMS module →
-
View: AMS_LIST_HEADERS_VL 12.2.2
APPS.AMS_LIST_HEADERS_VL·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LIST_HEADERS_ALL_TL·Explore AMS module →
-
View: IES_AMS_LIST_HEADERS_V 12.2.2
APPS.IES_AMS_LIST_HEADERS_V·↳ AMS_LIST_HEADERS_VL·Explore IES module →
-
View: IES_AMS_LIST_HEADERS_V 12.1.1
APPS.IES_AMS_LIST_HEADERS_V·↳ AMS_LIST_HEADERS_VL·Explore IES module →
-
View: AST_PLIST_NAMES_UWQ_V 12.2.2
APPS.AST_PLIST_NAMES_UWQ_V·↳ AMS_LIST_HEADERS_VL·Explore AST module →
-
View: AST_PLIST_NAMES_UWQ_V 12.1.1
APPS.AST_PLIST_NAMES_UWQ_V·↳ AMS_LIST_HEADERS_VL·Explore AST module →
-
View: AMS_LIST_ENTRIES_UWQ_V 12.2.2
This view is used by Universal Work Queue
APPS.AMS_LIST_ENTRIES_UWQ_V·↳ AMS_ACT_LISTS·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_LIST_ENTRIES·Explore AMS module →
-
View: AMS_LIST_ENTRIES_UWQ_V 12.1.1
This view is used by Universal Work Queue
APPS.AMS_LIST_ENTRIES_UWQ_V·↳ AMS_ACT_LISTS·↳ AMS_CAMPAIGN_SCHEDULES_VL·↳ AMS_LIST_ENTRIES·Explore AMS module →