Search Results mtl_item_revisions




Overview
Explore in AI Chat

Overview

The APPS.ENG_REVISED_COMPONENTS_ERV view is an Engineering (ENG) module reporting object that consolidates pending, implemented, and cancelled revised components associated with engineering change management. In Oracle EBS 12.1.1 and 12.2.2, this view exposes the revised bill of material component data produced by Engineering Change Orders (ECOs) and Engineering Change Notices (ECNs), joining the revised component rows to their source bills, revised item headers, item master definitions, and lookup meanings. The "ERV" suffix denotes Engineering Revised View, and the view is registered as VALID in the APPS schema.

Because users frequently search for mtl_item_revisions in this context, it is important to note that the view references MTL_ITEM_REVISIONS as a documented base object, but its primary function is to surface revised component lines rather than revision definitions alone. The view supports reporting and integration scenarios where implementers must determine which components of a bill are pending, implemented, or cancelled, and their associated effectivity and implementation dates.

Underlying Base Objects

The documented base objects for ENG_REVISED_COMPONENTS_ERV include:

  • ENG_REVISED_COMPONENTS (SYNONYM) — the principal fact source supplying component sequence, quantity, effectivity, cancellation, and change notice columns.
  • ENG_REVISED_ITEMS (SYNONYM) — the revised item header providing item-level ECO context.
  • BOM_BILL_OF_MATERIALS (VIEW) and BOM_INVENTORY_COMPONENTS (VIEW) — bill and component definitions referenced for structural linkage.
  • MTL_ITEM_REVISIONS (SYNONYM) — item revision definitions, relevant to the revision context of the revised item.
  • MTL_SYSTEM_ITEMS_VL (VIEW) — item master details such as item number, description, UOM, locator control, and flagship flags.
  • MTL_ITEM_LOCATIONS_KFV (VIEW) — concatenated locator flexfield values for supply locators.
  • FND_COMMON_LOOKUPS (VIEW) and MFG_LOOKUPS (VIEW) — lookup meanings for supply type, item type, and related codes.
  • FND_GLOBAL (PACKAGE) — session context used for security and audit defaults.

Key Columns

Common Use Cases and Queries

Typical usage includes ECO impact reporting, pending-change validation, and integration extracts that must distinguish implemented from cancelled components.

  • List all pending revised components for a bill and effectivity range.
  • Report cancelled components with comments and cancellation dates.
  • Join to MTL_ITEM_REVISIONS for revision-level detail.

Example:

SELECT component_sequence_id, component_item_no,
       component_quantity, effectivity_date,
       implementation_date, cancellation_date, supply_type
  FROM apps.eng_revised_components_erv
 WHERE bill_sequence_id = :bill_seq
   AND NVL(cancellation_date, SYSDATE + 1) > SYSDATE
 ORDER BY component_sequence_id;

This view is best suited to read-only reporting and is not intended for transactional updates.