Search Results jtf_nav_viewbys_tl




Overview
Explore in AI Chat

Overview

JTF_NAV_VIEWBYS_TL is a translation (TL) table in the JTF schema, the CRM Foundation product within Oracle E-Business Suite. It stores the multilingual labels that populate "View By" drop-down lists in CRM navigation user interfaces. Each row pairs a view-by identifier with a language-specific label, enabling the same navigational control to present localized text to users across different language installations. The table belongs to the standard EBS translated-table pattern, in which a base (B) table holds language-independent attributes and the TL table holds the translated descriptive columns keyed by language.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as satellite-leaning. The VIEWBY_ID foreign key to JTF_NAV_VIEWBYS_B positions the TL table as an attribute satellite hanging off the base entity hub, with LANGUAGE acting as part of the descriptive context and the composite key. This classification is a heuristic suggestion drawn from the FK topology and should be treated as modeling guidance rather than a declared design intent.

Key Information Stored

The table contains eleven documented columns. The most significant are:

The primary key is defined by JTF_NAV_VIEWBYS_TL_PK on (VIEWBY_ID, LANGUAGE). The unique index JTF_NAV_VIEWBYS_TL_U1 on (VIEWBY_ID, LANGUAGE, ZD_EDITION_NAME) is the business-key candidate, extending the PK with the edition name to support multi-edition coexistence during online patching.

Common Use Cases and Queries

The primary use case is retrieving a localized label for a view-by control. A typical query joins the TL table to the base table filtered by language:

  • Resolve a display label: SELECT b.viewby_id, t.viewby_label FROM jtf_nav_viewbys_b b, jtf_nav_viewbys_tl t WHERE b.viewby_id = t.viewby_id AND t.language = USERENV('LANG').
  • Audit missingor stale translations: count languages per VIEWBY_ID in the TL table against the expected language set.
  • Migration and comparison reporting: extract VIEWBY_ID, VIEWBY_LABEL, LANGUAGE, and SOURCE_LANG to verify translation coverage before upgrades or localization rollouts.
  • Edition-aware extraction for 12.2.x: include ZD_EDITION_NAME in the predicate to isolate the active edition.

Related Objects

The following objects are most directly related to this table:

  • JTF_NAV_VIEWBYS_B — the base table; join on JTF_NAV_VIEWBYS_TL.VIEWBY_ID = JTF_NAV_VIEWBYS_B.VIEWBY_ID (enforced FK).
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for row-level security partitioning.
  • JTF_NAV_VIEWBYS_TL_PK — the primary key constraint on (VIEWBY_ID, LANGUAGE).
  • JTF_NAV_VIEWBYS_TL_U1 — the unique index supporting the business key with ZD_EDITION_NAME.
  • FND_LANGUAGES — the reference for valid values in LANGUAGE and SOURCE_LANG.