Search Results amv_c_channels_vl




Overview
Explore in AI Chat

Overview

AMV_C_CHANNELS_VL is a multilingual (ML) view in the Oracle E-Business Suite Marketing Encyclopedia System (AMV) product family. It presents channel definitions that are translated according to the session language of the querying user, resolving translated name and description text for each channel record. It is owned by the APPS schema and is documented as VALID in both EBS 12.1.1 and 12.2.2.

The view's role is to provide a language-aware, read-only projection of channel data. Oracle EBS reporting, OA Framework pages, and integration interfaces reference this view rather than the underlying base and translation tables directly, so that users see channel names and descriptions in their own language while the underlying identifiers and business attributes remain language-independent. Because the "_VL" suffix denotes a view that joins base and translation tables and filters on USERENV('LANG'), the view returns exactly one translated row per channel for the current session language.

Underlying Base Objects

The documented view text joins two synonyms that resolve to the base and translation tables of the AMV channel entity:

  • AMV_C_CHANNELS_B (SYNONYM) — the base table holding language-independent channel attributes, aliased as B. It provides the channel identifier, category, type, status, ownership, approval flags, notification settings, and descriptive flexfield columns.
  • AMV_C_CHANNELS_TL (SYNONYM) — the translation table, aliased as T. It supplies the language-specific CHANNEL_NAME and DESCRIPTION, and is joined on CHANNEL_ID with a filter of T.LANGUAGE = USERENV('LANG').

The join condition is B.CHANNEL_ID = T.CHANNEL_ID. The view also exposes B.ROWID as ROW_ID, and carries standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER from the base table.

Key Columns

Common Use Cases and Queries

The view is typically queried to list channels in the user's language, to inspect external-access and matching configuration, and to drive integration extracts. A typical listing query:

  • SELECT CHANNEL_ID, CHANNEL_NAME, STATUS, EXTERNAL_ACCESS_FLAG FROM APPS.AMV_C_CHANNELS_VL;
  • Filter on external access: SELECT CHANNEL_ID, CHANNEL_NAME FROM APPS.AMV_C_CHANNELS_VL WHERE EXTERNAL_ACCESS_FLAG = 'Y';
  • Identify active channels within a validity window: ... WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EXPIRATION_DATE;
  • Review approval and matching setup: ... WHERE PUB_NEED_APPROVAL_FLAG = 'Y' AND MATCH_ON_KEYWORD_FLAG = 'Y';

Because the view returns only the session-language translation, reports intended to show all languages must query AMV_C_CHANNELS_TL directly. As the view filters on USERENV('LANG'), ensure the reporting session or concurrent program is initialized with the appropriate language for reliable translated output.