[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT requested_quantity,
NVL(completed_quantity, 0) completed_quantity
FROM ahl_schedule_materials
WHERE scheduled_material_id = c_scheduled_material_id;
SELECT SUM(primary_reservation_quantity) reserved_quantity
FROM mtl_reservations mrsv,ahl_schedule_materials asmt
WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
AND mrsv.external_source_code = 'AHL'
AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
AND mrsv.organization_id = asmt.organization_id
AND mrsv.requirement_date = asmt.requested_date
AND mrsv.inventory_item_id = asmt.inventory_item_id
GROUP BY mrsv.demand_source_line_detail;
SELECT scheduled_material_id
FROM ahl_schedule_materials
WHERE scheduled_material_id = c_SCHEDULED_MATERIAL_ID
AND organization_id = c_organization_ID
AND inventory_item_id = c_item_ID
AND visit_task_id = c_visit_task_ID
AND rt_oper_material_id = c_rt_oper_material_id
AND status = 'ACTIVE'
AND requested_quantity <>0
AND EXISTS ( SELECT 1
FROM ahl_visit_tasks_b vt
WHERE vt.status_code = 'PLANNING'
AND vt.visit_task_id = c_visit_task_id);
SELECT scheduled_material_id
FROM ahl_schedule_materials
WHERE scheduled_material_id = c_scheduled_material_id
AND organization_id = c_organization_id
AND inventory_item_id = c_item_id
AND Operation_sequence = c_oper_seq_num
AND status = 'ACTIVE'
AND requested_quantity <>0
AND visit_task_id = ( SELECT aw.visit_task_id
FROM ahl_visit_tasks_b vt, ahl_workorders aw
WHERE vt.status_code IN ('PLANNING','RELEASED')
AND aw.wip_entity_id = c_wip_entity_id
AND aw.status_code in ('1','3')
AND aw.visit_task_id= vt.visit_task_id );