1 17:54:05 SQL Prepare: ORACLE - select JZRQ00,RCLXMC,YPMC00,YPGG00,SLGJDJ,SLSL00,GJSLJE, SLDJ00,FCGJDJ,SLJE00,FCDJ00, FCJE00,GJFCJE,FCSL00,JCDJ00, JCGJDJ,JCSL00,JCJE00,JCGJJE, JZDW00,DJH000,ZY0000,SFSH00,JZXZ00,JB0000,ghdwmc,SCCJZW,zbqmc0, zbxh00,ypsxrq,pzwh00,scph00,RKFPH0,RKFPRQ, (select ypbm00 from bm_yd0000 where ypnm00=x.ypnm00) ypbm00 from ( select a.MXZLSH,a.YPNM00,to_char(JLS000)||'条账目' JZRQ00,'到截止日期库存量:' ||trim(replace(to_char(b.JCSL00,'FM9999990.009')||' ','. ','')) YPMC00, '金额:'||trim(replace(to_char(b.JCJE00,'FM9999990.00')||' ','. ','')) YPGG00, ' 结余：' RCLXMC,'' SLSL00,'' SLJE00,'' JZDW00,'' FCSL00,'' FCJE00,'' JCSL00 ,'' JCJE00,'2' JB0000, '' GJDJ00,'' JCGJJE,'' GJSLJE,'' GJFCJE,'' SLDJ00,'' FCDJ00,'' JCDJ00,'' JCGJDJ,'' DJH000,'' ZY0000, '' SFSH00,'' SLGJDJ,'' FCGJDJ,'' JZXZ00, (select y.ghdwmc from bm_yd0000 x ,BM_YPGHDW y where x.ghdwnm=y.ghdwnm and x.ypnm00=a.ypnm00) ghdwmc, (SELECT R.SCCJZW FROM YK_YPRKMX R WHERE R.YPRKPC=b.YPRKPC) SCCJZW, (select zbqmc0 from bm_yd0000 where ypnm00=a.ypnm00) zbqmc0, (select zbxh00 from bm_yd0000 where ypnm00=a.ypnm00) zbxh00, b.ypsxrq,b.pzwh00,b.scph00, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(b.RCLXMC,'退货',(SELECT d.FPH000 FROM YK_YPQLMX d,YK_YPCKMX e where b.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=b.YPCKPC and b.YPNM00=d.YPNM00),(select c.FPH000 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) ,(select c.FPH000 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) RKFPH0, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(b.RCLXMC,'退货',(SELECT d.FPRQ00 FROM YK_YPQLMX d,YK_YPCKMX e where b.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=b.YPCKPC and b.YPNM00=d.YPNM00),(select c.FPRQ00 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) ,(select c.FPRQ00 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) RKFPRQ, '' JZSJ00 from (select a.YPNM00,count(*) JLS000,MAX(a.MXZLSH) MXZLSH from YK_YPMXZ0 a,BM_YD0000 b,BM_CJYLBM c where a.YKBMBH+0=:1 and a.JZRQ00>=:2 and a.JZRQ00<=:3 and a.JZRQ00||a.JZSJ00>=:4 and a.JZRQ00||a.JZSJ00<=:5 and (a.SFSH00<>'J' or ( (select nvl(trim(max(VALUE0)),'N') from XT_XTCS00 where NAME00='YK_YPZYSFDYNCQS')='Y' and a.ZY0000 like '初期数%' and a.SFSH00 = 'J')) and a.YPNM00=b.YPNM00 and (a.YPNM00=:6 or :7 =-1) and b.LBBH00 like :8 and b.YLBH00 like :9 and b.JXBH00 like :10 and b.CYLLSH=C.LSH000(+) and (c.CJYLBH LIKE :11 or :12 ='-1') and ( ( :13 ='0' and b.TZRQ00 is null ) OR ( :14 ='1' and b.TZRQ00 is not null) or (:15 = '-1')) group by a.YPNM00)a,YK_YPMXZ0 b where a.MXZLSH=b.MXZLSH union all select a.MXZLSH,a.YPNM00,a.JZRQ00,a.YPMC00,a.YPGG00,a.RCLXMC,DECODE(a.JZXZ00,'R',trim(replace(to_char(a.SLSL00,'FM9999990.009')||' ','. ','')),NULL) SLSL00, DECODE(a.JZXZ00,'R',trim(replace(to_char(a.SLJE00,'FM9999990.00')||' ','. ','')),NULL) SLJE00,a.JZDW00,DECODE(a.JZXZ00,'C',trim(replace(to_char(a.FCSL00,'FM9999990.009')||' ','. ','')),NULL) FCSL00 , DECODE(a.JZXZ00,'C',trim(replace(to_char(a.FCJE00,'FM9999990.00')||' ','. ','')),NULL) FCJE00,trim(replace(to_char(a.JCSL00,'FM9999990.009')||' ','. ','')) JCSL00, trim(replace(to_char(a.JCJE00,'FM9999990.00')||' ','. ','')) JCJE00 ,'1' JB0000, trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')) GJDJ00,trim(replace(to_char(JCGJJE,'FM9999990.00')||' ','. ','')) JCGJJE, DECODE(a.JZXZ00,'R',trim(replace(to_char(GJSLJE,'FM9999990.00')||' ','. ','')),NULL) GJSLJE, DECODE(a.JZXZ00,'C',trim(replace(to_char(GJFCJE,'FM9999990.00')||' ','. ','')),NULL) GJFCJE, DECODE(a.JZXZ00,'R',trim(replace(to_char(SLDJ00,'FM9999990.0099')||' ','. ','')),NULL) SLDJ00, DECODE(a.JZXZ00,'C',trim(replace(to_char(FCDJ00,'FM9999990.0099')||' ','. ','')),NULL) FCDJ00, trim(replace(to_char(JCDJ00,'FM9999990.0099')||' ','. ','')) JCDJ00, trim(replace(to_char(JCGJDJ,'FM9999990.0099')||' ','. ','')) JCGJDJ,a.DJH000,a.ZY0000,a.SFSH00, DECODE(a.JZXZ00,'C',trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')),NULL) AS FCGJDJ, DECODE(a.JZXZ00,'R',trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')),NULL) AS SLGJDJ, a.JZXZ00, (select ghdwmc from BM_YPGHDW where ghdwnm=b.ghdwnm) ghdwmc, (SELECT R.SCCJZW FROM YK_YPRKMX R WHERE R.YPRKPC=a.YPRKPC) SCCJZW, b.zbqmc0, b.zbxh00,a.ypsxrq,a.pzwh00,a.scph00, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(a.RCLXMC,'退货',(SELECT d.FPH000 FROM YK_YPQLMX d,YK_YPCKMX e where a.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=a.YPCKPC and a.YPNM00=d.YPNM00),(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) ,(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) RKFPH0, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(a.RCLXMC,'退货',(SELECT d.FPRQ00 FROM YK_YPQLMX d,YK_YPCKMX e where a.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=a.YPCKPC and a.YPNM00=d.YPNM00),(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) ,(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) RKFPRQ, a.JZSJ00 from YK_YPMXZ0 a,BM_YD0000 b,BM_CJYLBM c where a.YKBMBH+0=:16 and a.JZRQ00>=:17 and a.JZRQ00<=:18 and a.JZRQ00||a.JZSJ00>=:19 and a.JZRQ00||a.JZSJ00<=:20 and (a.SFSH00<>'J' or ( (select nvl(trim(max(VALUE0)),'N') from XT_XTCS00 where NAME00='YK_YPZYSFDYNCQS')='Y' and a.ZY0000 like '初期数%' and a.SFSH00 = 'J')) and a.YPNM00=b.YPNM00 and (a.YPNM00=:21 or :22 =-1) and b.LBBH00 like :23 and b.YLBH00 like :24 and b.JXBH00 like :25 and b.CYLLSH=C.LSH000(+) and (c.CJYLBH LIKE :26 or :27 ='-1') and ( ( :28 ='0' and b.TZRQ00 is null ) OR ( :29 ='1' and b.TZRQ00 is not null) or (:30 = '-1') ) ) x order by YPBM00,x.JB0000,X.JZRQ00||JZSJ00,x.MXZLSH 2 17:54:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168.000000 3 17:54:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112 4 17:54:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112 5 17:54:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011200:00:00 6 17:54:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011223:59:59 7 17:54:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 8 17:54:05 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 9 17:54:05 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 0% 10 17:54:05 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 11 17:54:05 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 12 17:54:05 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 13 17:54:05 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 14 17:54:05 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 17:54:05 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 16 17:54:05 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 17 17:54:05 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168.000000 18 17:54:05 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112 19 17:54:05 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240112 20 17:54:05 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011200:00:00 21 17:54:05 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024011223:59:59 22 17:54:05 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 23 17:54:05 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 24 17:54:05 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 0% 25 17:54:05 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 26 17:54:05 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 27 17:54:05 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 28 17:54:05 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 29 17:54:05 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 17:54:05 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 31 17:54:05 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 32 17:54:05 SQL Execute: ORACLE - select JZRQ00,RCLXMC,YPMC00,YPGG00,SLGJDJ,SLSL00,GJSLJE, SLDJ00,FCGJDJ,SLJE00,FCDJ00, FCJE00,GJFCJE,FCSL00,JCDJ00, JCGJDJ,JCSL00,JCJE00,JCGJJE, JZDW00,DJH000,ZY0000,SFSH00,JZXZ00,JB0000,ghdwmc,SCCJZW,zbqmc0, zbxh00,ypsxrq,pzwh00,scph00,RKFPH0,RKFPRQ, (select ypbm00 from bm_yd0000 where ypnm00=x.ypnm00) ypbm00 from ( select a.MXZLSH,a.YPNM00,to_char(JLS000)||'条账目' JZRQ00,'到截止日期库存量:' ||trim(replace(to_char(b.JCSL00,'FM9999990.009')||' ','. ','')) YPMC00, '金额:'||trim(replace(to_char(b.JCJE00,'FM9999990.00')||' ','. ','')) YPGG00, ' 结余：' RCLXMC,'' SLSL00,'' SLJE00,'' JZDW00,'' FCSL00,'' FCJE00,'' JCSL00 ,'' JCJE00,'2' JB0000, '' GJDJ00,'' JCGJJE,'' GJSLJE,'' GJFCJE,'' SLDJ00,'' FCDJ00,'' JCDJ00,'' JCGJDJ,'' DJH000,'' ZY0000, '' SFSH00,'' SLGJDJ,'' FCGJDJ,'' JZXZ00, (select y.ghdwmc from bm_yd0000 x ,BM_YPGHDW y where x.ghdwnm=y.ghdwnm and x.ypnm00=a.ypnm00) ghdwmc, (SELECT R.SCCJZW FROM YK_YPRKMX R WHERE R.YPRKPC=b.YPRKPC) SCCJZW, (select zbqmc0 from bm_yd0000 where ypnm00=a.ypnm00) zbqmc0, (select zbxh00 from bm_yd0000 where ypnm00=a.ypnm00) zbxh00, b.ypsxrq,b.pzwh00,b.scph00, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(b.RCLXMC,'退货',(SELECT d.FPH000 FROM YK_YPQLMX d,YK_YPCKMX e where b.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=b.YPCKPC and b.YPNM00=d.YPNM00),(select c.FPH000 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) ,(select c.FPH000 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) RKFPH0, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(b.RCLXMC,'退货',(SELECT d.FPRQ00 FROM YK_YPQLMX d,YK_YPCKMX e where b.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=b.YPCKPC and b.YPNM00=d.YPNM00),(select c.FPRQ00 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) ,(select c.FPRQ00 from YK_YPRKMX c where b.YPRKPC=c.YPRKPC)) RKFPRQ, '' JZSJ00 from (select a.YPNM00,count(*) JLS000,MAX(a.MXZLSH) MXZLSH from YK_YPMXZ0 a,BM_YD0000 b,BM_CJYLBM c where a.YKBMBH+0=? and a.JZRQ00>=? and a.JZRQ00<=? and a.JZRQ00||a.JZSJ00>=? and a.JZRQ00||a.JZSJ00<=? and (a.SFSH00<>'J' or ( (select nvl(trim(max(VALUE0)),'N') from XT_XTCS00 where NAME00='YK_YPZYSFDYNCQS')='Y' and a.ZY0000 like '初期数%' and a.SFSH00 = 'J')) and a.YPNM00=b.YPNM00 and (a.YPNM00=? or ? =-1) and b.LBBH00 like ? and b.YLBH00 like ? and b.JXBH00 like ? and b.CYLLSH=C.LSH000(+) and (c.CJYLBH LIKE ? or ? ='-1') and ( ( ? ='0' and b.TZRQ00 is null ) OR ( ? ='1' and b.TZRQ00 is not null) or (? = '-1')) group by a.YPNM00)a,YK_YPMXZ0 b where a.MXZLSH=b.MXZLSH union all select a.MXZLSH,a.YPNM00,a.JZRQ00,a.YPMC00,a.YPGG00,a.RCLXMC,DECODE(a.JZXZ00,'R',trim(replace(to_char(a.SLSL00,'FM9999990.009')||' ','. ','')),NULL) SLSL00, DECODE(a.JZXZ00,'R',trim(replace(to_char(a.SLJE00,'FM9999990.00')||' ','. ','')),NULL) SLJE00,a.JZDW00,DECODE(a.JZXZ00,'C',trim(replace(to_char(a.FCSL00,'FM9999990.009')||' ','. ','')),NULL) FCSL00 , DECODE(a.JZXZ00,'C',trim(replace(to_char(a.FCJE00,'FM9999990.00')||' ','. ','')),NULL) FCJE00,trim(replace(to_char(a.JCSL00,'FM9999990.009')||' ','. ','')) JCSL00, trim(replace(to_char(a.JCJE00,'FM9999990.00')||' ','. ','')) JCJE00 ,'1' JB0000, trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')) GJDJ00,trim(replace(to_char(JCGJJE,'FM9999990.00')||' ','. ','')) JCGJJE, DECODE(a.JZXZ00,'R',trim(replace(to_char(GJSLJE,'FM9999990.00')||' ','. ','')),NULL) GJSLJE, DECODE(a.JZXZ00,'C',trim(replace(to_char(GJFCJE,'FM9999990.00')||' ','. ','')),NULL) GJFCJE, DECODE(a.JZXZ00,'R',trim(replace(to_char(SLDJ00,'FM9999990.0099')||' ','. ','')),NULL) SLDJ00, DECODE(a.JZXZ00,'C',trim(replace(to_char(FCDJ00,'FM9999990.0099')||' ','. ','')),NULL) FCDJ00, trim(replace(to_char(JCDJ00,'FM9999990.0099')||' ','. ','')) JCDJ00, trim(replace(to_char(JCGJDJ,'FM9999990.0099')||' ','. ','')) JCGJDJ,a.DJH000,a.ZY0000,a.SFSH00, DECODE(a.JZXZ00,'C',trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')),NULL) AS FCGJDJ, DECODE(a.JZXZ00,'R',trim(replace(to_char(a.GJDJ00,'FM9999990.0099')||' ','. ','')),NULL) AS SLGJDJ, a.JZXZ00, (select ghdwmc from BM_YPGHDW where ghdwnm=b.ghdwnm) ghdwmc, (SELECT R.SCCJZW FROM YK_YPRKMX R WHERE R.YPRKPC=a.YPRKPC) SCCJZW, b.zbqmc0, b.zbxh00,a.ypsxrq,a.pzwh00,a.scph00, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(a.RCLXMC,'退货',(SELECT d.FPH000 FROM YK_YPQLMX d,YK_YPCKMX e where a.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=a.YPCKPC and a.YPNM00=d.YPNM00),(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) ,(select c.FPH000 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) RKFPH0, decode((select trim(VALUE0) from XT_XTCS00 where NAME00='YK_YYGXH' ),'4', decode(a.RCLXMC,'退货',(SELECT d.FPRQ00 FROM YK_YPQLMX d,YK_YPCKMX e where a.DJH000=d.YPQLDH and e.YPQLDH=d.YPQLDH and e.YPQLPC=d.YPQLPC and e.YPCKPC=a.YPCKPC and a.YPNM00=d.YPNM00),(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) ,(select c.FPRQ00 from YK_YPRKMX c where a.YPRKPC=c.YPRKPC)) RKFPRQ, a.JZSJ00 from YK_YPMXZ0 a,BM_YD0000 b,BM_CJYLBM c where a.YKBMBH+0=? and a.JZRQ00>=? and a.JZRQ00<=? and a.JZRQ00||a.JZSJ00>=? and a.JZRQ00||a.JZSJ00<=? and (a.SFSH00<>'J' or ( (select nvl(trim(max(VALUE0)),'N') from XT_XTCS00 where NAME00='YK_YPZYSFDYNCQS')='Y' and a.ZY0000 like '初期数%' and a.SFSH00 = 'J')) and a.YPNM00=b.YPNM00 and (a.YPNM00=? or ? =-1) and b.LBBH00 like ? and b.YLBH00 like ? and b.JXBH00 like ? and b.CYLLSH=C.LSH000(+) and (c.CJYLBH LIKE ? or ? ='-1') and ( ( ? ='0' and b.TZRQ00 is null ) OR ( ? ='1' and b.TZRQ00 is not null) or (? = '-1') ) ) x order by YPBM00,x.JB0000,X.JZRQ00||JZSJ00,x.MXZLSH