update

--check masih ada gak datanya
select *
from m_product
where brand_id = 100131
and tenant_id = 10
and active = 'Y'
and base_uom_id <> 10;
--lakukan update
begin;
UPDATE m_product
SET base_uom_id = (select uom_id from m_uom where uom_code = 'BOX')
WHERE tenant_id = 10
AND brand_id = 100131
AND active = 'Y'
AND base_uom_id <> 10
AND
product_code IN
(
'011400001000',
'011400002000',
'011400003000',
'011400004000',
'011400005000',
'011400006000',
'011400007000',
'011400008000',
'011400009000',
'011400010000',
'011400011000',
'011400012000',
'011400013000',
'011400014000',
'011400015000',
'011400016000',
'011400017000',
'011400018000',
'011400019000',
'011400020000',
'011400021000',
'011400022000',
'011400023000',
'011400024000',
'011400025000',
'011400026000',
'011400027000',
'011400028000',
'011400029000',
'011400030000',
'011400031000',
'011400032000',
'011400033000',
'011400034000',
'011400035000',
'011400036000',
'011400037000',
'011400038000',
'011400039000',
'011400040000',
'011400041000',
'011400042000',
'011400043000',
'011400044000',
'011400045000',
'011400046000',
'011400047000',
'011400048000',
'011400049000',
'011400050000',
'011400051000',
'011400052000',
'011400053000',
'011400054000',
'011400055000',
'011400056000',
'011400057000',
'011400058000',
'011400059000',
'011400060000',
'011400061000',
'011400062000',
'011400063000',
'011400064000',
'011400065000',
'011400066000',
'011400067000',
'011400068000',
'011400069000',
'011400070000',
'011400071000',
'011400072000',
'011400073000',
'011400074000',
'011400075000',
'011400076000',
'011400077000',
'011400078000',
'011400079000',
'011400080000',
'011400081000',
'011400082000',
'011400083000',
'011400084000',
'011400085000',
'011400086000',
'011400087000',
'011400088000',
'011400089000',
'011400090000',
'011400091000',
'011400092000',
'011400093000',
'011400094000',
'011400095000',
'011400096000',
'011400097000',
'011400098000',
'011400099000',
'011400100000',
'011400101000',
'011400102000',
'011400103000',
'011400104000',
'011400105000',
'011400106000',
'011400107000',
'011400108000',
'011400109000',
'011400110000',
'011400111000',
'011400112000',
'011400113000',
'011400114000',
'011400115000',
'011400116000',
'011400117000',
'011400118000',
'011400119000',
'011400120000',
'011400121000',
'011400122000',
'011400123000',
'011400124000',
'011400125000',
'011400126000',
'011400127000',
'011400128000',
'011400129000',
'011400130000',
'011400131000',
'011400132000',
'011400133000',
'011400134000',
'011400135000',
'011400136000',
'011400137000',
'011400138000',
'011400139000',
'011400140000',
'011400141000',
'011400142000',
'011400143000',
'011400144000',
'011400145000',
'011400146000',
'011400147000',
'011400148000',
'011400149000',
'011400150000',
'011400151000',
'011400152000',
'011400153000',
'011400154000',
'011400155000',
'011400156000',
'011400157000',
'011400158000',
'011400159000',
'011400160000',
'011400161000',
'011400162000',
'011400163000',
'011400164000',
'011400165000'
);
--rollback