Results for “workorder_operation_id”

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

Overview

The view AHL_JOB_OPER_MATERIALS_V is an APPS-owned, VALID database object belonging to the AHL - Complex Maintenance Repair and Overhaul (CMRO) product family. It exposes the materials required at the operation level of an AHL work order, joining the work order header, its operations, the scheduled materials list, WIP requirement operations, the item master, and the associated visit. Its principal role is to present a denormalized, reporting-ready projection of job operation material demand without requiring consumers to reconstruct the multi-table join chain themselves.

This view is significant in EBS 12.1.1 and 12.2.2 for reporting and integration, because AHL work orders are built on top of the WIP execution model, yet their material records are stored in AHL-specific tables (AHL_SCHEDULE_MATERIALS). By surfacing both AHL context (visit number, work order operation, scheduled material) and WIP context (date required, operation sequence), the view bridges the two schemas for material planning and consumption analysis.

Underlying Base Objects

The documented base objects referenced by the view are:

• AHL_WORKORDERS (synonym) — provides WORKORDER_ID and links the visit task to the WIP entity.
• AHL_WORKORDER_OPERATIONS_V (view) — supplies OPERATION_CODE and WORKORDER_OPERATION_ID.
• AHL_SCHEDULE_MATERIALS (synonym) — the driving material table, filtered to STATUS = 'ACTIVE'.
• AHL_VISITS_VL (view) — supplies VISIT_ID and VISIT_NUMBER.
• WIP_REQUIREMENT_OPERATIONS (synonym) — supplies DATE_REQUIRED and OPERATION_SEQ_NUM.
• MTL_SYSTEM_ITEMS_VL (view) — supplies item description, UOM, concatenated segments, and MRP planning code.
• AHL_PP_MATERIALS_PVT (package) — its function GET_ISSUED_QTY is invoked in the SELECT list.
• MTL_RESERVATIONS (synonym) — listed as a referenced base object for reservation context.

The joins are keyed primarily on VISIT_TASK_ID, VISIT_ID, WIP_ENTITY_ID, OPERATION_SEQUENCE/OPERATION_SEQ_NUM, INVENTORY_ITEM_ID, and ORGANIZATION_ID.

Key Columns

• SCHEDULED_MATERIAL_ID — primary identifier of the scheduled material record; also aliased as SALES_ORDER_LINE_ID.
• SALES_ORDER_LINE_ID — documented as ASML.SCHEDULED_MATERIAL_ID; the name reflects a legacy/converted alias rather than a true sales order line reference. Users searching on this term should note the alias mapping.
• VISIT_TASK_ID, VISIT_ID, VISIT_NUMBER — visit context for the CMRO job.
• WORKORDER_ID, WORKORDER_OPERATION_ID, OPERATION_SEQUENCE, OPERATION_CODE — work order and routing operation identifiers.
• INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS, DESCRIPTION, UOM, MRP_PLANNING_CODE — item master attributes.
• REQUESTED_QUANTITY, SCHEDULE_QUANTITY, ISSUED_QUANTITY — demand, scheduled, and actually issued quantities.
• REQUESTED_DATE (from WIPR.DATE_REQUIRED) and SCHEDULE_DATE — requirement timing.
• ITEM_GROUP_ID, RT_OPER_MATERIAL_ID, OBJECT_VERSION_NUMBER — grouping and concurrency control.

Common Use Cases and Queries

Typical scenarios include reconciling scheduled versus issued materials per operation, feeding material shortage reports, and integrating work order material demand into external planning systems.

• Operations with open material demand: SELECT WORKORDER_ID, OPERATION_SEQUENCE, CONCATENATED_SEGMENTS, REQUESTED_QUANTITY, ISSUED_QTY FROM AHL_JOB_OPER_MATERIALS_V WHERE REQUESTED_QUANTITY > NVL(ISSUED_QTY,0);
• Visit-level material summary: SELECT VISIT_NUMBER, WORKORDER_ID, ORGANIZATION_ID, SUM(REQUESTED_QUANTITY) FROM AHL_JOB_OPER_MATERIALS_V GROUP BY VISIT_NUMBER, WORKORDER_ID, ORGANIZATION_ID;
• Locating records by the legacy alias: SELECT SALES_ORDER_LINE_ID, WORKORDER_OPERATION_ID, INVENTORY_ITEM_ID FROM AHL_JOB_OPER_MATERIALS_V;

Because SALES_ORDER_LINE_ID is a column alias for SCHEDULED_MATERIAL_ID, queries filtering on the searched term should treat it as the scheduled material identifier, not an Order Management sales order line.