Search Results jtf_grid_cols_vl




Overview
Explore in AI Chat

Overview

JTF_GRID_COLS_VL is a Multi-Language Support (MLS) validation view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the JTF – CRM Foundation product family and presents translatable column-definition metadata for the grid (tabular) user interface components used across CRM applications. The view joins the base table JTF_GRID_COLS_B, which stores language-independent grid column attributes, with JTF_GRID_COLS_TL, which stores the translatable label text for each column. Because it is a _VL view, it returns one row per grid column in the session's current language, resolved through USERENV('LANG'). The status is documented as VALID.

The view is the primary supported interface for querying grid column configuration, including the VISIBLE_FLAG attribute that governs whether a given column is displayed to the end user. It is used for reporting on grid layouts, diagnosing display behavior, and integration scenarios where external tools must understand the structure of a CRM grid datasource.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms:

The join condition is B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME AND B.GRID_COL_ALIAS = T.GRID_COL_ALIAS AND T.LANGUAGE = USERENV('LANG'). The view also exposes ROW_ID from B.ROWID. Consequently, a column definition appears in this view only if a translation row exists for the active language; otherwise the column is filtered out entirely.

Key Columns

Common Use Cases and Queries

Typical uses include auditing which columns are visible on a given grid datasource, comparing visibility configuration across environments, and feeding metadata to integration layers.

List all visible columns for a datasource:

  • SELECT GRID_COL_ALIAS, DB_COL_NAME, LABEL_TEXT, DISPLAY_SEQ FROM APPS.JTF_GRID_COLS_VL WHERE GRID_DATASOURCE_NAME = :datasource AND VISIBLE_FLAG = 'Y' ORDER BY DISPLAY_SEQ;

Compare frozen visible columns:

  • SELECT GRID_COL_ALIAS, LABEL_TEXT FROM APPS.JTF_GRID_COLS_VL WHERE GRID_DATASOURCE_NAME = :datasource AND FREEZE_VISIBLE_FLAG = 'Y';

Enumerate all datasources and their visible column counts:

  • SELECT GRID_DATASOURCE_NAME, COUNT(*) FROM APPS.JTF_GRID_COLS_VL WHERE VISIBLE_FLAG = 'Y' GROUP BY GRID_DATASOURCE_NAME;

Because the view depends on USERENV('LANG'), results are language-sensitive; queries intended for cross-language comparison should account for this by setting the session language or querying the base tables directly.