Search Results ahl_visit_task_matrl_v




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, the APPS.AHL_VISIT_TASK_MATRL_V view is a reporting and integration construct within the AHL (Complex Maintenance Repair and Overhaul) product family. Its documented purpose is to store the query that retrieves workflow information — specifically, material requirements associated with a maintenance visit task. The view joins scheduled material lines (the planned consumption of inventory items for a visit task) to their originating repair-order operation materials, enriching each row with visit task descriptions, item descriptions, unit of measure, position path context, and rework/replace percentages.

Because it presents a denormalized, read-only projection, the view is well suited for operational reporting, integration extracts, and dependent views rather than transactional data entry. The user's search term schedule_material_id maps directly to a column exposed by this view: ASMT.SCHEDULED_MATERIAL_ID SCHEDULE_MATERIAL_ID. This is the surrogate identifier of the scheduled material record in the underlying schedule material table, and it is central to joining visit task planning data back to material demand.

Underlying Base Objects

The view is defined over the following documented base objects and synonyms owned or referenced in the APPS schema:

A notable filter is ASMT.REQUESTED_QUANTITY <> 0, which excludes zero-quantity requested records, and the item flexfields are outer-joined, so rows are retained even when no matching item definition exists.

Key Columns

Common Use Cases and Queries

A typical application is listing all scheduled materials for a given visit task, including item detail and position path, to feed material availability reports or work order picks.

SELECT visit_id, visit_task_name, schedule_material_id,
       item_description, scheduled_quantity, uom, position_path
  FROM apps.ahl_visit_task_matrl_v
 WHERE visit_id = :p_visit_id
 ORDER BY visit_task_id, operation_sequence;

To trace a specific scheduled material back to its repair order operation material rework/replace profile:

SELECT schedule_material_id, rt_oper_material_id, item_description,
       rework_percent, replace_percent, item_comp_detail_id
  FROM apps.ahl_visit_task_matrl_v
 WHERE schedule_material_id = :p_schedule_material_id;

Because the view enforces the non-zero requested quantity filter and resolves descriptive attributes, it is commonly reused as a source for downstream custom views and BI Publisher data templates rather than queried transactionally. Queries should be constrained by VISIT_ID, VISIT_TASK_ID, or SCHEDULE_MATERIAL_ID to avoid full scans across the AHL schedule material population.