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'));


1	3C5D59EA0D0D47DBA5ED04E4A62C32AE73 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');
51	49AB96C4C86E41E2AB96DFA9AFEBA48B19
51	CC0FC6516C234C05A0025640946BAD4918
3	23970F2BAB0747B1ACEC92411E74C58437
51	C1D3348899A14B488B8AD2E8CCDABEE086
11	CE7B5C17816F4FB3B7F7E5FC6FFDA1A318
3	2A25D6BDD1E944AFB349E924B1886AD972
4	122C5482CA7C4047A845C263475316D403
10	DCE67B61E7724AA9823A83FD9E40987771
9	3AA80EC6B3D649B9A515E45709D33CCF65
5	6D460F38060846C09BC95C1FA62E6F9A55
2	A7F110F15DCE40639F9F24FB3E5F841661
8	54E26BE645B94FE8B68A1B956A3455C258
12	210F7AF2951446C1BAE403ABE3791E0E37
12	5F45C5F881734E10A1FBA91EEA40378749