Search Results eng_revised_items

Overview

The ENG_REVISED_ITEMS table is a core data object within the Engineering (ENG) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central repository for tracking both pending and implemented item revisions that are managed through the Engineering Change Order (ECO) process. Its primary role is to maintain the relationship between an original item, its revised version, and the associated engineering change notice. This table is fundamental for managing the lifecycle of product changes, ensuring that revised items are properly linked to their bills of material and routings before and after implementation.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which reveal the critical data relationships it manages. The primary key, REVISED_ITEM_SEQUENCE_ID, uniquely identifies each revised item record. Key foreign key relationships indicate the essential columns and the data they store: the REVISED_ITEM_ID and ORGANIZATION_ID link to the new item definition in MTL_SYSTEM_ITEMS_B, while the CHANGE_NOTICE and ORGANIZATION_ID link to the controlling ECO in ENG_ENGINEERING_CHANGES. The BILL_SEQUENCE_ID connects to the item's bill of material structure in BOM_STRUCTURES_B. Additional columns, such as USE_UP_ITEM_ID, facilitate processes like using remaining stock of an old component.

Common Use Cases and Queries

This table is central to reporting and process flows within Engineering and Manufacturing. Common use cases include generating a list of all pending revisions for a specific ECO, identifying all implemented revisions for a given original item, and auditing the change history. A typical query would join ENG_REVISED_ITEMS with ENG_ENGINEERING_CHANGES and MTL_SYSTEM_ITEMS_B to report on revision status.

• Sample Query (Find Revised Items for a Change Notice):
  SELECT eri.revised_item_sequence_id,
      msi_new.segment1 revised_item,
      ec.change_notice,
      eri.implementation_date
  FROM eng_revised_items eri,
      eng_engineering_changes ec,
      mtl_system_items_b msi_new
  WHERE eri.change_notice = ec.change_notice
    AND eri.organization_id = ec.organization_id
    AND eri.revised_item_id = msi_new.inventory_item_id
    AND eri.organization_id = msi_new.organization_id
    AND ec.change_notice = 'ECO12345';

Related Objects

As indicated by its foreign key constraints, ENG_REVISED_ITEMS has extensive relationships with other EBS objects. It is a parent table to several key engineering and manufacturing tables, including ENG_REVISED_COMPONENTS and ENG_REVISED_OPERATIONS, which store the revised component and routing details. It is also referenced by BOM_COMPONENTS_B and BOM_INVENTORY_COMPONENTS to link standard bill components to their revised item definitions. Furthermore, it is linked to master tables such as MTL_SYSTEM_ITEMS_B for item details, ENG_ENGINEERING_CHANGES for the change order, BOM_STRUCTURES_B for the bill header, and HR_ALL_ORGANIZATION_UNITS for the organization context. This network of relationships underscores its pivotal role in the ECO ecosystem.