1       14:43:36  SQL Execute: ORACLE -  Update SF_BRXXB0 set THBZ00='2',JZYS00=DECODE(JZYS00,NULL,1913,0,1913,JZYS00), JZRQ00=DECODE(JZRQ00,NULL,TO_CHAR(SYSDATE,'YYYYMMDD'),'',TO_CHAR(SYSDATE,'YYYYMMDD'),JZRQ00), JZSJ00=DECODE(JZSJ00,NULL,TO_CHAR(SYSDATE,'HH24:MI:SS'),'',TO_CHAR(SYSDATE,'HH24:MI:SS'),JZSJ00) where GHH000='3802721' and THBZ00='1'

2       14:43:36  SQL Data In: ORACLE - Rows affected = 0
3       14:43:36  SQL Execute: ORACLE - Commit

4       14:43:36  SQL Data In: ORACLE - Rows affected = 0
5       14:43:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 474
6       14:43:36  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
7       14:43:36  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 3802721     
8       14:43:36  SQL Execute: ORACLE - select id0000 from sf_hzbr00 where jzks00=? and ghys00=? and ghh000=? and hzzt00<>'3' and hzzt00<>'Z' 

9       14:43:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
10      14:43:36  SQL Execute: ORACLE -  select YGBH00 from XT_YHZB00 a,XT_ZBQX00 b,xt_xtmk00 c 
 where a.zbdm00=a.zbdm00 and b.mkdm00=c.mkdm00
 and mknbmc='YS_P_BRHZCL' and a.ygbh00=?

11      14:43:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
12      14:43:36  SQL Execute: ORACLE - select GHHZCK from  vw_sf_ysghhb  where GHYSBH=?
 AND  GHMZSJ >= to_char(sysdate-1, 'YYYYMMDD' ) and  TZBZ00 = '0'
 and  ((((GHXHS0-YYXHS0)>(GHYGHS-GHYYHS)) and (SFZJGH='0')) OR (SFZJGH='1'))
 and (
(GHJSSJ >= GHQSSJ 
 and  GHJSSJ >= to_char(sysdate,'HH24:MI:SS') 
 and  GHQSSJ <= to_char(sysdate,'HH24:MI:SS') 
 and  GHMZSJ = to_char(sysdate,'YYYYMMDD')
     )
      or 
     (GHJSSJ <  GHQSSJ 
 and  ((GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) 
        and  GHQSSJ <= to_char(sysdate,'HH24:MI:SS' ) 
        ) or 
       (GHMZSJ = to_char(sysdate-1, 'YYYYMMDD' ) 
        and  GHJSSJ >= to_char(sysdate,'HH24:MI:SS' ) 
        ) 
      )  
      )  
 )  

13      14:43:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913
14      14:43:36  SQL Execute: ORACLE -  select YGBH00 from XT_YHZB00 a,XT_ZBQX00 b,xt_xtmk00 c 
 where a.zbdm00=a.zbdm00 and b.mkdm00=c.mkdm00
 and mknbmc='YS_P_BRHZCL' and a.ygbh00=?