Search Results ecg_bom_comp_sel




Overview
Explore in AI Chat

Overview

APPS.ENG_CHANGE_ORDER_TYPES_VAL_V is a validation and reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes engineering change order types together with their associated bill of material (BOM) component selection semantics. It is defined in the APPS schema and is owned by the Oracle Engineering (ENG) product family. The view's primary function is to present a filtered, human-readable list of change order types whose assembly types map to active values in the MFG_LOOKUPS lookup type ECG_BOM_COMP_SEL. The suffix "_VAL_V" indicates that the object is intended for use as a validation view, typically referenced by descriptive flexfields, value sets, or LOV (List of Values) definitions within Oracle Forms and OAF-based pages.

Because the view joins change order type definitions against the MFG_LOOKUPS lookup view, it supplies both the coded value (ASSEMBLY_TYPE) and its translated meaning (BILL_TYPE). This makes it suitable for reporting layers that require display-ready descriptions rather than raw lookup codes. The view also enforces an effective-date filter using DISABLE_DATE, ensuring that only active change order types are returned to the calling application.

Underlying Base Objects

According to the documented ETRM 12.2.2 metadata, the view is defined over the following base objects:

  • ENG_CHANGE_ORDER_TYPES_V (VIEW) — Provides the change order type attributes, including type name, description, type identifier, assembly type, organization, change management type code, type classification, and disable date.
  • MFG_LOOKUPS (VIEW) — Supplies the lookup meaning for the assembly type through the ECG_BOM_COMP_SEL lookup type.
  • FND_PROFILE (PACKAGE) — Referenced indirectly, typically to resolve profile option values such as the current organization or a validation set context.

The join condition is ML.LOOKUP_CODE = ECT.ASSEMBLY_TYPE with ML.LOOKUP_TYPE = 'ECG_BOM_COMP_SEL'. The filter NVL(ECT.DISABLE_DATE, SYSDATE + 1) > SYSDATE excludes any change order type whose disable date has already passed, treating null disable dates as infinitely valid.

Key Columns

  • CHANGE_ORDER_TYPE — The display name of the engineering change order type (aliased from ECT.TYPE_NAME).
  • DESCRIPTION — Free-text description of the change order type.
  • CHANGE_ORDER_TYPE_ID — Primary key identifier for the change order type; used in foreign key relationships and API calls.
  • ASSEMBLY_TYPE — The coded assembly type value that links to the ECG_BOM_COMP_SEL lookup.
  • CHANGE_ORDER_ORGANIZATION_ID — The organization (inventory org) context in which the change order type is valid.
  • BILL_TYPE — The translated meaning of the assembly type lookup (aliased from ML.MEANING); provides the display label for the BOM component selection.
  • CHANGE_MGMT_TYPE_CODE — The change management classification code governing workflow and approval behavior.
  • TYPE_CLASSIFICATION — Classifies the change order type (for example, engineering versus manufacturing scope).

Common Use Cases and Queries

A typical reporting query retrieves all active change order types with their BOM component selection meaning for a given organization:

  • Populating a List of Values in a custom form or OAF page where a user selects a change order type.
  • Generating a reference report of change order types valid for engineering BOM changes.
  • Validating incoming interface data against the set of active change order types.

Example SQL:

  • SELECT CHANGE_ORDER_TYPE, BILL_TYPE, DESCRIPTION FROM APPS.ENG_CHANGE_ORDER_TYPES_VAL_V WHERE CHANGE_ORDER_ORGANIZATION_ID = :org_id ORDER BY CHANGE_ORDER_TYPE;
  • SELECT CHANGE_ORDER_TYPE_ID, CHANGE_ORDER_TYPE, BILL_TYPE FROM APPS.ENG_CHANGE_ORDER_TYPES_VAL_V WHERE ASSEMBLY_TYPE = :assembly_type;

Because the view already applies the ECG_BOM_COMP_SEL lookup join and the disable-date filter, consumers do not need to replicate that logic, reducing the risk of inconsistent validation across integrations and reports.