Search Results fnd_lookup_types

Overview

The FND_LOOKUP_TYPES table is a core Application Object Library repository for defining lookup types, which serve as containers for static lists of values (LOVs) within Oracle E-Business Suite (EBS). Often referred to as "QuickCodes," these lookup types provide a centralized, flexible mechanism for managing standardized codes and their meanings across the application. Each lookup type defined in this table acts as a parent category, which is then populated with specific values in the related FND_LOOKUP_VALUES table. This structure is fundamental for data integrity, user interface consistency, and multi-language support throughout modules in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key uniquely identifies a lookup type through a combination of three columns: LOOKUP_TYPE, SECURITY_GROUP_ID, and VIEW_APPLICATION_ID. The LOOKUP_TYPE column stores the internal name of the lookup (e.g., 'YES_NO', 'FND_CURRENCY'). The VIEW_APPLICATION_ID links to FND_APPLICATION, identifying the application that "owns" or primarily uses this lookup type. The SECURITY_GROUP_ID, linked to FND_SECURITY_GROUPS, supports the multi-organization access control (MOAC) and data security model. Other critical columns typically include APPLICATION_ID (the application that created the lookup), CUSTOMIZATION_LEVEL to indicate user-modifiability, and descriptive columns for the lookup's purpose.

Common Use Cases and Queries

This table is central to configuration, reporting, and data validation. Common scenarios include identifying all lookup types defined for a specific module, auditing customizations, and troubleshooting missing LOVs. A fundamental query retrieves the definition of a specific lookup type and its associated values:

• SELECT flt.lookup_type, flt.description, flv.lookup_code, flv.meaning FROM fnd_lookup_types flt, fnd_lookup_values flv WHERE flt.lookup_type = flv.lookup_type AND flt.security_group_id = flv.security_group_id AND flt.view_application_id = flv.view_application_id AND flt.lookup_type = 'YES_NO' AND SYSDATE BETWEEN flv.start_date_active AND NVL(flv.end_date_active, SYSDATE);

Administrators also query this table to list all custom (user-defined) lookup types or to find lookups by descriptive text when the internal name is unknown.

Related Objects

As per the provided metadata, FND_LOOKUP_TYPES has direct, integral relationships with several key objects. Its primary child table is FND_LOOKUP_VALUES, which stores the actual code-meaning pairs for each type. The foreign key relationship is enforced on the composite key (LOOKUP_TYPE, SECURITY_GROUP_ID, VIEW_APPLICATION_ID). The table also has foreign key dependencies on FND_APPLICATION (via VIEW_APPLICATION_ID) and FND_SECURITY_GROUPS (via SECURITY_GROUP_ID). For programmatic access and maintenance, developers utilize the FND_LOOKUP_TYPES_PKG package and the FND_LOOKUP_TYPES_VL database view, which provides translated descriptive information.