select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177587');
update inb_det set unit_price='70.08'where wms_sorder in(select sorder from sorder where act_sorder='177587');
select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177587');
update sorder_prod set unit_price='70.08' where sorder in(select sorder from sorder where act_sorder='177587');
select * from cdf_det where sp_order in(select sorder from sorder where act_sorder='177525');
update cdf_det set hand_book_no='E23149000019'where sp_order in(select sorder from sorder where act_sorder='177525');
select * from inb_det where wms_sorder in(select sorder from sorder where act_sorder='177505');
update inb_det set gross_wt='14149.1'where wms_sorder in(select sorder from sorder where act_sorder='177505');
select * from sorder_prod where sorder in(select sorder from sorder where act_sorder='177505');
update sorder_prod set gross_wt='14149.1' where sorder in(select sorder from sorder where act_sorder='177505');
select * from sorder where act_sorder='177364'
update sorder set inbound_list='B00000000000359083'where act_sorder='177364'