Results for “cz_menuitemtypes_lkv”

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

Overview

The CZ_MENUITEMTYPES_LKV view is a configuration and lookup utility object owned by the APPS schema within the Oracle E-Business Suite Configurator (CZ) product family. It is classified in the ETRM metadata as a VALID VIEW at the 12.1.1 and 12.2.2 release levels. The view presents the set of valid menu item types that the Configurator module recognizes when building or interpreting runtime user-interface menus for configured products. Rather than exposing the full breadth of the Configurator lookup repository, it restricts output to the lookup list named MENU_ITEM_TYPES, functioning as a filtered, read-only list of values (LOV) source.

In Oracle EBS reporting and integration contexts, the view acts as a stable, denormalized access point for menu item type reference data. Developers building concurrent programs, forms LOVs, or interface tables can query it without needing to understand the parent lookup structure, and the filter predicate guarantees that only menu-related lookup values are returned. This makes it well suited to reference-data extracts and validation logic that must confirm a menu item type belongs to the supported enumeration.

Underlying Base Objects

The documented view text defines CZ_MENUITEMTYPES_LKV as a projection over a single referenced base object: the view CZ_LOOKUP_VALUES_VL, also owned by APPS. The filter clause is explicit:

• WHERE LIST_NAME = 'MENU_ITEM_TYPES'

Because the base object is itself a view (_VL suffix), the component combines translated lookup values with the language-handling semantics of the underlying lookup value entity. The _VL designation typically indicates a translated view that exposes language-specific rows and source language information, which explains the presence of the LANGUAGE and SOURCE_LANG columns. The dependency is one-to-many in modeling terms: a single lookup list (MENU_ITEM_TYPES) contains multiple lookup values, and each row in CZ_MENUITEMTYPES_LKV corresponds to exactly one such value.

Key Columns

• LIST_NAME — The lookup list name; always MENU_ITEM_TYPES in this view, serving as the semantic anchor.
• DATA_VALUE — The internal coded value used to identify the menu item type in application logic.
• NUMERIC_ID_VALUE — A numeric identifier for the lookup value, useful when a surrogate key is required.
• VALUE_SEQ — Controls display ordering of the menu item types in LOVs and picklists.
• DATA_TYPE_ID — Identifies the data type classification associated with the lookup value.
• NULL_VALUE_FLAG — Indicates whether the value may be treated as null or is otherwise specially flagged.
• VALUE_LABEL — The user-facing label presented for the menu item type.
• VALUE_DESCRIPTION and VALUE_NOTES — Descriptive text and supporting notes for the value.
• LANGUAGE and SOURCE_LANG — Language of the returned row and the source language of the underlying translation.

Common Use Cases and Queries

Typical scenarios include populating LOVs, validating reference data in interfaces, and reconciling menu item type configuration across environments. A simple extraction ordered for display follows:

• SELECT DATA_VALUE, VALUE_LABEL, VALUE_SEQ FROM APPS.CZ_MENUITEMTYPES_LKV ORDER BY VALUE_SEQ;
• SELECT NUMERIC_ID_VALUE, DATA_VALUE, VALUE_DESCRIPTION FROM APPS.CZ_MENUITEMTYPES_LKV WHERE NULL_VALUE_FLAG = 'N';
• SELECT VALUE_LABEL, LANGUAGE, SOURCE_LANG FROM APPS.CZ_MENUITEMTYPES_LKV WHERE LANGUAGE = USERENV('LANG');

Because the view already applies the MENU_ITEM_TYPES restriction, queries need not repeat the filter, and the view may be granted to reporting schemas or exposed through custom concurrent programs without additional predicate handling.