1       09:07:11  SQL Execute: ORACLE - Select sf_yj_GetWbsm('55555') wbsm00,sf_yj_Getpysm('55555') pysm00 from dual where rownum=1

2       09:07:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
3       09:07:11  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
       trim(m.yfid00)=Trim(f.yfid00(+)) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

4       09:07:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
5       09:07:11  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

6       09:07:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
7       09:07:11  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

8       09:07:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
9       09:07:18  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
       trim(m.yfid00)=Trim(f.yfid00(+)) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

10      09:07:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
11      09:07:18  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

12      09:07:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68129.000000
13      09:07:18  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