Results for “fa_lookups_vl”

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

Overview

FA_LOOKUPS_VL is a view owned by the APPS schema within the Oracle E-Business Suite Assets (OFA) product family. It presents translated lookup code information used throughout the Oracle Assets module, exposing both the base lookup definition and the language-specific translation in a single, flattened result set. In Oracle EBS 12.1.1 and 12.2.2, the "_VL" suffix denotes a "view with language" — that is, a view that joins a base table to its translation table and restricts the translation language to the session's runtime language through the USERENV('LANG') function.

The view plays a supporting role in reporting and integration rather than serving as a transactional object. It allows concurrent programs, forms, OAF pages, and custom reports to retrieve the display meaning and description of Oracle Assets lookup values in the user's active language without manually joining the _B and _TL tables. Its status is documented as VALID, confirming that the underlying definitions resolve correctly against the referenced synonyms.

Underlying Base Objects

FA_LOOKUPS_VL is defined over two documented base objects, both accessed through synonyms: FA_LOOKUPS_B (the base table) and FA_LOOKUPS_TL (the translation table). The view text joins these on the composite key (LOOKUP_TYPE, LOOKUP_CODE) and filters the translation row by T.LANGUAGE = USERENV('LANG'), ensuring each lookup is returned only in the session language. Columns sourced from the base table include LOOKUP_TYPE, LOOKUP_CODE, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, the WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), and ATTRIBUTE1 through ATTRIBUTE15 plus ATTRIBUTE_CATEGORY_CODE. From the translation table the view draws MEANING and DESCRIPTION, which are the language-sensitive display values. The ROW_ID column is derived from the base table's ROWID.

Key Columns

• LOOKUP_TYPE / LOOKUP_CODE: The composite identifier for each lookup entry, matched across both base and translation tables.
• MEANING: The translated display value presented to users; sourced from FA_LOOKUPS_TL.
• DESCRIPTION: The translated longer description of the lookup entry.
• ENABLED_FLAG: Indicates whether the lookup is active (typically 'Y' or 'N').
• START_DATE_ACTIVE / END_DATE_ACTIVE: Define the effective dating window for the lookup value.
• ROW_ID: The base row identifier, useful for addressing the underlying _B record.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY_CODE: Descriptive flexfield segments attached to the lookup base record.
• Audit columns: WHO columns recording creation and last update context.

Common Use Cases and Queries

The view is most frequently queried to resolve lookup codes into their descriptive meanings for reports, validation lists, and integrations. A typical query retrieves all enabled values for a given lookup type:

• SELECT lookup_code, meaning FROM fa_lookups_vl WHERE lookup_type = :p_type AND enabled_flag = 'Y';
• SELECT lookup_type, lookup_code, meaning, description FROM fa_lookups_vl WHERE lookup_type IN ('ASSET_TYPE','DEPRN_METHOD') ORDER BY lookup_type, lookup_code;
• SELECT lookup_code, meaning FROM fa_lookups_vl WHERE lookup_type = 'CATEGORY' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Because the view already resolves the translation, it is preferred over direct joins when reporting in multilingual environments. Note that its WHERE clause depends on USERENV('LANG'), so results vary by session language.