Results for “jtf_um_subscriptions_vl”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_UM_SUBSCRIPTIONS_VL is a multi-lingual (MLS) view owned by the APPS schema within the JTF – CRM Foundation product. It exposes subscription definitions maintained by the Oracle User Management (UM) framework, which governs self-service registration, delegated administration, and notification subscriptions in Oracle E-Business Suite. Because it is a "VL" (view with language) object, it joins the base table with its translation table and narrows results to the language of the current session via USERENV('LANG'). For reporting and integration, the view therefore presents one row per subscription with its translated name and description, avoiding the need for callers to explicitly join the base and translation tables.

Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and no structural changes to the documented column list are noted between these releases. The object is commonly referenced when auditing which subscriptions exist, whether they are enabled, and when they are available to end users.

Underlying Base Objects

The view is defined over two synonyms: JTF_UM_SUBSCRIPTIONS_B (the base table holding language-independent attributes) and JTF_UM_SUBSCRIPTIONS_TL (the translation table holding SUBSCRIPTION_NAME and DESCRIPTION). The join condition is:

  • B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID — links each base subscription to its translated text.
  • T.LANGUAGE = USERENV('LANG') — restricts output to the session language.

All columns except the translated text are drawn from the _B table; SUBSCRIPTION_NAME and DESCRIPTION come from the _TL table. ROW_ID is exposed from the base table's ROWID, allowing downstream tools to identify the physical row.

Key Columns

Common Use Cases and Queries

Typical uses include reporting on enabled subscriptions, filtering by availability behavior, and tracing parent-child subscription hierarchies in the User Management framework.

List active subscriptions with their translated names:

  • SELECT subscription_id, subscription_key, subscription_name, availability_code, enabled_flag FROM jtf_um_subscriptions_vl WHERE enabled_flag = 'Y';

Filter specifically on availability behaviour (matching the user's search term):

  • SELECT subscription_id, subscription_name, availability_code, logon_display_frequency FROM jtf_um_subscriptions_vl WHERE availability_code IS NOT NULL ORDER BY availability_code, subscription_name;

Review subscription hierarchies:

  • SELECT child.subscription_name AS child_name, parent.subscription_name AS parent_name FROM jtf_um_subscriptions_vl child, jtf_um_subscriptions_vl parent WHERE child.parent_subscription_id = parent.subscription_id;

Because the view enforces the session-language predicate, queries return text in USERENV('LANG'); users requiring all translations must query JTF_UM_SUBSCRIPTIONS_TL directly.