Difference between revisions of "IDL TSM"
(Created page with "= Introduction = = Note / Catatan = Copy target growth code snippet: <pre> update ret_gen_tsm_targetomzetgrow set target_growth_percentage = v1.target_growth_percentage fro...") |
(→Note / Catatan) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
= Introduction = | = Introduction = | ||
| + | |||
| + | = Windows = | ||
| + | |||
| + | = Processes = | ||
| + | == Standard Process == | ||
| + | |||
| + | == Background Process == | ||
| + | |||
| + | = Tables = | ||
= Note / Catatan = | = Note / Catatan = | ||
| Line 23: | Line 32: | ||
-- and ret_gen_tsm_targetomzetgrow.sku = '8010024570' | -- and ret_gen_tsm_targetomzetgrow.sku = '8010024570' | ||
</pre> | </pre> | ||
| + | |||
| + | {{BackTo |Category:Customer_Specific}} | ||
| + | [[Category:Client_Module]] | ||
Latest revision as of 12:12, 3 January 2022
Contents
Introduction
Windows
Processes
Standard Process
Background Process
Tables
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'
 |
Back to |
