Search Results ahl_schedule_materials

Overview

The AHL_SCHEDULE_MATERIALS table is a core transactional entity within the Oracle E-Business Suite Complex Maintenance, Repair, and Overhaul (CMRO) application. Its primary function is to record and manage the materials that have been scheduled for use by Material Requirements Planning (MRP) for maintenance and repair operations. This table serves as the definitive link between planned material requirements and the specific work tasks or operations where they will be consumed, enabling precise material planning, availability checks, and inventory control for service orders and maintenance visits.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical structure. The primary identifier is the SCHEDULED_MATERIAL_ID. The table's essential purpose is defined by its foreign key relationships: it stores the VISIT_TASK_ID to associate scheduled materials with a specific task on a maintenance visit, and the WORKORDER_OPERATION_ID to link materials to a particular operation on a work order. Other columns typically found in such a table would include item identifiers, scheduled quantities, required dates, sourcing type (e.g., inventory, purchase), and reference to the MRP schedule that generated the record.

Common Use Cases and Queries

This table is central to reporting and processes involving material fulfillment for maintenance work. Common use cases include generating pick lists for technicians, analyzing material requirements for upcoming maintenance visits, and reconciling planned versus actual material usage. A typical query would join this table to task or operation details and item master data to create a material schedule report. For example, to list all materials scheduled for a specific work order operation, one might use a SQL pattern such as: SELECT asm.scheduled_material_id, asm.workorder_operation_id, msib.segment1 item_code, ... FROM ahl_schedule_materials asm, mtl_system_items_b msib WHERE asm.inventory_item_id = msib.inventory_item_id AND asm.workorder_operation_id = :p_operation_id.

Related Objects

The table maintains defined relationships with several other key CMRO objects, as per the provided foreign key metadata:

• AHL_VISIT_TASKS_B: The VISIT_TASK_ID column in AHL_SCHEDULE_MATERIALS references this table, linking scheduled materials to a specific task within a maintenance visit.
• AHL_WORKORDER_OPERATIONS: The WORKORDER_OPERATION_ID column references this table, associating the scheduled material requirement with a discrete operation on a work order.
• AHL_WO_OPERATIONS_TXNS: This table holds a foreign key (SCHEDULE_MATERIAL_ID) that references AHL_SCHEDULE_MATERIALS. This relationship tracks the actual material transactions (issues, returns) against the scheduled material plan.

The primary key constraint AHL_SCHEDULED_MATERIALS_PK on SCHEDULED_MATERIAL_ID ensures the uniqueness of each material schedule record.