Results for “cz_actionmodelinter_lkv”

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

Overview

CZ_ACTIONMODELINTER_LKV is a configuration-specific lookup view owned by the APPS schema within the Oracle E-Business Suite Configurator (CZ) product. It is defined as a restricted projection over the generic lookup infrastructure, filtered to a single lookup type identified by the list name ACTION_MODEL_INTER. The view presents the runtime "action model" interoperability or interface values used by the Configurator engine when resolving model-level actions, transitions, and their associated selection behavior. Because it conforms to the standard EBS lookup column layout — list name, data value, translated label, description, and language attributes — it can be consumed by concurrent programs, Oracle Reports, Oracle Forms LOVs, OAF pages, and third-party integrations that require a stable, denormalized source of Configurator action-model enumerations without joining directly to the broad CZ_LOOKUP_VALUES_VL lookup table.

Underlying Base Objects

The view is defined exclusively over the underlying base view CZ_LOOKUP_VALUES_VL, as documented in ETRM 12.2.2. The defining query restricts that base view on a fixed predicate, effectively hard-coding the lookup type:

• WHERE LIST_NAME = 'ACTION_MODEL_INTER'

This means the view is a thin, list-scoped wrapper. The _VL suffix on the base object indicates a translated (language) view, so the returned rows carry both the current session LANGUAGE and the original SOURCE_LANG, enabling multilingual presentation. No independent storage exists; all rows are derived from the lookup values maintained for the ACTION_MODEL_INTER lookup type. Administrators maintain the underlying lookup values through the standard Application Object Library lookup maintenance responsibility, and any change to those values is immediately reflected through this view in both 12.1.1 and 12.2.2 environments.

Key Columns

The view exposes the following columns, each inherited from the underlying lookup translation view:

• LIST_NAME — The lookup type; for every row returned this is the constant ACTION_MODEL_INTER.
• DATA_VALUE — The internal code value used by the Configurator logic to identify a specific action-model interface entry.
• NUMERIC_ID_VALUE — Numeric surrogate key where the action-model value is identified numerically rather than by text code.
• VALUE_SEQ — Display ordering sequence for presenting the lookup values in LOVs or reports.
• DATA_TYPE_ID — Identifier of the lookup's data type, governing validation and numeric versus character interpretation.
• NULL_VALUE_FLAG — Indicates whether a null value is permitted or represents a valid selection.
• VALUE_LABEL — The translated, user-facing label rendered in the runtime locale.
• VALUE_DESCRIPTION — Descriptive text explaining the purpose of the action-model interface value.
• VALUE_NOTES — Supplementary free-form notes attached to the lookup value by the administrator.
• LANGUAGE — The language code governing translation, typically USERENV('LANG').
• SOURCE_LANG — The base language from which the translation was derived.

Common Use Cases and Queries

Typical scenarios include validating action-model interface codes during import or interface programs, populating LOVs on Configurator action-model setup forms, and producing reference reports of valid action-model transition types. A representative query enumerating the active, ordered values is:

• SELECT VALUE_SEQ, DATA_VALUE, NUMERIC_ID_VALUE, VALUE_LABEL, VALUE_DESCRIPTION FROM APPS.CZ_ACTIONMODELINTER_LKV ORDER BY VALUE_SEQ;
• SELECT * FROM APPS.CZ_ACTIONMODELINTER_LKV WHERE DATA_VALUE = :p_action_model_inter;
• SELECT DISTINCT DATA_VALUE, VALUE_LABEL FROM APPS.CZ_ACTIONMODELINTER_LKV WHERE LANGUAGE = USERENV('LANG');

Integrations should treat the view as read-only reference data, sourcing authoritative changes through the standard lookup maintenance interface rather than direct DML.