Results for “cz_ui_itemselect_types_v”

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

Overview

In Oracle E-Business Suite releases 12.1.1 and 12.2.2, CZ_UI_ITEMSELECT_TYPES_V is a view owned by the APPS schema in the Oracle Configurator (CZ) product family. Its purpose is narrow and well defined: it exposes the subset of lookup values associated with the lookup type UI_ITEM_SEL_TABLE_TYPE. In other words, the view does not store configurator item-selection logic itself; rather, it surfaces the enumerated "table type" values that the Configurator user interface uses to classify or filter the ways items can be selected within a configuration session.

Because the view is a filtered projection over the generic lookup value view, it plays a reporting and integration role rather than a transactional one. Report developers, extension builders, and integration specialists query it to obtain the current, language-aware list of item selection type codes and their descriptive labels without needing to hard-code those values or reproduce the underlying lookup filter themselves. It is read-only and reflects the state of the lookup data at query time.

Underlying Base Objects

The view is defined exclusively over one documented base object:

• CZ_LOOKUP_VALUES_VL — the view that resolves Configurator lookup values, including translated and untranslated label content.

The dependency is one-directional: CZ_UI_ITEMSELECT_TYPES_V reads from CZ_LOOKUP_VALUES_VL and introduces no additional storage of its own. The defining query restricts the result set with a fixed predicate, LIST_NAME = 'UI_ITEM_SEL_TABLE_TYPE', so every row returned belongs to that single lookup type. Because the base object is a _VL (view, language) construct, the view inherits multi-language behavior, exposing LANGUAGE and SOURCE_LANG columns that govern which translation of each value label is returned for the querying session.

Key Columns

• LIST_NAME — the lookup type name; for this view it is always UI_ITEM_SEL_TABLE_TYPE.
• DATA_VALUE — the internal lookup code stored in the database, used programmatically by the Configurator UI.
• NUMERIC_ID_VALUE — a numeric identifier associated with the lookup value, useful where a numeric key is required.
• VALUE_SEQ — the display sequence controlling the order in which values appear.
• DATA_TYPE_ID — identifies the data type of the lookup value.
• NULL_VALUE_FLAG — indicates whether the value represents a null or blank selection.
• VALUE_LABEL — the translated, user-facing label displayed in the UI.
• VALUE_DESCRIPTION and VALUE_NOTES — supplementary descriptive text maintained against the lookup value.
• LANGUAGE and SOURCE_LANG — the language of the returned label and the source language of the record.

Common Use Cases and Queries

Typical scenarios include validating that the expected item selection table types exist after an upgrade or patch, building a value list for a custom LOV, and joining selection type codes to configuration data for reporting. A simple listing ordered for presentation is:

SELECT VALUE_SEQ, DATA_VALUE, VALUE_LABEL, VALUE_DESCRIPTION
FROM APPS.CZ_UI_ITEMSELECT_TYPES_V
ORDER BY VALUE_SEQ;

To retrieve codes only for integration or comparison purposes:

SELECT DATA_VALUE, NUMERIC_ID_VALUE, NULL_VALUE_FLAG
FROM APPS.CZ_UI_ITEMSELECT_TYPES_V;

To confirm available translations, include the language columns:

SELECT DATA_VALUE, VALUE_LABEL, LANGUAGE, SOURCE_LANG
FROM APPS.CZ_UI_ITEMSELECT_TYPES_V
ORDER BY DATA_VALUE, LANGUAGE;

Consultancy engagements that require understanding how configurator item selection is categorized typically begin by extracting this view alongside related CZ lookup views, since it provides the authoritative, patch-maintained enumeration of item selection table types for the target EBS instance.