Search Results eng_engineering_changes_v




Overview
Explore in AI Chat

Overview

The APPS.ENG_ENGINEERING_CHANGES_V view is a denormalized reporting layer over the Engineering Change Order (ECO) tables within the Oracle E-Business Suite Engineering (ENG) module. It presents engineering change notices as a single, query-friendly row per change order, joined to descriptive lookups for status, priority, reason, approval list, change order type, and owning organization. Because it consolidates codes and their meanings into one projection, it is the standard access path for ECO-based reporting, BI Publisher extracts, OBIEE/OTBI-style feeds, and inbound/outbound integrations that must reference engineering change orders by change notice, change ID, or status. The view is owned by APPS, has a VALID status, and appears identically in the 12.1.1 and 12.2.2 code lines.

Underlying Base Objects

The view is a multi-table join. The primary driving table is ENG_ENGINEERING_CHANGES (referenced as a synonym), aliased EEC, which holds the change notice master data. It is enriched by these documented base objects:

The join also references the packages FND_PROFILE, HR_GENERAL, and HR_SECURITY. HR_SECURITY is the critical dependency: the view applies organization-level security through it, so a user sees only the inventory organizations and HR organizations for which they are authorized. HR_GENERAL and FND_PROFILE resolve user/organization context during query execution.

Key Columns

Common Use Cases and Queries

Typical uses include operational ECO dashboards, aging/approval-cycle analysis, and integration extracts. A status summary query:

  • SELECT ECO_STATUS, COUNT(*) FROM APPS.ENG_ENGINEERING_CHANGES_V GROUP BY ECO_STATUS;
  • Find open approvals: SELECT CHANGE_NOTICE, ECO_STATUS, APPROVAL_STATUS, APPROVAL_REQUEST_DATE, DAYS_TO_APPROVE FROM APPS.ENG_ENGINEERING_CHANGES_V WHERE APPROVAL_STATUS IS NULL OR DAYS_TO_APPROVE IS NULL;
  • Recent changes for a project: SELECT CHANGE_NOTICE, PROJECT_NUMBER, TASK_NUMBER, IMPLEMENTATION_DATE FROM APPS.ENG_ENGINEERING_CHANGES_V WHERE PROJECT_ID = :p_id ORDER BY INITIATION_DATE DESC;
  • Incremental extract: SELECT * FROM APPS.ENG_ENGINEERING_CHANGES_V WHERE LAST_UPDATE_DATE >= :last_run;

Because organization security is enforced, callers should initialize the HR security profile (via FND_GLOBAL / MO_GLOBAL) before issuing large extracts, or expected authorization filtering will silently reduce result sets. When the search term is "change_order," this view is the recommended starting point for reporting on engineering change orders and their approval status.