Search Results fnd_lookup_values_vl




Overview
Explore in AI Chat

Overview

FND_LOOKUP_VALUES_VL is a multilingual (translated) view in the APPS schema belonging to the FND – Application Object Library product. It exposes the descriptive and translated columns of Oracle EBS lookup values, filtering rows by the session's runtime language so that applications and reports display meanings and descriptions in the user's active language. Because lookup codes drive a large proportion of EBS configuration — statuses, types, categories, and reference lists — this view is a central access point for both inquiry screens and integration interfaces.

The object is documented as VALID in ETRM for both Oracle EBS 12.1.1 and 12.2.2. Its designation as a "_VL" view follows the standard Oracle naming convention for views that combine a base (untranslated) table with the translated "_TL" table to return language-appropriate text.

Underlying Base Objects

Per the documented metadata, FND_LOOKUP_VALUES_VL is defined exclusively over the synonym FND_LOOKUP_VALUES. The view text references this base object as alias B and applies the filter WHERE B.LANGUAGE = USERENV('LANG'), restricting output to the row set matching the current session language. The synonym resolves to the underlying lookup values entity that stores both the codes and the translated MEANING and DESCRIPTION attributes, allowing the view to present a single language-relevant projection without additional joins visible to the caller.

Because the view is built on a synonym and hidden joins, consumers should treat it as a read-only reporting and query interface. The relationship to the base object is one-to-one per lookup row for the active language; no aggregation or denormalization is applied.

p>Note the view text in the ETRM excerpt contains a trailing comma before FROM, a transcription artifact; the functional semantics remain as described above.

Key Columns

Common Use Cases and Queries

Typical scenarios include populating LOVs and report parameters, validating incoming interface data, and joining lookup values to transactional tables to resolve display text.

List active values for a lookup type:

SELECT lookup_code, meaning, description, enabled_flag
FROM fnd_lookup_values_vl
WHERE lookup_type = 'INV_TRANSACTION_TYPE'
AND enabled_flag = 'Y';

Translate a stored code during reporting:

SELECT t.transaction_code, v.meaning
FROM my_transactions t, fnd_lookup_values_vl v
WHERE v.lookup_type = 'MY_TYPE'
AND v.lookup_code = t.transaction_code;

Restrict by effective dates to return only currently valid codes. Because the view filters on USERENV('LANG'), results automatically reflect the language environment of the executing session, making it suitable for concurrent programs and personalizations that must present localized meaning text without explicit language joins.