Search Results fnd_common_lookups




Overview
Explore in AI Chat

Overview

FND_COMMON_LOOKUPS is a compatibility view owned by the APPS schema in Oracle E-Business Suite Application Object Library (FND). It exposes QuickCode data — the configurable lookup values that populate list of values (LOVs), validation lists, and reference fields throughout the EBS application stack — in a flat, denormalized form. Prior to the introduction of the FND_LOOKUP_TYPES and FND_LOOKUP_VALUES model in Release 11i, QuickCodes were maintained in a single combined table. FND_COMMON_LOOKUPS exists expressly to preserve backward compatibility with the historical FND_COMMON_LOOKUPS interface, allowing legacy SQL statements, reports, and third-party integrations written against the older QuickCode structure to continue functioning without modification.

The view is marked VALID in ETRM for both 12.1.1 and 12.2.2, confirming it remains available and supported in current EBS releases. Because it is a view rather than a table, it holds no data of its own; it is a real-time projection of the underlying lookup tables. The primary functional constraint is that the view is hard-coded to the Oracle Application Object Library application, identified by VIEW_APPLICATION_ID = 3, and rows are further filtered through the lookup security group function.

Underlying Base Objects

The documented base objects are FND_LOOKUP_TYPES and FND_LOOKUP_VALUES, both referenced as synonyms resolved under APPS, joined on the compound key of LOOKUP_TYPE, SECURITY_GROUP_ID, and VIEW_APPLICATION_ID. FND_LOOKUP_TYPES supplies the lookup type definition — its owning application, meaning, and language attributes — while FND_LOOKUP_VALUES contributes the individual codes, translations, enabled status, effective dates, and the fifteen descriptive flexfield attribute columns.

The view also depends on the FND_GLOBAL package, invoked as FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE, FLV.VIEW_APPLICATION_ID). This function restricts returned rows to the security group in effect for the current session, so the result set is user- and responsibility-sensitive rather than a raw dump of all lookup values.

Key Columns

Common Use Cases and Queries

The view is most often used in custom reports, interfaces, and legacy code where the older QuickCode syntax is expected. A typical query returns the active values of a specific lookup type with their meanings:

SELECT lookup_code, meaning, description
FROM fnd_common_lookups
WHERE lookup_type = 'YOUR_LOOKUP_TYPE'
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)
AND NVL(end_date_active, SYSDATE + 1);

Because the view already restricts rows by VIEW_APPLICATION_ID = 3 and applies lookup security, it is suitable for building validation lists tied to the current user's security context. Teams writing new code should generally target FND_LOOKUP_VALUES directly, which supports multiple view applications and languages; FND_COMMON_LOOKUPS should be reserved for compatibility with pre-existing SQL.