begin
for i in (select id, item_id, specifications
from mrp_mps_schedule
where specifications is null) loop
update mrp_mps_schedule
set specifications =
(select specifications from bom_item where id = i.item_id) where id = i.id;
end loop;
end;