Urgent help needed!!

[balajiyes]

try this...
update temp_schedrcpts u
set manu_item = (select imlitm from F4101 x
where x.imaitm = u.legacy_item)
where exists (select 1 from F4101 x
where x.imaitm = u.legacy_item);