Search Results value_notes




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, CZ_MDLNODE_CPSRC_LKV is a view owned by the APPS schema within the CZ (Configurator) product family. It is a specialized lookup view that presents a filtered subset of the generic Configurator lookup values. Specifically, the view restricts its results to a single lookup list identified by the literal MODELNODES_COPYSOURCE_SETTINGS, which governs the copy-source configuration behavior applied to model nodes in Oracle Configurator.

The technical role of this view is to supply the set of selectable copy-source settings that the Configurator runtime and administrator-facing pages require when populating dropdown lists, validation lists, or LOVs. The search term value_notes corresponds directly to the VALUE_NOTES column this view exposes, which carries supplemental descriptive text for each lookup value. Because the view is a filtered lookup view rather than a base table, it is commonly referenced in reporting extracts, Form personalization lookups, and integration scripts that need the authoritative list of configured copy-source options without sifting through the entire CZ_LOOKUP_VALUES_VL content.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: CZ_LOOKUP_VALUES_VL (itself a VIEW). The view definition is a straight projection over that source, with one predicate:

SELECT "LIST_NAME","DATA_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 = 'MODELNODES_COPYSOURCE_SETTINGS'

CZ_LOOKUP_VALUES_VL is the Configurator lookup-values view that joins the underlying lookup value and lookup type tables while exposing the language-specific (_VL) and translation (_TL) data. Because CZ_MDLNODE_CPSRC_LKV sits on a _VL object, it is inherently multilingual: rows are returned per installed language, and LANGUAGE / SOURCE_LANG distinguish the session language from the seed language. No additional tables are joined by this view itself; all multilingual resolution is delegated to the base lookup view.

Key Columns

  • LIST_NAME — always MODELNODES_COPYSOURCE_SETTINGS, the discriminator that scopes the view.
  • DATA_VALUE — the internal lookup code stored and referenced by Configurator logic.
  • VALUE_SEQ — sort sequence controlling display order of the settings.
  • DATA_TYPE_ID — the data type classification of the lookup value.
  • NULL_VALUE_FLAG — indicates whether the value permits a null/empty setting.
  • VALUE_LABEL — the translatable display label shown in the user interface.
  • VALUE_DESCRIPTION — the translatable long description of the setting.
  • VALUE_NOTES — free-text notes providing supplementary guidance or context for the setting; this is the column most associated with the user's value_notes search.
  • LANGUAGE / SOURCE_LANG — the current language and the source (seed) language of the returned translation.

Common Use Cases and Queries

Typical scenarios include validating available copy-source options, extracting lookup metadata for data migration, and joining lookup values to model-node configuration records. Because the view is language-aware, queries should filter on LANGUAGE when a single-language result is required.

-- Retrieve all copy-source settings with notes
SELECT VALUE_SEQ, DATA_VALUE, VALUE_LABEL, VALUE_NOTES
  FROM APPS.CZ_MDLNODE_CPSRC_LKV
 WHERE LANGUAGE = USERENV('LANG')
 ORDER BY VALUE_SEQ;
-- Find settings carrying descriptive notes only
SELECT DATA_VALUE, VALUE_NOTES
  FROM APPS.CZ_MDLNODE_CPSRC_LKV
 WHERE VALUE_NOTES IS NOT NULL
   AND LANGUAGE = 'US';

For integration, the view serves as a stable interface point: downstream processes query it rather than the broader lookup view, guaranteeing that only MODELNODES_COPYSOURCE_SETTINGS values are returned. Reporting extracts commonly select DATA_VALUE as the join key to operational Configurator data while using VALUE_LABEL and VALUE_NOTES for human-readable presentation.