Search Results ams_list_src_fields_vl




Overview
Explore in AI Chat

Overview

AMS_LIST_SRC_FIELDS_VL is a multilingual (translated) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMS – Marketing product family. It presents the list source field definitions used by Oracle Marketing and Oracle Trade Management to describe the columns that may be selected when building marketing lists, list sources, and list entries. The "_VL" suffix denotes a "view with language" — the standard Oracle EBS pattern in which a base table is joined to its translation table and filtered by the session language through USERENV('LANG'). The view is documented as VALID in Oracle ETRM 12.2.2, and the same definition is applicable to 12.1.1.

Functionally, the view exposes both the technical definition of each list source field (physical table, column, data type, size, UI control, lookup associations) and its translated meaning (SOURCE_COLUMN_MEANING). In Oracle EBS reporting and integration, this makes AMS_LIST_SRC_FIELDS_VL the reference object for discovering which fields are available on a given list source, how those fields are presented to users, and how they can be leveraged in list building, analytics, binning, and charting operations.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms in APPS:

The join is an inner equijoin on LIST_SOURCE_FIELD_ID. All non-translated attributes originate from AMS_LIST_SRC_FIELDS; only SOURCE_COLUMN_MEANING is sourced from the translation table. The view therefore returns one row per list source field per matching language.

Key Columns

The most significant columns exposed by the view are:

Common Use Cases and Queries

Typical uses include: identifying enable fields for a list source, mapping field metadata for integration, building LOVs and analytics configurations, and validating UI controls. A representative query:

SELECT list_source_field_id, source_column_name, source_column_meaning,
  field_table_name, field_column_name, field_data_type, enabled_flag
FROM apps.ams_list_src_fields_vl
WHERE list_source_type_id = :p_source_type_id
  AND enabled_flag = 'Y';

A second pattern inspects analytics-eligible fields:

SELECT source_column_name, source_column_meaning, default_chart_type
FROM apps.ams_list_src_fields_vl
WHERE analytics_flag = 'Y'
  AND chart_enabled_flag = 'Y';

Because AMS_LIST_SRC_FIELDS_VL is a synonym-based multilingual view in APPS, it can be queried directly from reports, BI Publisher data models, OAF pages, and concurrent programs without language-specific coding — language filtering is applied automatically via USERENV('LANG').