use T22C001

update finished_item_master SET ITEMPER= 'P'
update finished_item_master SET ITEMPER= 'M' WHERE ITEMNAME IN (SELECT ITEMNAME FROM BILL_ITEM_DETAIL WHERE ITEMPER='M')