1       15:19:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
2       15:19:27  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
3       15:19:27  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 52015.000000
4       15:19:27  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,y.TZRQ00,  nvl((select ZTBZ00 from YF_YPKCXX where YFBMBH=? and YPNM00=m.YPNM00 and rownum=1),'1') ZTBZ00,  nvl((select PDXH00 from YF_YPKCXX where YFBMBH=? and YPNM00=m.YPNM00 and rownum=1),'0') PDXH00   from   xt_ypmbmx m,VW_YS_YYMBYD y,bm_ypyf00 f   where  m.ypnm00=y.ypnm00 and    m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' 
 and not exists(select 1 from BM_YD0000 a where a.YPNM00=y.YPNM00 and (a.MZDJ00<>'0' OR a.DPDJ00<>'0' OR a.SJDJ00<>'0' ) )
  order by zbbh00,znxh00