1       16:13:03  SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
2       16:13:03  SQL Data In: ORACLE - Param = 2, Name = AD_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2847333.000000
3       16:13:03  SQL Data In: ORACLE - Param = 3, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000002000004
4       16:13:03  SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
5       16:13:03  SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
6       16:13:03  SQL Execute: ORACLE - BEGIN "SP_SF_TSBZ00_REG000" (AD_BRID00 => :AD_BRID00,AD_GHID00 => :AD_GHID00,AS_TSBZBH => :AS_TSBZBH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
7       16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
8       16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1495375     
9       16:13:03  SQL Execute: ORACLE -  select count(1) TsbzNum from  VW_SF_YBTZBZ A  where  1=1
 and a.djh000+0=0 and A.BRID00 = ?
 and trim(a.tsbzbh) is not null
 and a.GHH000= ?

10      16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
11      16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1495375     
12      16:13:03  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '0' 
  and  A.GHH000 = ?

13      16:13:03  SQL Execute: ORACLE - update YF_MZCF00 A SET  SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null  and A.CFZT00 = '0'  and  A.CFLSH0 in ('1544319         ')

14      16:13:03  SQL Data In: ORACLE - Rows affected = 0
15      16:13:03  SQL Execute: ORACLE - commit

16      16:13:03  SQL Data In: ORACLE - Rows affected = 0
17      16:13:03  SQL Execute: ORACLE - select  SF_MZ_PSCFYS('1495375','1544319         ') NFJJ00  from  dual 

18      16:13:03  SQL Execute: ORACLE -  select  * from  VW_SF_CFMX00 where  CFLSH0 in ('1544319         ')

19      16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5358.000000
20      16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
21      16:13:03  SQL Execute: ORACLE -  select B.XMMC00 YBXMMC,A.*  from  VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00  
 and A.YBZXLB = B.YBZXLB  and  A.SFXMID =?  and A.YBZXLB=?  and  A.SFYP00 ='Y'

22      16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
23      16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1495375     
24      16:13:03  SQL Execute: ORACLE -  select a.djlsh0,a.zldccf,a.cfyjbz from vw_sf_wjzcf a where a.BRID00 = ?
 and cfyjbz = '1' 
  and  A.GHH000 = ?

25      16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
26      16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
27      16:13:03  SQL Execute: ORACLE -  select  B.JFLBMC,A.*  from  sf_brzhxx  A,BM_BRJFLB B  where A.JFLBID = B.JFLBID  
 and  A.JFLBID = ?
 and  BRID00 = ? 

28      16:13:03  SQL Execute: ORACLE - select a.*,(select FBMC00 from BM_BRFBB0 where FBBH00=a.FBBH00 ) FBMC00 from bm_ybbrlb a,SF_BRXXB0 b where instr(',29,',','||to_char(a.FBBH00)||',')>0 and MZZFSX>0  and b.GHID00=2847333 and a.FBBH00=b.FBBH00

29      16:13:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59749.000000
30      16:13:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150428
31      16:13:03  SQL Execute: ORACLE - Select (nvl(sum(HJJE00),0)-nvl(sum(ybyl19),0)) HJJE00 from sf_jzb000 where BRID00=? and JZRQ00=? and FBBH00=3 AND YBDJH0<>'0'