select item_id from 0p4_item where item_code 
in (
'UNI-UMN S 38DS-ACG',
'UNI-UMN S 38DS-CBR',
'UNI-UMN S 38DS-MGO',
'UNI-UMN S 38DS-NBU',
'UNI-UMN S 38DS-PRD',
'UNI-UMN S 38DS-SGY',
'UNI-UMN S 38DS-BK1',
'UNI-UMN S 38DS-BK2',
'UNI-UMN S 38DS 3C-PX',
'UNI-UMN S 38DS 3C-DN',
'UNI-UMN S 05 FIKA-7C',
'UNI-UMN S 05F-AGN',
'UNI-UMN S 05F-CBR',
'UNI-UMN S 05F-MOR',
'UNI-UMN S 05F-NBU',
'UNI-UMN S 05F-PRD',
'UNI-UMN S 05F-PPU',
'UNI-UMN S 05F-SGY'
);
	
update 0p4_item set item_code='UNI-UMN S 38DF-ACGN',art_no='UMN S 38DF-ACGN'
where item_code='UNI-UMN S 38DS-ACG' ;


update 0p4_item set item_code='UNI-UMN S 38DF-CPBR',art_no='UMN S 38DF-CPBR'
where item_code='UNI-UMN S 38DS-CBR';

update 0p4_item set item_code='UNI-UMN S 38DF-MGOR',art_no='UMN S 38DF-MGOR'
where item_code='UNI-UMN S 38DS-MGO' ;

update 0p4_item set item_code='UNI-UMN S 38DF-NMBU',art_no='UMN S 38DF-NMBU'
where item_code='UNI-UMN S 38DS-NBU' ;

    
update 0p4_item set item_code='UNI-UMN S 38DF-PYRD',art_no='UMN S 38DF-PYRD'
where item_code='UNI-UMN S 38DS-PRD';

update 0p4_item set item_code='UNI-UMN S 38DF-SSGY',art_no='UMN S 38DF-SSGY'
where item_code='UNI-UMN S 38DS-SGY' ;

update 0p4_item set item_code='UNI-UMN S 38DF-BK1',art_no='UMN S 38DF-BK1'
where item_code='UNI-UMN S 38DS-BK1' ;

update 0p4_item set item_code='UNI-UMN S 38DF-BK2',art_no='UMN S 38DF-BK2'
where item_code='UNI-UMN S 38DS-BK2' ;

update 0p4_item set item_code='UNI-UMN S 38DF 3C-PX',art_no='UMN S 38DF 3C-PX'
where item_code='UNI-UMN S 38DS 3C-PX' ;

update 0p4_item set item_code='UNI-UMN S 38DF 3C-DN',art_no='UMN S 38DF 3C-DN'
where item_code='UNI-UMN S 38DS 3C-DN' ;

update 0p4_item set item_code='UNI-UMN S 05F-7C',art_no='UMN S 05F-7C'
where item_code='UNI-UMN S 05 FIKA-7C' ;

update 0p4_item set item_code='UNI-UMN S 05F-ACGN',art_no='UMN S 05F-ACGN'
where item_code='UNI-UMN S 05F-AGN' ;

update 0p4_item set item_code='UNI-UMN S 05F-CPBR',art_no='UMN S 05F-CPBR'
where item_code='UNI-UMN S 05F-CBR' ;
    
update 0p4_item set item_code='UNI-UMN S 05F-MGOR',art_no='UMN S 05F-MGOR'
where item_code='UNI-UMN S 05F-MOR';

update 0p4_item set item_code='UNI-UMN S 05F-NMBU',art_no='UMN S 05F-NMBU'
where item_code='UNI-UMN S 05F-NBU' ;

update 0p4_item set item_code='UNI-UMN S 05F-PYRD',art_no='UMN S 05F-PYRD'
where item_code='UNI-UMN S 05F-PRD' ;

update 0p4_item set item_code='UNI-UMN S 05F-PMPU',art_no='UMN S 05F-PMPU'
where item_code='UNI-UMN S 05F-PPU' ;

update 0p4_item set item_code='UNI-UMN S 05F-SSGY',art_no='UMN S 05F-SSGY'
where item_code='UNI-UMN S 05F-SGY' ;


-- 7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146