Search Results cz_exnexprtype_lkv




Overview
Explore in AI Chat

Overview

CZ_EXNEXPRTYPE_LKV is a read-only database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is registered in the E-Business Suite Technical Reference Manual (ETRM) under the CZ (Configurator) product family with a status of VALID. The view functions as a lookup (LOV) source for expression types used by the Oracle Configurator engine, exposing the subset of generic lookup values that belong to the lookup type EXN_EXPR_TYPE. In that capacity it is not a transactional object; rather it is a reference data access layer that standardizes how expression type codes, their labels, and their descriptive attributes are presented to forms, concurrent programs, and integration interfaces.

Because it is a view rather than a table, CZ_EXNEXPRTYPE_LKV holds no data of its own. All rows are materialized at query time from the underlying lookup values view, filtered by list name. This design ensures that Configurator expression type lookups always reflect the current, language-aware contents of the lookup repository without requiring duplicate maintenance.

Underlying Base Objects

The view is defined over a single documented base object:

The defining query selects the standard lookup columns and applies the predicate WHERE LIST_NAME = 'EXN_EXPR_TYPE', so only rows belonging to the expression type lookup type are returned. The _VL suffix on the base object indicates that the view carries language-sensitive label columns resolved against the session language, with SOURCE_LANG indicating the language in which the row was originally authored.

Key Columns

  • LIST_NAME — the lookup type; always EXN_EXPR_TYPE for every row returned by this view.
  • DATA_VALUE — the internal lookup code that identifies the expression type (for example, a numeric or arithmetic expression indicator) as stored in Configurator metadata.
  • NUMERIC_ID_VALUE — the numeric surrogate identifier associated with the lookup value, useful for joins to numeric-ID-based Configurator tables.
  • VALUE_SEQ — display sequence controlling the ordering of entries in list-of-values windows.
  • DATA_TYPE_ID — identifies the data type classification of the lookup value.
  • NULL_VALUE_FLAG — indicates whether the lookup value represents a null or "not specified" condition.
  • VALUE_LABEL — the translated, user-facing label displayed in forms and reports.
  • VALUE_DESCRIPTION, VALUE_NOTES — longer descriptive text accompanying the value.
  • LANGUAGE and SOURCE_LANG — the session language of the returned translation and the language in which the row was originally defined.

Common Use Cases and Queries

Typical uses include validating expression type codes during Configurator model development, building custom reports that decode stored expression type values into readable labels, and populating custom LOVs or integration mappings.

Retrieve all active expression types in the current session language:

  • SELECT data_value, value_label, value_description, value_seq FROM cz_exnexprtype_lkv ORDER BY value_seq;

Resolve a stored expression type code to its label:

  • SELECT value_label FROM cz_exnexprtype_lkv WHERE data_value = :p_expr_type;

Identify untranslated rows for a specific language:

  • SELECT data_value, language, source_lang FROM cz_exnexprtype_lkv WHERE language <> source_lang;

Because the view is read-only, it should never be targeted by DML; expression type lookup values are maintained through the Oracle Configurator lookup setup and the standard application lookup maintenance forms.