1       11:17:09  SQL Prepare: ORACLE - SELECT a.MXZLSH,a.YKBMBH,a.YPRKPC,a.YPCKPC,a.YPNM00,a.YPMC00,a.YPGG00,
a.JZRQ00,a.JZSJ00,a.CRBMBH,a.ZY0000,a.JZDW00,a.ZHL000,a.GJDJ00,
a.SLDJ00,a.SLSL00,a.SLJE00,a.FCDJ00,a.FCSL00,a.FCJE00,a.JCDJ00,
a.JCSL00,a.JCJE00,a.RCLXBH,a.RCLXMC,a.JZXZ00,
DECODE(a.JZXZ00,'C',a.GJDJ00,NULL) AS FCGJDJ,       
DECODE(a.JZXZ00,'R',a.GJDJ00,NULL) AS SLGJDJ,
round(DECODE(a.JZXZ00,'R',decode(a.GJDJ00,0,0,a.SLDJ00/a.GJDJ00),NULL),2) AS KL0000,
a.JCGJDJ,a.JCGJJE,a.DJH000,a.SFSH00,a.SCPH00,
a.YPSXRQ,
DECODE(JZXZ00,'R',(select c.SCCJZW from YK_YPRKMX c where a.YPRKPC=c.YPRKPC),NULL) AS SCCJZW,
DECODE(JZXZ00,'R',(select c.ZBXH00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC),NULL) AS ZBXH00,
(select z.ZBQMC0 from BM_ZBQZD0 z where a.ZBQNM0=z.ZBQNM0) AS ZBQMC0,a.PZWH00,
(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC) AS RKFPH0,
(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC) AS RKFPRQ,
(select ypbm00 from bm_yd0000 where ypnm00=a.ypnm00) ypbm00
FROM YK_YPMXZ0 a
WHERE YPNM00=:1
  AND YKBMBH+0=:2
  AND JZRQ00>=:3
  AND JZRQ00<=:4
  and JZRQ00||JZSJ00>=:5
  and JZRQ00||JZSJ00<=:6
  AND SFSH00 <> 'J'
ORDER BY MXZLSH

2       11:17:09  SQL Execute: ORACLE - SELECT a.MXZLSH,a.YKBMBH,a.YPRKPC,a.YPCKPC,a.YPNM00,a.YPMC00,a.YPGG00,
a.JZRQ00,a.JZSJ00,a.CRBMBH,a.ZY0000,a.JZDW00,a.ZHL000,a.GJDJ00,
a.SLDJ00,a.SLSL00,a.SLJE00,a.FCDJ00,a.FCSL00,a.FCJE00,a.JCDJ00,
a.JCSL00,a.JCJE00,a.RCLXBH,a.RCLXMC,a.JZXZ00,
DECODE(a.JZXZ00,'C',a.GJDJ00,NULL) AS FCGJDJ,       
DECODE(a.JZXZ00,'R',a.GJDJ00,NULL) AS SLGJDJ,
round(DECODE(a.JZXZ00,'R',decode(a.GJDJ00,0,0,a.SLDJ00/a.GJDJ00),NULL),2) AS KL0000,
a.JCGJDJ,a.JCGJJE,a.DJH000,a.SFSH00,a.SCPH00,
a.YPSXRQ,
DECODE(JZXZ00,'R',(select c.SCCJZW from YK_YPRKMX c where a.YPRKPC=c.YPRKPC),NULL) AS SCCJZW,
DECODE(JZXZ00,'R',(select c.ZBXH00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC),NULL) AS ZBXH00,
(select z.ZBQMC0 from BM_ZBQZD0 z where a.ZBQNM0=z.ZBQNM0) AS ZBQMC0,a.PZWH00,
(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC) AS RKFPH0,
(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC) AS RKFPRQ,
(select ypbm00 from bm_yd0000 where ypnm00=a.ypnm00) ypbm00
FROM YK_YPMXZ0 a
WHERE YPNM00=?
  AND YKBMBH+0=?
  AND JZRQ00>=?
  AND JZRQ00<=?
  and JZRQ00||JZSJ00>=?
  and JZRQ00||JZSJ00<=?
  AND SFSH00 <> 'J'
ORDER BY MXZLSH