Search Results part_change_id

Overview

The AHL_PART_CHANGES table is a core transactional data store within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). It serves as the system of record for all part change transactions performed on configured assets, such as aircraft or complex equipment. This table is fundamental to tracking the maintenance history of a serialized unit, documenting precisely when a component was removed and what part was installed as a replacement. Its existence is critical for compliance, audit trails, and understanding the complete configuration lineage of an asset over its operational lifecycle.

Key Information Stored

The table's primary key, PART_CHANGE_ID, uniquely identifies each part change transaction. Its foreign key relationships define the core transactional context. The UNIT_CONFIG_HEADER_ID links the change to the specific asset configuration (e.g., a specific aircraft tail number). The REMOVED_INSTANCE_ID and INSTALLED_INSTANCE_ID columns reference the CSI_ITEM_INSTANCES table to record the exact serialized item instances that were taken out and put in. The WORKORDER_OPERATION_ID and WORKORDER_MTL_TXN_ID tie the part change to the specific work order operation and material transaction that executed it, providing a complete link from maintenance instruction to physical inventory movement. For non-routine work, the NON_ROUTINE_WORKORDER_ID is populated. The MC_RELATIONSHIP_ID links to the AHL_RELATIONSHIPS_B table, connecting the transaction to the master configuration (model) relationship that authorized the part change.

Common Use Cases and Queries

A primary use case is generating a detailed maintenance history report for a specific unit configuration. Auditors and technicians query this table to verify part replacement compliance. Another critical use is tracing the installation history of a specific serialized part across different assets. Common SQL patterns involve joining to CSI_ITEM_INSTANCES for part details, AHL_UNIT_CONFIG_HEADERS for unit identity, and AHL_WORKORDERS for work order information.

• Sample Query (Part History for a Unit): SELECT apc.part_change_id, csi_removed.serial_number AS removed_serial, csi_installed.serial_number AS installed_serial, apc.transaction_date FROM ahl_part_changes apc, csi_item_instances csi_removed, csi_item_instances csi_installed, ahl_unit_config_headers auch WHERE apc.unit_config_header_id = auch.unit_config_header_id AND auch.name = 'Aircraft-123' AND apc.removed_instance_id = csi_removed.instance_id(+) AND apc.installed_instance_id = csi_installed.instance_id(+) ORDER BY apc.transaction_date DESC;

Related Objects

The AHL_PART_CHANGES table is centrally connected to several key AHL and EBS foundation tables via documented foreign keys. These relationships are essential for any integrated reporting or data validation.

• AHL_UNIT_CONFIG_HEADERS: Joined via UNIT_CONFIG_HEADER_ID. Links the part change to the physical asset.
• CSI_ITEM_INSTANCES (twice): Joined via REMOVED_INSTANCE_ID and INSTALLED_INSTANCE_ID. Provides serial and item details for the parts involved.
• AHL_RELATIONSHIPS_B: Joined via MC_RELATIONSHIP_ID. Connects to the master configuration (model bill) that defines the permissible part relationship.
• AHL_WORKORDER_OPERATIONS: Joined via WORKORDER_OPERATION_ID. Associates the change with the specific work order task.
• AHL_WORKORDERS: Joined via NON_ROUTINE_WORKORDER_ID. Links to the non-routine work order that initiated the change.
• AHL_WORKORDER_MTL_TXNS: Joined via WORKORDER_MTL_TXN_ID. Provides the direct link to the material transaction that effected the inventory change.