Search Results source_object_name




Overview
Explore in AI Chat

Overview

AMS_DATASRC_ATTBINFO_VL is an Oracle Application Object Library (APPS) view in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the AMS (Marketing) product family and is documented in the E-Business Suite Technical Reference Manual (ETRM) as a valid, compiled database object. The view's stated purpose is to construct the data source Hgrid displayed within the audience administration workbench, a graphical component used by marketing users to select and configure the source of audience and target segments.

Functionally, the view presents a consolidated list of data sources and their associated attributes, drawing together source-level definitions and field-level definitions into a single queryable structure. The _VL suffix indicates that the view exposes translated, language-dependent list source names, rather than raw untranslated identifiers. This makes it suitable for presentation-layer consumption in forms, workflow, and OAF-based marketing screens, where names must respect the session language.

Underlying Base Objects

The ETRM metadata documents three referenced objects underpinning this view:

  • AMS_LIST_SRC_TYPES_VL (VIEW) — Supplies the list source type definitions, including the list source name, source object name, source type code, and the list source type classification (for example, ANALYTICS or TARGET).
  • AMS_LIST_SRC_FIELDS_VL (VIEW) — Supplies the field-level definitions belonging to each list source type, including the source column name, its meaning, the field data type, and any associated attribute LOV reference.
  • AMS_LIST_SRC_TYPE_ASSOCS (SYNONYM) — Provides the association between source types, specifically the sub source type to master source type relationship used to link a source to its parent or master.

The view text is a UNION of two SELECT statements. The first branch derives master-level rows through the association table joined to the enabled list source types, restricting to LIST_SOURCE_TYPE IN ('ANALYTICS', 'TARGET') and requiring both the source type and association enabled flags to equal 'Y'. The second branch derives field-level rows by joining enabled list source types to enabled list source fields where the field column name is not null. Consequently, the view yields one set of rows representing whole data sources and a second set representing the individual attributes selectable within each source.

Key Columns

  • ID — In the first branch, carries the sub source type identifier; in the second branch, a literal -1 distinguishes field-level rows.
  • NAME — The presented display name: the list source name for source-level rows, or the source column meaning for field-level rows.
  • SELECT_WHERE — The source column name for field-level rows; set to the literal 'DUMMY' for source-level rows.
  • FROM_CLAUSE — The underlying source object name used to resolve the data source.
  • ALIAS — The source type code, used as the aliasing identifier for the source.
  • SRC_FLD_ID — The list source field identifier; -1 for source-level rows.
  • MASTER_SRC_TYPE_ID — The master source type identifier; equals the sub source type ID in the first branch and the list source type ID in the second.
  • DISABLED — Indicates selectability: 'Y' for source-level rows, 'N' for field-level rows.
  • SOURCE_COLUMN_NAME, SOURCE_COLUMN_MEANING, FIELD_DATA_TYPE — Field-level physical column, its meaning, and its data type.
  • ATTB_LOV_ID — Attribute LOV identifier; -1 at source level, the field's LOV at attribute level.
  • DATA_SOURCE_NAME — The translated list source name associated with the row.

Common Use Cases and Queries

The view is principally consumed by the marketing audience administration workbench to populate the data source Hgrid. Typical queries enumerate available source types, list attributes for a chosen source, or resolve data types prior to segment building.

  • Listing all enabled, selectable data sources: SELECT id, name, from_clause, alias FROM apps.ams_datasrc_attbinfo_vl WHERE disabled = 'Y';
  • Enumerating attributes for the parent source: SELECT name, source_column_name, field_data_type FROM apps.ams_datasrc_attbinfo_vl WHERE master_src_type_id = :p_source_type_id AND disabled = 'N';
  • Joining to source metadata for reporting: SELECT v.data_source_name, v.source_column_meaning, v.attb_lov_id FROM apps.ams_datasrc_attbinfo_vl v WHERE v.source_column_name IS NOT NULL;

Because the view exposes translation-aware names and enabled-flag filtering internally, callers need not re-apply enablement predicates; however, joining to attribute LOV views remains necessary where LOV values must be displayed.