IDL TSM
Introduction
Note / Catatan
Copy target growth code snippet:
update ret_gen_tsm_targetomzetgrow set target_growth_percentage = v1.target_growth_percentage from ( select l.m_product_id ,l.sku ,l.target_growth_percentage ,h.version_name from ret_gen_tsm_targetomzetgrow l inner join ret_gen_tsm_targetomzet h on l.ret_gen_tsm_targetomzet_id = h.ret_gen_tsm_targetomzet_id where l.ret_gen_tsm_targetomzet_id ='097B93C8C064436BB032659DD62F0DF8' -- source version -- and l.sku = '8010012659' and l.target_growth_percentage <> 0 ) v1 where ret_gen_tsm_targetomzetgrow.m_product_id = v1.m_product_id and ret_gen_tsm_targetomzetgrow.ret_gen_tsm_targetomzet_id = 'B026088A88F1498AA832572BFBB3D075' -- destination version -- and ret_gen_tsm_targetomzetgrow.sku = '8010024570'