Search Results eng_change_order_types_val_v




Overview
Explore in AI Chat

Overview

ENG_CHANGE_ORDER_TYPES_VAL_V is a read-only validation view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Engineering (ENG) product, which manages engineering change orders (ECOs) and related change management structures. As its description states, the view exposes "Engineering change order types – enabled records only." It presents the set of active change order type definitions that can be referenced by change management functionality, filtering out any type whose DISABLE_DATE has passed.

Because it is a validation view, its primary role is to serve LOV (List of Values) and validation queries throughout the Engineering module, ensuring that only currently enabled change order types are available to users and to downstream processes. It is equally useful for reporting, integration, and data extraction, since it consolidates the enabled change order types together with their assembly type meaning and organizational context in a single queryable object. The view has a VALID status and is documented in the ETRM repository for both 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over two documented base objects. The first is ENG_CHANGE_ORDER_TYPES_V, itself a view in the Engineering schema that holds change order type definitions, including descriptive, organizational, and classification attributes. The second is MFG_LOOKUPS, the standard Oracle Manufacturing lookups view, which supplies the translated meaning for the assembly type code.

The join condition is ML.LOOKUP_CODE = ECT.ASSEMBLY_TYPE with ML.LOOKUP_TYPE = 'ECG_BOM_COMP_SEL', restricting the lookup to the assembly type lookup set used by Engineering change order configuration. The enabled-record filter is applied through NVL(ECT.DISABLE_DATE, SYSDATE + 1) > SYSDATE, which retains rows with no disable date and excludes rows whose disable date is on or before the current date. The referenced FND_PROFILE package is associated with profile option evaluations used by the underlying Engineering views, not with the outer selection logic.

Key Columns

  • CHANGE_ORDER_TYPE – The type name (aliased from ECT.TYPE_NAME), the user-facing identifier of the change order type.
  • DESCRIPTION – Free-text description of the change order type.
  • CHANGE_ORDER_TYPE_ID – The unique primary key identifier for the type, used in foreign key relationships and integration payloads.
  • ASSEMBLY_TYPE – Code indicating the assembly type associated with the change order type; joined to MFG_LOOKUPS.
  • CHANGE_ORDER_ORGANIZATION_ID – The inventory organization to which the change order type belongs.
  • BILL_TYPE – The translated meaning of ASSEMBLY_TYPE from MFG_LOOKUPS, providing a readable label for the assembly type.
  • CHANGE_MGMT_TYPE_CODE – Code classifying the change management type.
  • TYPE_CLASSIFICATION – Classification attribute further categorizing the change order type.

Common Use Cases and Queries

Typical uses include populating change order type lists of values, validating change order type identifiers during ECO creation or update, and feeding reporting and integration extracts that must respect enabled status.

List enabled change order types for an organization:

SELECT change_order_type, description, bill_type
FROM   apps.eng_change_order_types_val_v
WHERE  change_order_organization_id = :org_id;

Resolve the meaning of an assembly type:

SELECT change_order_type_id, change_order_type, assembly_type, bill_type
FROM   apps.eng_change_order_types_val_v
WHERE  assembly_type = :assembly_type;

Validate a specific type by ID:

SELECT 1
FROM   apps.eng_change_order_types_val_v
WHERE  change_order_type_id = :type_id;