Search Results wf_lookup_types_tl_pk




Overview
Explore in AI Chat

Overview

The WF_LOOKUP_TYPES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Application Object Library (FND) module. It is owned by the APPLSYS schema and is integral to the Workflow (WF) technology stack. As indicated by its name and description, this table stores translated, language-specific versions of the display names for Workflow lookup types. Lookup types are essentially categories of static lists of values used throughout the Workflow engine, such as activity statuses or notification priorities. The "_TL" suffix denotes it as a translatable table, enabling the EBS application to present these lookup type names in the language of the user's session, supporting global deployments.

Key Information Stored

The table's primary purpose is to map a lookup type code to its human-readable name in a specific language. Its structure is defined by two primary keys, which enforce data integrity. The primary key WF_LOOKUP_TYPES_TL_PK is based on the combination of LOOKUP_TYPE and LANGUAGE. This ensures that for any given lookup type, there can only be one translation record per language. A second unique key (WF_LOOKUP_TYPES_TL_UK2) on DISPLAY_NAME and LANGUAGE helps maintain uniqueness of display names within a language. Key columns include LOOKUP_TYPE (the code identifying the lookup category), LANGUAGE (the language code, such as 'US' for American English), and DISPLAY_NAME (the translated name for the lookup type). The table also contains standard translation table columns like SOURCE_LANG.

Common Use Cases and Queries

This table is primarily accessed by the EBS application runtime to resolve and display localized lookup type descriptions. Common technical and reporting use cases involve querying the metadata of Workflow lookups. For instance, to retrieve all translated names for a specific lookup type across all installed languages, one would query: SELECT language, display_name FROM apps.wf_lookup_types_tl WHERE lookup_type = '<TYPE_CODE>';. To join with the base table for a complete English (US) list of lookup types, a typical query is: SELECT b.lookup_type, t.display_name FROM apps.wf_lookup_types b, apps.wf_lookup_types_tl t WHERE b.lookup_type = t.lookup_type AND t.language = 'US';. Administrators may also query this table to audit or verify translation completeness during implementation or upgrade projects.

Related Objects

As per the provided foreign key metadata, WF_LOOKUP_TYPES_TL has defined relationships with several key Workflow tables. It is a child table of WF_ITEM_TYPES via the foreign key on the ITEM_TYPE column, linking lookup types to the specific workflow process they belong to. More critically, it serves as a parent table to WF_LOOKUPS_TL. The foreign key from WF_LOOKUPS_TL references WF_LOOKUP_TYPES_TL on the columns LOOKUP_TYPE and LANGUAGE. This enforces that the translated values (in WF_LOOKUPS_TL) for a given lookup type must correspond to a valid translated definition for that same lookup type and language in WF_LOOKUP_TYPES_TL, ensuring referential integrity across the translation layers of the Workflow lookup architecture.