Search Results action_display_updt

Overview

APPS.CZ_ACTIONDISPLAYUPDT_LKV is a narrow lookup view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. Its name carries the conventional suffix "LKV," signaling a lookup-values view that filters the generic lookup infrastructure to a single lookup type. Specifically, the view restricts its output to lookup records belonging to the list name ACTION_DISPLAY_UPDT, which governs the display and update behavior of actions within the Common Architecture / ETRM (Enterprise Transaction and Reference Management) framework.

The object is defined as a simple projection over the generic lookup view CZ_LOOKUP_VALUES_VL, applying a constant predicate on LIST_NAME. Because it is a view rather than a table, it holds no data of its own; every query is resolved at runtime against the underlying lookup view, which itself translates lookup codes into language-sensitive display text. In reporting and integration terms, this view acts as a convenience access point for developers and concurrent programs that need only the ACTION_DISPLAY_UPDT lookup set without coding the LIST_NAME predicate repeatedly.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: CZ_LOOKUP_VALUES_VL, which is itself a view. The dependency chain is therefore two levels deep: CZ_ACTIONDISPLAYUPDT_LKV → CZ_LOOKUP_VALUES_VL → lookup base tables. CZ_LOOKUP_VALUES_VL is the standard "_VL" view, meaning "value list," and it resolves language-dependent columns so that the LANGUAGE and SOURCE_LANG attributes returned reflect the session's NLS environment. The view does not join directly to any other table in its own definition, so all joins performed by consumers must be added explicitly.

Because the base object is a view rather than a table, no DML should be issued against CZ_ACTIONDISPLAYUPDT_LKV. Lookup maintenance is performed through the standard EBS Lookup Values form or through the underlying CZ_LOOKUP_VALUES tables, not through this projection.

Key Columns

The view exposes eleven columns, all inherited unchanged from CZ_LOOKUP_VALUES_VL:

• LIST_NAME — the lookup type; always returns the constant ACTION_DISPLAY_UPDT for this view.
• DATA_VALUE — the internal lookup code stored in transactional columns.
• NUMERIC_ID_VALUE — the numeric identifier associated with the lookup value, where applicable.
• VALUE_SEQ — the display sequence used to order values in lists and forms.
• DATA_TYPE_ID — identifies the datatype of the value, governing interpretation and validation.
• NULL_VALUE_FLAG — indicates whether the value permits a null internal code.
• VALUE_LABEL — the translated display text shown to users.
• VALUE_DESCRIPTION — the longer explanation of the lookup value.
• VALUE_NOTES — free-form notes captured against the value.
• LANGUAGE / SOURCE_LANG — the translation language and the source language of each row, resolved through the _VL layer.

Common Use Cases and Queries

Typical use cases include driving dynamic list-of-values sources, validating action codes on import or interface programs, and producing reference listings for the ACTION_DISPLAY_UPDT lookup set. A basic listing is:

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

To restrict to the current session language, or to join to transactional data on the internal code, queries can reference LANGUAGE and DATA_VALUE respectively. Because LIST_NAME is constant, it is only useful for confirmation or union operations. Enabling the lookup type and verifying translations is best done with a predicate on LANGUAGE when multi-language deployments are in scope.