Search Results jtf_amv_items_vl




Overview
Explore in AI Chat

Overview

JTF_AMV_ITEMS_VL is a multilingual (ML) view owned by the APPS schema in Oracle E-Business Suite, classified under the JTF – CRM Foundation product. Its purpose is to expose "announcement" or "AMV item" records from the base table alongside their translated descriptive text, filtered by the session language. The view joins the base table JTF_AMV_ITEMS_B with the translation table JTF_AMV_ITEMS_TL and restricts the translation row to the language returned by USERENV('LANG'). In this way, the view returns a single, language-appropriate row per AMV item without the caller having to write the translation join explicitly.

In EBS 12.1.1 and 12.2.2, this view behaves identically with respect to its definition; the underlying tables are accessed through synonyms owned by APPS. The object is documented as VALID in the ETRM data dictionary. Because it is a VL (view-language) object rather than a persistent table, it is intended for querying and reporting, and is commonly referenced by CRM Foundation and dependent application code where a localized item name, description, and text string are required. It is a read-oriented construct; inserts and updates are performed against the base and translation tables directly.

Underlying Base Objects

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

  • JTF_AMV_ITEMS_B – the base (non-translated) table holding item-level attributes such as item identifiers, status, dates, ownership, and descriptive flexfield attributes.
  • JTF_AMV_ITEMS_TL – the translation table holding the language-specific item name, description, and text string.

The documented view text joins them as: JTF_AMV_ITEMS_TL T, JTF_AMV_ITEMS_B B WHERE B.ITEM_ID = T.ITEM_ID AND T.LANGUAGE = USERENV('LANG'). All base columns originate from B, while ITEM_NAME, DESCRIPTION, and TEXT_STRING originate from T.

Key Columns

Common Use Cases and Queries

Typical uses include retrieving the localized name of an announcement for a specific language, and building reports of currently active CRM Foundation content. Because the view enforces USERENV('LANG'), query results are automatically constrained to the session language.

To retrieve active items in the current session language:

  • SELECT item_id, item_name, description, status_code FROM jtf_amv_items_vl WHERE status_code = 'PUBLISHED' AND SYSDATE BETWEEN effective_start_date AND expiration_date;

To join localized item text to an application owner and order by priority:

  • SELECT v.item_id, v.item_name, v.priority FROM jtf_amv_items_vl v WHERE v.application_id = :app_id ORDER BY v.priority, v.item_name;

Because translation is bound to the session language, multi-language reporting across several languages requires either separate sessions or direct querying of JTF_AMV_ITEMS_B and JTF_AMV_ITEMS_TL.