1       11:39:13  SQL Execute: ORACLE - Select * from xt_yzmblb where symbys=2 and mbgs00='0'

2       11:39:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 301
3       11:39:28  SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=?

4       11:39:31  SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=2 and mbgs00='0' and mblbbh='00'

5       11:39:31  SQL Execute: ORACLE - Select * from xt_yzmblb where symbys=2 and mbgs00='0'

6       11:39:31  SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

7       11:39:31  SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=2 and mbgs00='0') order by mbmc00

8       11:39:31  SQL Execute: ORACLE - Select sf_yj_GetWbsm('FDGF') wbsm00,sf_yj_Getpysm('FDGF') pysm00 from dual where rownum=1

9       11:39:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4911.000000
10      11:39:31  SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       m.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00,
       m.ypzsl0/y.m2j000 mzdwsl,m.QZFS00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=Trim(f.yfid00(+)) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

11      11:39:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4911.000000
12      11:39:31  SQL Execute: ORACLE - select  x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz,
x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00,
x.mcsl00,x.dw0000,x.bz0000
from  xt_zlmbmx x
where mbid00=?
order by xsxh00

13      11:39:31  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4911.000000
14      11:39:31  SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00,
       m.jl0000,m.yyzf00,m.xmyfmc,m.ypmc00,f.ypyfmc,y.jldw00,m.QZFS00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and
       m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1'
order by zbbh00,znxh00

15      11:39:31  SQL Execute: ORACLE - Update XT_ZLMBMX a set ZLXMJC=(select b.ZLXMJC from bm_zlzd00 b where a.zlxmid=b.zlxmid) where exists (select 1 from bm_zlzd00 c where a.zlxmid=c.zlxmid) and a.ZLXMID<>0

16      11:39:31  SQL Data In: ORACLE - Rows affected = 339
17      11:39:31  SQL Execute: ORACLE - commit

18      11:39:31  SQL Data In: ORACLE - Rows affected = 0
19      11:39:31  SQL Execute: ORACLE - select BMBH00,BMMC00,decode(trim(YYID00),'220307',0,1)  from BM_BMBM00 where BMXZ00='2' and FLAG00='1' and CZBZ00<>'2' order by decode(trim(YYID00),'220307',0,1),PXXH00 

20      11:39:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
21      11:39:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
22      11:39:42  SQL Execute: ORACLE -  Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and  ghysbh=? and ghksbh=?

23      11:39:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
24      11:39:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 13
25      11:39:42  SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and  jzys00=? and jzks00=?