Search Results cz_ruletypecodes_lkv




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, CZ_RULETYPECODES_LKV is a reporting and integration view owned by the APPS schema within the Oracle Configurator (CZ) product family. The suffix _LKV follows the standard EBS convention denoting a "List of Values Key View" — a lightweight, filtered lookup view intended to drive list-of-values (LOV) controls, validation logic, and downstream reporting. This view exposes the set of valid rule type codes used by Oracle Configurator when defining and evaluating configuration rules.

Rather than querying the larger lookup infrastructure directly, consumers of this view receive a pre-filtered result set: only rows whose LIST_NAME equals 'RULE_TYPE_CODES' are returned. This design isolates the rule-type lookup domain, providing a stable, purpose-built interface for both Oracle Forms-based configurator screens and custom extensions. Because the view is defined over a VL ("view language") object, it is language-aware, returning translated label and description text according to the session's language environment.

Underlying Base Objects

The view is defined over a single documented base object: CZ_LOOKUP_VALUES_VL, itself a view (the _VL suffix indicates a language view that resolves translated columns). The view definition is a straightforward projection with a WHERE filter:

Operationally, CZ_LOOKUP_VALUES_VL draws from the Configurator lookup-values base tables (the CZ_LOOKUP_VALUES / CZ_LOOKUP_VALUES_TL pair in the standard EBS translated-table pattern), where the _B component holds language-independent attributes and the _TL component holds translated text. Thus CZ_RULETYPECODES_LKV transitively depends on the Configurator lookup schema, and its rows change whenever rule type codes are added, end-dated, or translated.

Key Columns

  • LIST_NAME — The lookup list identifier; always 'RULE_TYPE_CODES' in this view.
  • DATA_VALUE — The stored code value used programmatically to reference a rule type.
  • NUMERIC_ID_VALUE — Numeric surrogate identifier for the lookup value, useful for numeric joins and internal references.
  • VALUE_SEQ — Display ordering sequence for presenting values in an LOV or report.
  • DATA_TYPE_ID — Identifies the datatype category associated with the lookup value.
  • NULL_VALUE_FLAG — Indicates whether the value represents a null/empty selection.
  • VALUE_LABEL — The translated, user-facing label displayed in LOVs and forms.
  • VALUE_DESCRIPTION — Translated descriptive text explaining the rule type code.
  • VALUE_NOTES — Additional translated free-text notes.
  • LANGUAGE / SOURCE_LANG — The language of the returned translation and the source language of the base record, enabling multi-language handling.

Common Use Cases and Queries

This view is most commonly used to populate LOV controls, validate rule type values in custom configuration extensions, and drive reporting on Configurator rule definitions. A typical query retrieves all active rule type codes in display order:

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

Integrations that map external configuration metadata to Configurator rule types frequently join this view to custom staging tables on DATA_VALUE. Because it is a filtered projection over a VL object, the view is the recommended, supported access path for rule type codes in both 12.1.1 and 12.2.2, insulating custom code from the underlying lookup table structure.