Search Results eng_change_order_types_vl




Overview
Explore in AI Chat

Overview

ENG_CHANGE_ORDER_TYPES_VL is a translation-enabled (VL) view owned by the APPS schema in Oracle E-Business Suite Engineering (ENG). It presents the complete set of engineering change order types defined in the system, joining the base change order type table with its translation table and a manufacturing lookup for the assembly type description. The view is a foundational reference object for the Engineering Change Management (ECM) functionality within Oracle EBS 12.1.1 and 12.2.2, and is used by forms, concurrent programs, and reporting layers that need to enumerate, validate, or drive behavior based on change order types.

Because the view is multilingual, it resolves the correct language-specific descriptive columns (TYPE_NAME, DESCRIPTION, TAB_TEXT) using the session language—ECOTL.LANGUAGE = USERENV('LANG')—returning records for all defined change order types subject to classification and responsibility-based filtering. It is registered as a VALID object in the ETRM dictionary under the ENG product.

Underlying Base Objects

The view text joins three primary sources and references several supporting objects:

The translation table drives the VL semantics, while the profile and application-exists logic ensure that category-classified types are only surfaced to authorized responsibilities.

Key Columns

Common Use Cases and Queries

Typical scenarios include populating change order type LOVs, filtering valid types for a given organization, and reporting on active versus disabled types. A basic listing query:

SELECT CHANGE_ORDER_TYPE_ID,
       CHANGE_ORDER_TYPE,
       ASSEMBLY_TYPE_DESCRIPTION,
       CHANGE_MGMT_TYPE_CODE,
       START_DATE,
       DISABLE_DATE
FROM   APPS.ENG_CHANGE_ORDER_TYPES_VL
WHERE  SYSDATE BETWEEN START_DATE
       AND NVL(DISABLE_DATE, SYSDATE + 1)
ORDER BY CHANGE_ORDER_TYPE;

To restrict to a specific organization and exclude seeded types:

SELECT CHANGE_ORDER_TYPE_ID, CHANGE_ORDER_TYPE
FROM   APPS.ENG_CHANGE_ORDER_TYPES_VL
WHERE  CHANGE_ORDER_ORGANIZATION_ID = :org_id
AND    NVL(SEEDED_FLAG,'N') = 'N';

Because the profile-driven filter is embedded in the view definition, queries executed from within a responsibility automatically respect category visibility rules without additional WHERE clauses. This makes the view suitable both for ad hoc reporting and for integration interfaces that must enumerate only authorized change order types.