IDL TSM - Revision history

Wikiadmin: /* Note / Catatan */

2022-01-03T05:12:58Z

‎Note / Catatan

Wikiadmin at 05:12, 3 January 2022

2022-01-03T05:12:29Z

Wikiadmin: /* Note / Catatan */

2022-01-03T05:12:11Z

‎Note / Catatan

Wikiadmin at 05:10, 3 January 2022

2022-01-03T05:10:56Z

Wikiadmin at 01:29, 3 January 2022

2022-01-03T01:29:52Z

Wikiadmin: /* Processes */

2022-01-03T01:25:47Z

‎Processes

Wikiadmin: /* Background Processes */

2022-01-03T01:25:07Z

‎Background Processes

Wikiadmin: /* Introduction */

2022-01-03T01:18:42Z

‎Introduction

Wikiadmin at 01:04, 2 January 2022

2022-01-02T01:04:49Z

Wikiadmin: Created page with "= Introduction = = Note / Catatan = Copy target growth code snippet:

 update ret_gen_tsm_targetomzetgrow  set target_growth_percentage = v1.target_growth_percentage fro..."

2022-01-02T00:49:25Z

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..."

New page

= Introduction =

= Note / Catatan =

Copy target growth code snippet:
<pre>
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'
</pre>

@@ Line 33: / Line 33: @@
 </pre>
-{{BackTo | Customer_Specific}}
+{{BackTo |Category:Customer_Specific}}
 [[Category:Client_Module]]

@@ Line 33: / Line 33: @@
 </pre>
-{{BackTo | Category:Customer_Specific}}
+{{BackTo | Customer_Specific}}
 [[Category:Client_Module]]

← Older revision		Revision as of 05:12, 3 January 2022
Line 34:		Line 34:

	{{BackTo \| Category:Customer_Specific}}		{{BackTo \| Category:Customer_Specific}}
−	~~[[Category:Customer_Specific]]~~
	[[Category:Client_Module]]		[[Category:Client_Module]]

@@ Line 33: / Line 33: @@
 </pre>
 [[Category:Customer_Specific]]
 [[Category:Client_Module]]

@@ Line 33: / Line 33: @@
 </pre>
+[[Category:Customer_Specific]]
 [[Category:Client_Module]]

← Older revision		Revision as of 01:25, 3 January 2022
Line 4:		Line 4:

	= Processes =		= Processes =
		+	== Standard Process ==
		+
		+	== Background Process ==

	= Tables =		= Tables =

@@ Line 3: / Line 3: @@
 = Windows =
-= Background Processes =
+= Processes =
 = Tables =

← Older revision		Revision as of 01:18, 3 January 2022
Line 1:		Line 1:
	= Introduction =		= Introduction =
		+
		+	= Windows =
		+
		+	= Background Processes =
		+
		+	= Tables =

	= Note / Catatan =		= Note / Catatan =

← Older revision		Revision as of 01:04, 2 January 2022
Line 23:		Line 23:
	-- and ret_gen_tsm_targetomzetgrow.sku = '8010024570'		-- and ret_gen_tsm_targetomzetgrow.sku = '8010024570'
	</pre>		</pre>
		+
		+
		+	[[Category:Client_Module]]