Search Results modelnodes_copysource_settings

Overview

The view APPS.CZ_MDLNODE_CPSRC_LKV is a configuration-lookup view within the Oracle E-Business Suite (EBS) ETRM (Enterprise Territory and Resource Management) product family. Its purpose is to expose a curated, filtered subset of Oracle's seeded and user-defined lookup values — specifically those belonging to the lookup type MODELNODES_COPYSOURCE_SETTINGS. In the context of EBS 12.1.1 and 12.2.2, this view serves as the read interface for the "copy source settings" associated with model nodes, presenting localized display labels, descriptions, and notes for the enumeration values used to control how model node attributes are copied.

The view is owned by the APPS schema, the standard schema for Oracle EBS application objects, and is defined directly over the multilingual lookup view CZ_LOOKUP_VALUES_VL. Because the view name ends in the convention _LKV (lookup values), it is a deliberately thin wrapper — a filtered projection rather than a complex join. This design keeps the object lightweight and fast, making it suitable for consumption by both concurrent programs and online forms that render the available copy-source options. The user's search term, "modelnodes_copysource_settings", corresponds exactly to the LIST_NAME predicate hard-coded in the view text, confirming the object's tight coupling to that single lookup type.

Underlying Base Objects

The view is defined over a single documented base object: the view CZ_LOOKUP_VALUES_VL (itself a translation-enabled, "VL" — value-level — view in the ETRM lookup framework). The defining query selects all rendered columns from that base view while restricting rows with the predicate WHERE LIST_NAME = 'MODELNODES_COPYSOURCE_SETTINGS'. Consequently, CZ_MDLNODE_CPSRC_LKV inherits the multilingual behavior of CZ_LOOKUP_VALUES_VL: the base view joins the underlying lookup values table against its translations table so that the returned VALUE_LABEL, VALUE_DESCRIPTION, and VALUE_NOTES reflect the session's language. Because the view is defined with the APPS owner and typical ETRM grants, it is addressable as APPS.CZ_MDLNODE_CPSRC_LKV or, in a fully qualified form, APPS.CZ_MDLNODE_CPSRC_LKV@ for integration across environments.

Key Columns

• LIST_NAME — The lookup type identifier. For this view it is always MODELNODES_COPYSOURCE_SETTINGS, acting as the constant that scopes every row.
• DATA_VALUE — The stored, internal value of the lookup option, used programmatically to determine the copy-source behavior; this is the value typically stored in model node configuration columns.
• VALUE_SEQ — The display/ordering sequence for presenting the options in a list of values (LOV).
• DATA_TYPE_ID — Identifier of the data type associated with the lookup value, governing how DATA_VALUE is interpreted.
• NULL_VALUE_FLAG — Indicator of whether a null data value is permitted for the lookup entry.
• VALUE_LABEL — The translated, user-facing label shown in forms and reports.
• VALUE_DESCRIPTION — The translated descriptive text for the option.
• VALUE_NOTES — Supplementary notes, generally rendered only in administrator-facing maintenance screens.
• LANGUAGE and SOURCE_LANG — The language of the returned translation and the source (base) language, supporting the multilingual resolution performed by CZ_LOOKUP_VALUES_VL.

Common Use Cases and Queries

This view is most commonly queried to populate the copy-source selection list on model node setup forms, to validate values being written to model node configuration, and to reconcile seeded versus customized copy-source options during upgrades. A typical reporting or diagnostic query is:

• Enumerate available copy-source options in presentation order:
  SELECT VALUE_LABEL, DATA_VALUE, VALUE_SEQ
FROM APPS.CZ_MDLNODE_CPSRC_LKV
ORDER BY VALUE_SEQ;
• Retrieve descriptive text and notes for a specific option:
  SELECT VALUE_LABEL, VALUE_DESCRIPTION, VALUE_NOTES
FROM APPS.CZ_MDLNODE_CPSRC_LKV
WHERE DATA_VALUE = :p_value;
• Confirm which language translations are returned:
  SELECT LANGUAGE, SOURCE_LANG, VALUE_LABEL
FROM APPS.CZ_MDLNODE_CPSRC_LKV;

Because the view is read-only and filtered to a single lookup type, it is safe to expose to downstream integrations and BI reports without risk of altering ETRM configuration; modifications to the underlying options should be performed through the standard lookup maintenance interfaces that write to CZ_LOOKUP_VALUES.