Search Results cz_horizontalalignment_lkv

Overview

CZ_HORIZONTALALIGNMENT_LKV is a read-only lookup view owned by the APPS schema in Oracle E-Business Suite, registered under the CZ (Configurator) product module. Its purpose is to expose the set of valid horizontal alignment values used by Oracle Configurator when rendering and laying out configuration user interface elements. The view filters the generic lookup repository to a single lookup type, HORIZONTAL_ALIGNMENT, so that reports, concurrent programs, forms, and integration layers can retrieve alignment codes and their translated display labels without scanning the entire lookup table.

In the EBS 12.1.1 and 12.2.2 file systems, the object is delivered as a VALID database view with no PL/SQL logic beyond a restricted SELECT. Because the naming convention ends in _LKV (lookup values), it is a standard Oracle "lookup" view that participates in the same reporting and validation patterns as other CZ and FND lookup views. It contains no business logic other than the LIST_NAME = 'HORIZONTAL_ALIGNMENT' predicate and can therefore be treated as a stable, low-risk query target for read-only access.

Underlying Base Objects

The view is defined entirely over one documented base object: APPS.CZ_LOOKUP_VALUES_VL, itself a view rather than a physical table. CZ_LOOKUP_VALUES_VL is the Configurator-specific lookup values view, typically built over the FND lookup values tables and public synonyms used across EBS. Because CZ_LOOKUP_VALUES_VL carries the _VL suffix, it presents translated (language-specific) columns such as VALUE_LABEL and VALUE_DESCRIPTION in addition to the base code and numeric identifiers.

The view definition is:

• SELECT LIST_NAME, DATA_VALUE, NUMERIC_ID_VALUE, VALUE_SEQ, DATA_TYPE_ID, NULL_VALUE_FLAG, VALUE_LABEL, VALUE_DESCRIPTION, VALUE_NOTES, LANGUAGE, SOURCE_LANG FROM CZ_LOOKUP_VALUES_VL WHERE LIST_NAME = 'HORIZONTAL_ALIGNMENT'

Consequently the view inherits the translation behavior of its base object: rows are returned according to the current session language, with SOURCE_LANG identifying the language of the source (untranslated) value. No joins, aggregations, or DML are present, so the view is non-updatable in the standard sense and should be used strictly for query purposes.

Key Columns

• LIST_NAME — Always the constant 'HORIZONTAL_ALIGNMENT'; identifies the lookup type.
• DATA_VALUE — The stored alignment code (for example, a left/center/right indicator) used by Configurator logic.
• NUMERIC_ID_VALUE — Numeric identifier associated with the lookup value, where applicable.
• VALUE_SEQ — Sequence controlling display order in list-of-values and pickers.
• DATA_TYPE_ID — Identifier of the lookup's data type.
• NULL_VALUE_FLAG — Indicates whether a null/blank alignment is permitted.
• VALUE_LABEL — Translated display label shown to users.
• VALUE_DESCRIPTION — Translated description of the alignment value.
• VALUE_NOTES — Free-form notes maintained against the value.
• LANGUAGE — Language of the returned row.
• SOURCE_LANG — Language of the source value for translation tracking.

Common Use Cases and Queries

Typical uses include populating alignment pick lists in Configurator-related extensions, validating alignment codes during data migration or interface loads, and producing setup or reference-data reports. A standard retrieval ordered for display is:

• SELECT DATA_VALUE, VALUE_LABEL, VALUE_SEQ FROM APPS.CZ_HORIZONTALALIGNMENT_LKV ORDER BY VALUE_SEQ;
• SELECT DATA_VALUE, VALUE_LABEL FROM APPS.CZ_HORIZONTALALIGNMENT_LKV WHERE NULL_VALUE_FLAG = 'N';
• SELECT DATA_VALUE FROM APPS.CZ_HORIZONTALALIGNMENT_LKV WHERE VALUE_LABEL = :p_label;

Because the view is restricted to one lookup type and exposes translated labels, it is safe to embed in reports, BI Publisher data models, and inbound validation queries across both EBS 12.1.1 and 12.2.2. Access should be granted through the APPS schema or a dedicated reporting user rather than by querying base lookup tables directly.