Search Results ahl_item_groups_b_h




Overview
Explore in AI Chat

Overview

The AHL_ITEM_GROUPS_B_H table is a history table within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). Its primary role is to capture and preserve historical versions of records from the base table, AHL_ITEM_GROUPS_B, which defines logical groupings of items (parts) used in maintenance operations. This historical tracking is critical for audit trails, compliance, and analyzing changes to item group definitions over time within the asset-intensive industries served by the AHL module.

Key Information Stored

As a history table, AHL_ITEM_GROUPS_B_H stores snapshots of item group records whenever the original record in AHL_ITEM_GROUPS_B is modified. While the specific column list is not detailed in the provided metadata, the structure typically mirrors the base table's columns, augmented with standard history-tracking attributes. The documented primary key, ITEM_GROUP_H_ID, uniquely identifies each historical version. The foreign key column, ITEM_GROUP_ID, links each historical row back to its originating master record in AHL_ITEM_GROUPS_B. Other columns would include the item group's name, description, effective dates, and change tracking information such as creation date and last update date.

Common Use Cases and Queries

The primary use case is auditing and reporting on the evolution of item group configurations. This is essential for understanding when a specific part was added or removed from a group, which can impact maintenance procedures, bills of material, and service contracts. A common query pattern involves retrieving all historical states for a specific item group to construct a timeline of changes.

  • Retrieve Full History for an Item Group: SELECT * FROM AHL_ITEM_GROUPS_B_H WHERE ITEM_GROUP_ID = <group_id> ORDER BY CREATION_DATE;
  • Audit Report for Changes Within a Date Range: SELECT ITEM_GROUP_ID, CREATION_DATE, CREATED_BY FROM AHL_ITEM_GROUPS_B_H WHERE CREATION_DATE BETWEEN :start_date AND :end_date;

These queries support compliance audits, troubleshooting configuration issues, and analyzing the impact of historical changes on work orders and maintenance plans.

Related Objects

The table has a direct and singular relationship with its base table, as documented in the provided metadata.

  • AHL_ITEM_GROUPS_B: This is the primary transactional table for item groups. The foreign key relationship is defined as AHL_ITEM_GROUPS_B_H.ITEM_GROUP_ID referencing AHL_ITEM_GROUPS_B. All historical records in the `_H` table are derived from and link back to a current record in this base table.

While not listed in the excerpt, other related objects would likely include the AHL_ITEM_GROUP_MEMBERS_B table (for the items within a group) and its corresponding history table, as well as the AHL_ITEM_GROUPS_TL table for translated descriptive information.