Search Results tab_text




Overview
Explore in AI Chat

Overview

The ENG_CHANGE_MGMT_TYPES_VL view in the APPS schema is a reporting and integration interface over engineering change management types in Oracle E-Business Suite. Owned by the Engineering (ENG) product, it exposes change management categories used by Oracle Engineering and Oracle Manufacturing for classifying engineering change orders (ECOs). The view filters its source so that only rows where TYPE_CLASSIFICATION equals 'CATEGORY' are returned, presenting the set of change management types that behave as categories rather than as other classification classes.

Although the object carries the "_VL" suffix conventionally associated with translated (multi-language) views, the documented view text does not join any translation table (such as _TL). It is a single-source view deriving all of its columns from ENG_CHANGE_ORDER_TYPES_V. Its value lies in exposing change management category types together with a computed status indicator, DISABLE_FLAG, allowing forms, concurrent programs, reports, and external integrations to determine whether a given change management type is currently active or disabled without re-implementing the disable-date logic.

Underlying Base Objects

The view is defined over a single documented base object: ENG_CHANGE_ORDER_TYPES_V, aliased as ECMT in the view text. This base view supplies the engineering change order type definitions, including the change management type code, sequencing, audit columns, disable date, change order type, descriptive attributes, base change management type code, and XML data source code.

The ETRM metadata additionally records FND_PROFILE (PACKAGE) among the referenced objects. FND_PROFILE is the standard Oracle Applications profile option API used throughout EBS to resolve environment- and user-dependent settings; its presence indicates that the effective content or behavior of the view's data lineage can depend on profile-option context resolved through that package. No base table is accessed directly by ENG_CHANGE_MGMT_TYPES_VL itself; all column values are inherited from the underlying ECO type view.

Key Columns

  • CHANGE_MGMT_TYPE_CODE — Primary identifying code for the change management type.
  • SEQUENCE_NUMBER — Ordering value used to present types in a defined sequence.
  • DISABLE_FLAG — Computed column. Per the view text, DECODE returns 'N' when DISABLE_DATE is null; otherwise SIGN(DISABLE_DATE - SYSDATE) is evaluated, yielding 'N' when the disable date is in the future and 'Y' when it has passed. This is the column most directly relevant to the "disable_flag" search: 'Y' indicates the type is disabled as of the current system date, 'N' indicates it is active.
  • NAME, DESCRIPTION, TAB_TEXT — User-facing labels and descriptive text for the type.
  • CHANGE_ORDER_TYPE — Associated change order type for the category.
  • BASE_CHANGE_MGMT_TYPE_CODE — Reference to a base change management type, supporting derived or seeded type hierarchies.
  • XML_DATA_SOURCE_CODE — Identifier for the XML data source associated with the type.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Note that DISABLE_FLAG is date-sensitive: because the expression compares DISABLE_DATE to SYSDATE, its value is evaluated at query execution time and changes automatically once a disable date passes.

Common Use Cases and Queries

Typical uses include listing active engineering change management categories for a value list or LOV, validating that a chosen category is not disabled prior to creating an ECO, and feeding category metadata into integration or migration programs.

To list all change management categories with their current status:

  • SELECT change_mgmt_type_code, name, disable_flag, sequence_number FROM eng_change_mgmt_types_vl ORDER BY sequence_number;

To retrieve only currently active categories:

  • SELECT change_mgmt_type_code, name FROM eng_change_mgmt_types_vl WHERE disable_flag = 'N' ORDER BY sequence_number;

To detect categories whose disable date has passed (disabled types):

  • SELECT change_mgmt_type_code, name FROM eng_change_mgmt_types_vl WHERE disable_flag = 'Y';

Because disable status is computed against SYSDATE, queries should be run against the view rather than cached results whenever currency of the flag matters.