Results for “action_model_inter”

8 results




Overview
Explore in AI Chat

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

Overview

APPS.CZ_ACTIONMODELINTER_LKV is a lookup view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It is a filtered projection of the generic lookup values view CZ_LOOKUP_VALUES_VL, restricted to a single lookup type: ACTION_MODEL_INTER. In other words, the view exposes only those lookup value rows whose LIST_NAME equals 'ACTION_MODEL_INTER', presenting them in the standard Oracle lookup format (value, label, description, sequence, language, and related metadata).

The "ACTION_MODEL_INTER" lookup type is associated with the ETRM (Enterprise Taxation and Regulatory Management / E-Business Tax configuration) functional area, where lookup types drive enumerated values used in configuration and processing. This view therefore acts as a convenient, pre-filtered access point for the ACTION_MODEL_INTER values rather than requiring callers to query the full lookup values view and add their own WHERE clause. It is typically consumed by reports, concurrent programs, form LOVs, and integration extracts that need the current set of ACTION_MODEL_INTER codes without hard-coding list membership.

Underlying Base Objects

The documented base object for this view is a single layer: CZ_LOOKUP_VALUES_VL (VIEW). The definition selects from CZ_LOOKUP_VALUES_VL with the predicate list_name = 'ACTION_MODEL_INTER'.

Because CZ_LOOKUP_VALUES_VL is itself a view (the "_VL" suffix conventionally denotes a "value language" view, which resolves translated lookup labels against the session or base language and typically joins the lookup values table to a translation table), CZ_ACTIONMODELINTER_LKV ultimately derives from the standard EBS lookup infrastructure. Callers should therefore treat the data as read-only reference data sourced from the lookup definitions maintained in the application, and should not expect it to hold transactional or user-entered records.

Key Columns

  • LIST_NAME – The lookup type name. For every row in this view the value is constant: ACTION_MODEL_INTER.
  • DATA_VALUE – The stored lookup code (the internal value used by the application).
  • NUMERIC_ID_VALUE – A numeric identifier associated with the lookup value, where applicable.
  • VALUE_SEQ – The display/order sequence used to sort the values in LOVs and lists.
  • DATA_TYPE_ID – Identifier indicating the data type of the lookup value.
  • NULL_VALUE_FLAG – Flag indicating whether a null/blank value is permitted or represented.
  • VALUE_LABEL – The user-facing, translatable label for the lookup value.
  • VALUE_DESCRIPTION – A longer description of the lookup value.
  • VALUE_NOTES – Free-form notes attached to the value.
  • LANGUAGE – The language of the returned label/description translations.
  • SOURCE_LANG – The source (base) language from which the translation was derived.

Common Use Cases and Queries

Typical uses include validating an ACTION_MODEL_INTER code before insert, populating a dropdown or LOV with the currently enabled values in display order, and generating extracts that decode stored codes into their labels for downstream reporting or integration.

List all values in display order:

SELECT value_seq, data_value, value_label, value_description
FROM apps.cz_actionmodelinter_lkv
ORDER BY value_seq;

Resolve a single code to its label:

SELECT value_label, value_description
FROM apps.cz_actionmodelinter_lkv
WHERE data_value = :p_code;

Obtain labels in a specific language:

SELECT data_value, value_label
FROM apps.cz_actionmodelinter_lkv
WHERE language = USERENV('LANG');

Because the view is filtered and read-only, no DML should be performed against it; changes to the ACTION_MODEL_INTER lookup values must be made through the standard lookup maintenance facilities, after which this view reflects the updated definitions.