select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='3C5D59EA0D0D47DBA5ED04E4A62C32AE73'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='49AB96C4C86E41E2AB96DFA9AFEBA48B19'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='CC0FC6516C234C05A0025640946BAD4918'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='23970F2BAB0747B1ACEC92411E74C58437'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='C1D3348899A14B488B8AD2E8CCDABEE086'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='CE7B5C17816F4FB3B7F7E5FC6FFDA1A318'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='2A25D6BDD1E944AFB349E924B1886AD972'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='122C5482CA7C4047A845C263475316D403'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='DCE67B61E7724AA9823A83FD9E40987771'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='3AA80EC6B3D649B9A515E45709D33CCF65'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='6D460F38060846C09BC95C1FA62E6F9A55'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='A7F110F15DCE40639F9F24FB3E5F841661'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='54E26BE645B94FE8B68A1B956A3455C258'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='210F7AF2951446C1BAE403ABE3791E0E37'));
select * from  inv_invoice  WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  STEP_ID from rtstep where GUID='5F45C5F881734E10A1FBA91EEA40378749'));

UPDATE inv_invoice SET FUNCSTEPID=1, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='3C5D59EA0D0D47DBA5ED04E4A62C32AE73');
UPDATE inv_invoice SET FUNCSTEPID=51, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='49AB96C4C86E41E2AB96DFA9AFEBA48B19');
UPDATE inv_invoice SET FUNCSTEPID=51, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='CC0FC6516C234C05A0025640946BAD4918');
UPDATE inv_invoice SET FUNCSTEPID=3, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='23970F2BAB0747B1ACEC92411E74C58437');
UPDATE inv_invoice SET FUNCSTEPID=51, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='C1D3348899A14B488B8AD2E8CCDABEE086');
UPDATE inv_invoice SET FUNCSTEPID=11, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='CE7B5C17816F4FB3B7F7E5FC6FFDA1A318');
UPDATE inv_invoice SET FUNCSTEPID=3, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='2A25D6BDD1E944AFB349E924B1886AD972');
UPDATE inv_invoice SET FUNCSTEPID=4, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='122C5482CA7C4047A845C263475316D403');
UPDATE inv_invoice SET FUNCSTEPID=10, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='DCE67B61E7724AA9823A83FD9E40987771');
UPDATE inv_invoice SET FUNCSTEPID=9, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='3AA80EC6B3D649B9A515E45709D33CCF65');
UPDATE inv_invoice SET FUNCSTEPID=5, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='6D460F38060846C09BC95C1FA62E6F9A55');
UPDATE inv_invoice SET FUNCSTEPID=2, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='A7F110F15DCE40639F9F24FB3E5F841661');
UPDATE inv_invoice SET FUNCSTEPID=8, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='54E26BE645B94FE8B68A1B956A3455C258');
UPDATE inv_invoice SET FUNCSTEPID=12, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='210F7AF2951446C1BAE403ABE3791E0E37');
UPDATE inv_invoice SET FUNCSTEPID=12, STATUS=0 WHERE FUNCSTEPID=11 and caseid in (select case_id from rtcase where step_id in (select  step_id from rtstep where GUID='5F45C5F881734E10A1FBA91EEA40378749');