Script 2

SELECT * FROM mlm_member A
WHERE member_code IN ('0000000012','0000000016','0000000027','0000000031','0000000065','0000000072','0000000225','0000000753')
AND NOT EXISTS(
	SELECT 1
	FROM mlm_ds B
	WHERE a.member_id = B.member_id
)






INSERT INTO mlm_ds(
member_id,partner_id,zone,longitude,latitude,ds_date,active,active_datetime,non_active_datetime,create_user_id,create_datetime,update_datetime, update_user_id,version,area_sales_id)
SELECT member_id,-99,' ',0,0,' ','N',' ',' ',-99,' ','20161011000000',-99,0,-99
FROM mlm_member P
WHERE EXISTS(
	select 1
	from zzz_temp_saldo_awal_ar_20161011 a
	where a.amount <> 0
	and NOT exists (
		select 1
		from mlm_ds c
		where P.member_id = c.member_id
	)
	AND A.member_code = P.member_code
)


insert sebagai DS yang belum ada dan tidak aktif
insert sebagai partner (customer aktif)



SELECT f_get_value_system_config_by_param_code(11, 'MLM.DS.PARTNER.TYPE');