1       16:16:41  SQL Prepare: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='64834' and t1.SCKBH0='6000001051'

2       16:16:41  SQL Execute: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='64834' and t1.SCKBH0='6000001051'

3       16:16:41  SQL Prepare: ORACLE - select c.JHCKBH,a.*,c.ckbh00,c.ckmc00,substr(a.NL0000,1,16) NL0001,(Select LBMC00 FROM BM_GHLBB0 WHERE LBBH00=a.GHLB00) GHLBMC from vw_ys_hzbr00 a,sf_ysghhb b,bm_ckbm00 c where a.jzks00 in (64834,64834,64834) and  a.dlxh00>0  
and a.hzzt00 in ('0','2','4' )  and a.yspbid=b.ghhbid and b.ghhzck=c.ckbh00 and c.flag00='4' 
 order by a.jzys00,a.dlxh00

4       16:16:41  SQL Execute: ORACLE - select c.JHCKBH,a.*,c.ckbh00,c.ckmc00,substr(a.NL0000,1,16) NL0001,(Select LBMC00 FROM BM_GHLBB0 WHERE LBBH00=a.GHLB00) GHLBMC from vw_ys_hzbr00 a,sf_ysghhb b,bm_ckbm00 c where a.jzks00 in (64834,64834,64834) and  a.dlxh00>0  
and a.hzzt00 in ('0','2','4' )  and a.yspbid=b.ghhbid and b.ghhzck=c.ckbh00 and c.flag00='4' 
 order by a.jzys00,a.dlxh00

5       16:27:38  SQL Prepare: ORACLE - Update SF_HZBR00 set JHCS00=NVL(JHCS00,0)+ 2 where ID0000=600017513204

6       16:27:38  SQL Execute: ORACLE - Update SF_HZBR00 set JHCS00=NVL(JHCS00,0)+ 2 where ID0000=600017513204

7       16:27:38  SQL Data In: ORACLE - Rows affected = 1
8       16:27:38  SQL Prepare: ORACLE - Commit

9       16:27:38  SQL Execute: ORACLE - Commit

10      16:27:38  SQL Data In: ORACLE - Rows affected = 0