1       11:21:38  SQL Prepare: ORACLE - SELECT MXZLSH,YKBMBH,YPRKPC,YPCKPC,YPNM00,YPMC00,YPGG00,
JZRQ00,JZSJ00,CRBMBH,ZY0000,JZDW00,ZHL000,GJDJ00,
SLDJ00,SLSL00,SLJE00,FCDJ00,FCSL00,FCJE00,
RCLXBH,RCLXMC,JZXZ00,SCPH00,YPSXRQ,
DECODE(JZXZ00,'R',GJDJ00,NULL) AS SLGJDJ,
DECODE(JZXZ00,'R',SLSL00*GJDJ00,NULL) AS SLJZJE,
DECODE(JZXZ00,'R',SLJE00-SLSL00*GJDJ00,NULL) AS SLCJ00,
DECODE(JZXZ00,'C',GJDJ00,NULL) AS FCGJDJ,
DECODE(JZXZ00,'C',GJDJ00*FCSL00,NULL) AS FCJJJE,
DECODE(JZXZ00,'C',FCJE00-GJDJ00*FCSL00,NULL) AS FCCJ00,
round(DECODE(JZXZ00,'R',DECODE(GJDJ00,0,0,SLDJ00/GJDJ00),NULL),2) AS KL0000,DJH000,SFSH00,
ZYJCSL JCSL00,decode(ZYJCSL,0,0,round(ZYGJJE/ZYJCSL,2)) JCGJDJ,
decode(ZYJCSL,0,0,round(ZYJCJE/ZYJCSL,2)) JCDJ00,
ZYGJJE JCGJJE,ZYJCJE JCJE00,ZYJCJE-ZYGJJE JCCJ00
FROM YK_YPMXZ0
WHERE YPNM00=:1
  AND YKBMBH+0=:2
  AND JZRQ00>=:3
  AND JZRQ00<=:4
  AND SFSH00 in ('Y','J')
ORDER BY DECODE(SFSH00,'Y',DECODE(NVL(YJZRQ0,'9'),'9','99999999',SHRQ00),SHRQ00),
SHRQ00,substr(JZRQ00,1,6),SHSJ00

2       11:21:38  SQL Execute: ORACLE - SELECT MXZLSH,YKBMBH,YPRKPC,YPCKPC,YPNM00,YPMC00,YPGG00,
JZRQ00,JZSJ00,CRBMBH,ZY0000,JZDW00,ZHL000,GJDJ00,
SLDJ00,SLSL00,SLJE00,FCDJ00,FCSL00,FCJE00,
RCLXBH,RCLXMC,JZXZ00,SCPH00,YPSXRQ,
DECODE(JZXZ00,'R',GJDJ00,NULL) AS SLGJDJ,
DECODE(JZXZ00,'R',SLSL00*GJDJ00,NULL) AS SLJZJE,
DECODE(JZXZ00,'R',SLJE00-SLSL00*GJDJ00,NULL) AS SLCJ00,
DECODE(JZXZ00,'C',GJDJ00,NULL) AS FCGJDJ,
DECODE(JZXZ00,'C',GJDJ00*FCSL00,NULL) AS FCJJJE,
DECODE(JZXZ00,'C',FCJE00-GJDJ00*FCSL00,NULL) AS FCCJ00,
round(DECODE(JZXZ00,'R',DECODE(GJDJ00,0,0,SLDJ00/GJDJ00),NULL),2) AS KL0000,DJH000,SFSH00,
ZYJCSL JCSL00,decode(ZYJCSL,0,0,round(ZYGJJE/ZYJCSL,2)) JCGJDJ,
decode(ZYJCSL,0,0,round(ZYJCJE/ZYJCSL,2)) JCDJ00,
ZYGJJE JCGJJE,ZYJCJE JCJE00,ZYJCJE-ZYGJJE JCCJ00
FROM YK_YPMXZ0
WHERE YPNM00=?
  AND YKBMBH+0=?
  AND JZRQ00>=?
  AND JZRQ00<=?
  AND SFSH00 in ('Y','J')
ORDER BY DECODE(SFSH00,'Y',DECODE(NVL(YJZRQ0,'9'),'9','99999999',SHRQ00),SHRQ00),
SHRQ00,substr(JZRQ00,1,6),SHSJ00

3       11:21:42  SQL Prepare: ORACLE - SELECT MXZLSH,YKBMBH,YPRKPC,YPCKPC,YPNM00,YPMC00,YPGG00,
JZRQ00,JZSJ00,CRBMBH,ZY0000,JZDW00,ZHL000,GJDJ00,
SLDJ00,SLSL00,SLJE00,FCDJ00,FCSL00,FCJE00,
RCLXBH,RCLXMC,JZXZ00,SCPH00,YPSXRQ,
DECODE(JZXZ00,'R',GJDJ00,NULL) AS SLGJDJ,
DECODE(JZXZ00,'R',SLSL00*GJDJ00,NULL) AS SLJZJE,
DECODE(JZXZ00,'R',SLJE00-SLSL00*GJDJ00,NULL) AS SLCJ00,
DECODE(JZXZ00,'C',GJDJ00,NULL) AS FCGJDJ,
DECODE(JZXZ00,'C',GJDJ00*FCSL00,NULL) AS FCJJJE,
DECODE(JZXZ00,'C',FCJE00-GJDJ00*FCSL00,NULL) AS FCCJ00,
round(DECODE(JZXZ00,'R',DECODE(GJDJ00,0,0,SLDJ00/GJDJ00),NULL),2) AS KL0000,DJH000,SFSH00,
ZYJCSL JCSL00,decode(ZYJCSL,0,0,round(ZYGJJE/ZYJCSL,2)) JCGJDJ,
decode(ZYJCSL,0,0,round(ZYJCJE/ZYJCSL,2)) JCDJ00,
ZYGJJE JCGJJE,ZYJCJE JCJE00,ZYJCJE-ZYGJJE JCCJ00
FROM YK_YPMXZ0
WHERE YPNM00=:1
  AND YKBMBH+0=:2
  AND JZRQ00>=:3
  AND JZRQ00<=:4
  AND SFSH00 in ('Y','J')
ORDER BY DECODE(SFSH00,'Y',DECODE(NVL(YJZRQ0,'9'),'9','99999999',SHRQ00),SHRQ00),
SHRQ00,substr(JZRQ00,1,6),SHSJ00

4       11:21:42  SQL Execute: ORACLE - SELECT MXZLSH,YKBMBH,YPRKPC,YPCKPC,YPNM00,YPMC00,YPGG00,
JZRQ00,JZSJ00,CRBMBH,ZY0000,JZDW00,ZHL000,GJDJ00,
SLDJ00,SLSL00,SLJE00,FCDJ00,FCSL00,FCJE00,
RCLXBH,RCLXMC,JZXZ00,SCPH00,YPSXRQ,
DECODE(JZXZ00,'R',GJDJ00,NULL) AS SLGJDJ,
DECODE(JZXZ00,'R',SLSL00*GJDJ00,NULL) AS SLJZJE,
DECODE(JZXZ00,'R',SLJE00-SLSL00*GJDJ00,NULL) AS SLCJ00,
DECODE(JZXZ00,'C',GJDJ00,NULL) AS FCGJDJ,
DECODE(JZXZ00,'C',GJDJ00*FCSL00,NULL) AS FCJJJE,
DECODE(JZXZ00,'C',FCJE00-GJDJ00*FCSL00,NULL) AS FCCJ00,
round(DECODE(JZXZ00,'R',DECODE(GJDJ00,0,0,SLDJ00/GJDJ00),NULL),2) AS KL0000,DJH000,SFSH00,
ZYJCSL JCSL00,decode(ZYJCSL,0,0,round(ZYGJJE/ZYJCSL,2)) JCGJDJ,
decode(ZYJCSL,0,0,round(ZYJCJE/ZYJCSL,2)) JCDJ00,
ZYGJJE JCGJJE,ZYJCJE JCJE00,ZYJCJE-ZYGJJE JCCJ00
FROM YK_YPMXZ0
WHERE YPNM00=?
  AND YKBMBH+0=?
  AND JZRQ00>=?
  AND JZRQ00<=?
  AND SFSH00 in ('Y','J')
ORDER BY DECODE(SFSH00,'Y',DECODE(NVL(YJZRQ0,'9'),'9','99999999',SHRQ00),SHRQ00),
SHRQ00,substr(JZRQ00,1,6),SHSJ00