Results for “ahl_rt_oper_materials”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AHL_RT_OPER_MATERIALS is a transactional table in the AHL (Complex Maintenance Repair and Overhaul) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the material and tool requirements associated with a Route or an Operation. In ETRM terms, this object acts as the junction between maintenance work definitions and inventory items, capturing which items are consumed, replaced, or required during execution of a route operation, including quantity, unit of measure, revision, and duration parameters.

The table resides in the AHL schema and exposes 43 documented columns. Its primary key, AHL_RT_OPER_MATERIALS_PK, is enforced on RT_OPER_MATERIAL_ID, with a secondary unique index AHL_RT_OPER_MATERIALS_U1 on the same column. From a Data Vault modeling perspective, the FK topology places this object as satellite-leaning, meaning it is best treated as a descriptive, context-bearing record attached to a hub or link (the route/operation) rather than as an independent hub. The AHL_RT_OPER_MATERIALS_H history table reinforces this classification by providing an audited trail of changes to the same key.

Key Information Stored

• RT_OPER_MATERIAL_ID — surrogate primary key and sole business-key candidate (unique index U1).
• OBJECT_ID — the owning route or operation; dereferenced through AHL_ROUTES_B or AHL_OPERATIONS_B depending on context.
• INVENTORY_ITEM_ID and INVENTORY_ORG_ID — the material or tool, resolved against MTL_SYSTEM_ITEMS_B.
• ITEM_GROUP_ID and ITEM_COMP_DETAIL_ID — optional grouping and composition detail, linked to AHL_ITEM_GROUPS_B and AHL_ITEM_COMPOSITIONS.
• POSITION_PATH_ID / POSITION_KEY — where along the route the requirement applies, using AHL_MC_PATH_POSITIONS.
• REC_TYPE_CODE and ASSOCIATION_TYPE_CODE — classify the record (material vs. tool; requirement association semantics).
• QUANTITY, UOM_CODE, REVISION_NUMBER — consumption and revision facts for the item.
• DURATION and TIME_SPAN — scheduling attributes for planning of the requirement.
• REWORK_PERCENT, REPLACE_PERCENT, EXCLUDE_FLAG, IN_SERVICE — execution modifiers controlling how the requirement is honored.
• SECURITY_GROUP_ID and MC_ID — access control and multi-org/consolidation identifiers.
• OBJECT_VERSION_NUMBER and the standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) — concurrency and audit tracking.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — the standard EBS DFF extension block.

The unique index on RT_OPER_MATERIAL_ID confirms the surrogate key is also the natural identifier for reconciliation and downstream joins.

Common Use Cases and Queries

Typical uses include maintenance requirement reporting, BOM-like explosion of a route, scheduling feasibility checks, and inventory demand planning for MRO work orders.

• List all material requirements for a given route or operation: SELECT * FROM AHL.AHL_RT_OPER_MATERIALS WHERE OBJECT_ID = :p_object_id;
• Join to item master to obtain descriptions: SELECT m.rt_oper_material_id, m.quantity, m.uom_code, i.segment1, i.description FROM ahl.ahl_rt_oper_materials m, mtl_system_items_b i WHERE m.inventory_item_id = i.inventory_item_id AND m.inventory_org_id = i.organization_id AND m.object_id = :p_object_id;
• Distinguish tool versus material requirements using REC_TYPE_CODE or ASSOCIATION_TYPE_CODE.
• Audit changes over time by comparing with AHL_RT_OPER_MATERIALS_H on RT_OPER_MATERIAL_ID.
• Trace actual consumption by joining AHL_SCHEDULE_MATERIALS.RT_OPER_MATERIAL_ID back to this table.

Related Objects

• AHL_ROUTES_B — parent route record (OBJECT_ID).
• AHL_OPERATIONS_B — parent operation record (OBJECT_ID).
• MTL_SYSTEM_ITEMS_B — item/org master (INVENTORY_ITEM_ID, INVENTORY_ORG_ID).
• AHL_ITEM_GROUPS_B — item grouping (ITEM_GROUP_ID).
• AHL_ITEM_COMPOSITIONS — composition detail (ITEM_COMP_DETAIL_ID).
• AHL_MC_PATH_POSITIONS — route position (POSITION_PATH_ID).
• AHL_RT_OPER_MATERIALS_H — historical/audit shadow table (RT_OPER_MATERIAL_ID).
• AHL_SCHEDULE_MATERIALS — scheduled execution records referencing this requirement (RT_OPER_MATERIAL_ID).
• FND_SECURITY_GROUPS — security grouping (SECURITY_GROUP_ID).