Search Results eng_change_classifications_vl




Overview
Explore in AI Chat

Overview

ENG_CHANGE_CLASSIFICATIONS_VL is a seeded, read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Engineering (ENG) product module. Status in ETRM 12.1.1 and 12.2.2 is documented as VALID. The view presents a language-translated (VL) representation of engineering change classification definitions — the controlled vocabulary used to categorize Engineering Change Orders (ECOs) and related change objects in Oracle Engineering. It exposes a single, translated row per classification in the session language, combining the descriptive attributes held in the base table with the translatable name and description held in the translation table.

Because the view both joins the translation layer and resolves the language via USERENV('LANG'), it is the standard access point for reports, concurrent programs, personalizations, and integration interfaces that need classification data in the logged-in user's language. It also carries the standard EBS WHO columns and effective-dating columns, allowing consumers to trace record creation, modification, and date-range validity.

Underlying Base Objects

The view is defined directly over two documented base objects, referenced as synonyms in the APPS schema:

The join is performed on CLASSIFICATION_ID (B.CLASSIFICATION_ID = T.CLASSIFICATION_ID) with the additional predicate T.LANGUAGE = USERENV('LANG'), which restricts the result set to the current session language. In practice the view behaves as an outer join from the base table perspective when a translation is absent, though the documented predicate is expressed as an equi-join on both key and language.

Key Columns

  • CLASSIFICATION_ID — the surrogate primary key of the classification and the join key between the base and translation tables. This is the value referenced by change objects that carry a classification.
  • CLASSIFICATION_NAME — the translated name of the classification, sourced from ENG_CHANGE_CLASSIFICATIONS_TL. This is the value typically displayed to users.
  • DESCRIPTION — the translated long description of the classification, also sourced from the TL table.
  • START_DATE / END_DATE — effective-dating columns defining the active validity window of the classification record.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO audit columns identifying who created and last modified the row and when.
  • ROW_ID — the ROWID of the underlying base row, exposed for framework use.

Common Use Cases and Queries

The view is used to populate classification list of values, to render classifications on engineering change reports, and to drive integrations that export ECO metadata to external PLM or quality systems. A typical lookup by identifier is:

SELECT classification_id
     , classification_name
     , description
     , start_date
     , end_date
  FROM apps.eng_change_classifications_vl
 WHERE classification_id = :p_classification_id;

A listing of currently active classifications, suitable for a value set or report parameter, is:

SELECT classification_id
     , classification_name
  FROM apps.eng_change_classifications_vl
 WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date, SYSDATE)
                         AND NVL(end_date, SYSDATE)
 ORDER BY classification_name;

For extract interfaces, the NAME and DESCRIPTION columns are retrieved alongside the ID so that downstream systems receive the same language-specific text presented in the EBS application. Because the view resolves language dynamically, no additional language handling is required in the consumer query; the calling session's language setting governs the result.