Results for “eng_change_ocv”

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

Overview

ENG_CHANGE_OCV is a valid Oracle Application Object Library view owned by the APPS schema within the Engineering (ENG) product module. It presents a concise, language-aware list of Engineering Change Order (ECO) types defined in the E-Business Suite, exposing a small projection of code, meaning, and language values. The view is primarily intended to serve as a reference or lookup source for reporting and integration purposes, allowing developers and analysts to resolve an internal change order type identifier into a human-readable type name without querying the full translation-aware base view directly.

Because it is a view rather than a table, ENG_CHANGE_OCV stores no data of its own. It is a runtime construct that reads from the underlying Engineering change order type definitions and returns a derived result set. The view is documented in the ETRM for both 12.1.1 and 12.2.2 and retains the same structure across those releases.

Underlying Base Objects

The documented base objects referenced by this view are:

• ENG_CHANGE_ORDER_TYPES_VL (VIEW) — a translation (VL) view providing the change order type identifier, type name, and language context.
• FND_PROFILE (PACKAGE) — the profile option package used by the USERENV mechanism implicit in the view definition.

The view text selects CHANGE_ORDER_TYPE_ID, TYPE_NAME, and USERENV('LANG') from ENG_CHANGE_ORDER_TYPES_VL. The dependence on ENG_CHANGE_ORDER_TYPES_VL means the view inherits the multi-language behavior of the underlying translated entity, while the USERENV('LANG') expression ties the LANGUAGE column to the current session language.

Key Columns

• CODE — aliased from CHANGE_ORDER_TYPE_ID. This is the numeric or internal identifier of the change order type, used as the lookup key in downstream joins.
• MEANING — aliased from TYPE_NAME. This is the displayable name of the change order type, suitable for user-facing reports and lists of values.
• LANGUAGE — aliased from USERENV('LANG'). Returns the language code of the current session, supporting NLS-aware rendering and language filtering.

Common Use Cases and Queries

The view is well suited to populating list of values sources, validating change order type codes during integration loads, and producing descriptive ECO type reporting. A representative query retrieving all change order types with their display names is:

• SELECT code, meaning, language FROM apps.eng_change_ocv ORDER BY meaning;

A more targeted lookup resolving a specific type name to its code can be written as:

• SELECT code FROM apps.eng_change_ocv WHERE meaning = :p_type_name;

Because the LANGUAGE column reflects the session environment, applications requiring a specific language can filter accordingly:

• SELECT code, meaning FROM apps.eng_change_ocv WHERE language = USERENV('LANG');

In integration scenarios, the view is frequently joined to Engineering change order fact tables using CODE as the foreign key to retrieve the descriptive MEANING for extracted data. Given its minimal column footprint and dependency on a translated base view, it is recommended for reads only; it must not be treated as a storage location and should not be modified. Its validity status confirms it is compiled and available in the APPS schema for both 12.1.1 and 12.2.2 environments.