1 04:46:32 SQL Execute: ORACLE - select ZDMC00 from YS_BRZDXX where GHH000 = '948014' 2 04:46:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4957268 3 04:46:33 SQL Execute: ORACLE - SELECT SL0000,XMZT00,YJKSBH,ZXSL00,CXSL00,(select LBBH00 from BM_ZLZD00 where ZLXMID=a.ZLXMID) as LBBH00 FROM YJ_YW0000 a WHERE YJDJH0=? 4 04:46:33 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4957268.000000 5 04:46:33 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 04:46:33 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 7 04:46:33 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 8 04:46:33 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 9 04:46:33 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2305.000000 10 04:46:33 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 11 04:46:33 SQL Data In: ORACLE - Param = 8, Name = PSFXKCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 12 04:46:33 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ0 => :PZXMBZ0,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT,PSFXKCS => :PSFXKCS); END; 13 04:46:34 SQL Execute: ORACLE - Commit 14 04:46:34 SQL Data In: ORACLE - Rows affected = 0 15 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 948014 16 04:46:42 SQL Execute: ORACLE - select count(1) from WZ_GZBHMX where SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=? and MZZYBZ='1') and rownum=1 17 04:46:42 SQL Execute: ORACLE - select rownum XH0000, b.* from (select a.*,SF_SS_GETWSFSL(a.SSDH00,0,0) WSFSL0 from VW_SS_SSFYLB a where YYSSRQ >='20230117' and YYSSRQ<='20230117' and nvl(SSMZKS,'2240')='2240' order by WSFSL0 desc,SQKS00,XM0000 asc,YYSSRQ desc) b 18 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 948014 19 04:46:42 SQL Execute: ORACLE - select count(1) from WZ_GZBHMX where SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=? and MZZYBZ='1') and rownum=1 20 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 948014 21 04:46:42 SQL Execute: ORACLE - select count(1) from WZ_GZBHMX where SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=? and MZZYBZ='1') and rownum=1 22 04:46:42 SQL Execute: ORACLE - select BMBH00,BMMC00 from vw_bm_ywks00 where bmxz00 in ('1','5') 23 04:46:42 SQL Execute: ORACLE - select * from ( select 1 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('3','2')) or (b.CXDJH0=c.YJDJH0)) union all select 0 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and b.YJDJH0=c.YJDJH0 and (not exists (select 'y' from yj_yw0000 a where a.BRID00=b.BRID00 and a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.XMZT00 in ('0','1') ) order by yjdjh0 24 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4957268 25 04:46:42 SQL Execute: ORACLE - select a.*,rownum NO0000 from (select '%s' as LB0000,decode(nvl(c.BZYPNM,0),0,b.SFXMMC,b.SFGZ00,(select YPMC00 from BM_YD0000 where YPNM00=c.YPNM00)) SFXMMC, decode(nvl(c.BZYPNM,0),0,b.JJJE00,c.LSDJ00) JJJE00,decode(nvl(c.BZYPNM,0),0,b.ZJE000,c.LSDJ00*c.XMSL00) ZJE000, (select GHDWMC from BM_YPGHDW where GHDWNM=C.GHDWNM) GHDWMC,nvl(decode(nvl(c.BZYPNM, 0), 0,null,(select YPGG00 from BM_YD0000 where YPNM00 = c.YPNM00)), (select ypgg00 from bm_wzqtxx a1,bm_yd0000 b1 where a1.ypnm00=b1.ypnm00 and a1.sfxmid=b.SFXMID and rownum = 1))WZGGXH, 0 BCCXSL,c.WZTXM0,c.PCTXM0,c.BZYPNM,c.YPNM00,D.HCDBBM,D.HCDBMC,D.YBZGZF,D.DW0000,b.YJDJH0,ZYHGHH,ZYGHID,KDYS00,KDYSXM,KDKSBH,KDRQ00, KDSJ00,LRXM00,XMZT00,CXDJH0,YJKSBH,brid00,mzzybz,zlxmjc,b.jzbz00,bwmc00,zdmc00,sl0000,zxsl00,SFDJH0,ZLXMID,DCBZ00,BRXM00,XB0000, YZCFID,MXID00,KDKSMC,SFXMID,SFXS00,SFCS00,CXSL00,GFJE00,JZJE00,ZFJE00,YBBZ00,SFXX00,SFSX00,ID0000,GJBM00,LSCL00,BH0000,SFLB00,CKMXID ,(select K.SJKCSL from VW_WZ_FJSFXM M,KS_YPKCXX K where M.SFXMID=B.SFXMID and M.YPNM00=K.YPNM00 and K.YFBMBH=2240 and rownum=1) SJKCSL,b.BKEH83,b.GJBZMC ,c.JJID00 from vw_ss_ywjj00 b,WZ_GZHCJJ c,BM_JJHCB0 D where b.YJDJH0 = ? and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 26 04:46:42 SQL Execute: ORACLE - select * from ( select b.* from VW_YJ_YW0000 b,SS_SSYJD0 c where c.SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=948014 and MZZYBZ='0' and SSZT00 in ('0','2','4','6')) and c.SSMZBZ='0' and b.YJKSBH='2240' and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('2','3')) or (b.CXDJH0=c.YJDJH0)) and b.ZXRQ00 is null ) order by YJDJH0 27 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 948014 28 04:46:42 SQL Execute: ORACLE - select count(1) from WZ_GZBHMX where SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=? and MZZYBZ='1') and rownum=1 29 04:46:42 SQL Execute: ORACLE - select BMBH00,BMMC00 from vw_bm_ywks00 where bmxz00 in ('1','5') 30 04:46:42 SQL Execute: ORACLE - select * from ( select 1 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('3','2')) or (b.CXDJH0=c.YJDJH0)) union all select 0 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and b.YJDJH0=c.YJDJH0 and (not exists (select 'y' from yj_yw0000 a where a.BRID00=b.BRID00 and a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.XMZT00 in ('0','1') ) order by yjdjh0 31 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4957268 32 04:46:42 SQL Execute: ORACLE - select a.*,rownum NO0000 from (select '%s' as LB0000,decode(nvl(c.BZYPNM,0),0,b.SFXMMC,b.SFGZ00,(select YPMC00 from BM_YD0000 where YPNM00=c.YPNM00)) SFXMMC, decode(nvl(c.BZYPNM,0),0,b.JJJE00,c.LSDJ00) JJJE00,decode(nvl(c.BZYPNM,0),0,b.ZJE000,c.LSDJ00*c.XMSL00) ZJE000, (select GHDWMC from BM_YPGHDW where GHDWNM=C.GHDWNM) GHDWMC,nvl(decode(nvl(c.BZYPNM, 0), 0,null,(select YPGG00 from BM_YD0000 where YPNM00 = c.YPNM00)), (select ypgg00 from bm_wzqtxx a1,bm_yd0000 b1 where a1.ypnm00=b1.ypnm00 and a1.sfxmid=b.SFXMID and rownum = 1))WZGGXH, 0 BCCXSL,c.WZTXM0,c.PCTXM0,c.BZYPNM,c.YPNM00,D.HCDBBM,D.HCDBMC,D.YBZGZF,D.DW0000,b.YJDJH0,ZYHGHH,ZYGHID,KDYS00,KDYSXM,KDKSBH,KDRQ00, KDSJ00,LRXM00,XMZT00,CXDJH0,YJKSBH,brid00,mzzybz,zlxmjc,b.jzbz00,bwmc00,zdmc00,sl0000,zxsl00,SFDJH0,ZLXMID,DCBZ00,BRXM00,XB0000, YZCFID,MXID00,KDKSMC,SFXMID,SFXS00,SFCS00,CXSL00,GFJE00,JZJE00,ZFJE00,YBBZ00,SFXX00,SFSX00,ID0000,GJBM00,LSCL00,BH0000,SFLB00,CKMXID ,(select K.SJKCSL from VW_WZ_FJSFXM M,KS_YPKCXX K where M.SFXMID=B.SFXMID and M.YPNM00=K.YPNM00 and K.YFBMBH=2240 and rownum=1) SJKCSL,b.BKEH83,b.GJBZMC ,c.JJID00 from vw_ss_ywjj00 b,WZ_GZHCJJ c,BM_JJHCB0 D where b.YJDJH0 = ? and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 33 04:46:42 SQL Execute: ORACLE - select * from ( select b.* from VW_YJ_YW0000 b,SS_SSYJD0 c where c.SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=948014 and MZZYBZ='0' and SSZT00 in ('0','2','4','6')) and c.SSMZBZ='0' and b.YJKSBH='2240' and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('2','3')) or (b.CXDJH0=c.YJDJH0)) and b.ZXRQ00 is null ) order by YJDJH0 34 04:46:42 SQL Execute: ORACLE - select BMBH00,BMMC00 from vw_bm_ywks00 where bmxz00 in ('1','5') 35 04:46:42 SQL Execute: ORACLE - select * from ( select 1 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('3','2')) or (b.CXDJH0=c.YJDJH0)) union all select 0 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17116 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=948014 and b.YJDJH0=c.YJDJH0 and (not exists (select 'y' from yj_yw0000 a where a.BRID00=b.BRID00 and a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and b.XMZT00 in ('0','1') ) order by yjdjh0 36 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4957268 37 04:46:42 SQL Execute: ORACLE - select a.*,rownum NO0000 from (select '%s' as LB0000,decode(nvl(c.BZYPNM,0),0,b.SFXMMC,b.SFGZ00,(select YPMC00 from BM_YD0000 where YPNM00=c.YPNM00)) SFXMMC, decode(nvl(c.BZYPNM,0),0,b.JJJE00,c.LSDJ00) JJJE00,decode(nvl(c.BZYPNM,0),0,b.ZJE000,c.LSDJ00*c.XMSL00) ZJE000, (select GHDWMC from BM_YPGHDW where GHDWNM=C.GHDWNM) GHDWMC,nvl(decode(nvl(c.BZYPNM, 0), 0,null,(select YPGG00 from BM_YD0000 where YPNM00 = c.YPNM00)), (select ypgg00 from bm_wzqtxx a1,bm_yd0000 b1 where a1.ypnm00=b1.ypnm00 and a1.sfxmid=b.SFXMID and rownum = 1))WZGGXH, 0 BCCXSL,c.WZTXM0,c.PCTXM0,c.BZYPNM,c.YPNM00,D.HCDBBM,D.HCDBMC,D.YBZGZF,D.DW0000,b.YJDJH0,ZYHGHH,ZYGHID,KDYS00,KDYSXM,KDKSBH,KDRQ00, KDSJ00,LRXM00,XMZT00,CXDJH0,YJKSBH,brid00,mzzybz,zlxmjc,b.jzbz00,bwmc00,zdmc00,sl0000,zxsl00,SFDJH0,ZLXMID,DCBZ00,BRXM00,XB0000, YZCFID,MXID00,KDKSMC,SFXMID,SFXS00,SFCS00,CXSL00,GFJE00,JZJE00,ZFJE00,YBBZ00,SFXX00,SFSX00,ID0000,GJBM00,LSCL00,BH0000,SFLB00,CKMXID ,(select K.SJKCSL from VW_WZ_FJSFXM M,KS_YPKCXX K where M.SFXMID=B.SFXMID and M.YPNM00=K.YPNM00 and K.YFBMBH=2240 and rownum=1) SJKCSL,b.BKEH83,b.GJBZMC ,c.JJID00 from vw_ss_ywjj00 b,WZ_GZHCJJ c,BM_JJHCB0 D where b.YJDJH0 = ? and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 38 04:46:42 SQL Execute: ORACLE - select * from ( select b.* from VW_YJ_YW0000 b,SS_SSYJD0 c where c.SSDH00 in (select SSDH00 from SS_YW0000 where ZYGHID=948014 and MZZYBZ='0' and SSZT00 in ('0','2','4','6')) and c.SSMZBZ='0' and b.YJKSBH='2240' and b.ZYGHID=948014 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('2','3')) or (b.CXDJH0=c.YJDJH0)) and b.ZXRQ00 is null ) order by YJDJH0 39 04:46:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4957268 40 04:46:42 SQL Execute: ORACLE - select a.*,rownum NO0000 from (select '%s' as LB0000,decode(nvl(c.BZYPNM,0),0,b.SFXMMC,b.SFGZ00,(select YPMC00 from BM_YD0000 where YPNM00=c.YPNM00)) SFXMMC, decode(nvl(c.BZYPNM,0),0,b.JJJE00,c.LSDJ00) JJJE00,decode(nvl(c.BZYPNM,0),0,b.ZJE000,c.LSDJ00*c.XMSL00) ZJE000, (select GHDWMC from BM_YPGHDW where GHDWNM=C.GHDWNM) GHDWMC,nvl(decode(nvl(c.BZYPNM, 0), 0,null,(select YPGG00 from BM_YD0000 where YPNM00 = c.YPNM00)), (select ypgg00 from bm_wzqtxx a1,bm_yd0000 b1 where a1.ypnm00=b1.ypnm00 and a1.sfxmid=b.SFXMID and rownum = 1))WZGGXH, 0 BCCXSL,c.WZTXM0,c.PCTXM0,c.BZYPNM,c.YPNM00,D.HCDBBM,D.HCDBMC,D.YBZGZF,D.DW0000,b.YJDJH0,ZYHGHH,ZYGHID,KDYS00,KDYSXM,KDKSBH,KDRQ00, KDSJ00,LRXM00,XMZT00,CXDJH0,YJKSBH,brid00,mzzybz,zlxmjc,b.jzbz00,bwmc00,zdmc00,sl0000,zxsl00,SFDJH0,ZLXMID,DCBZ00,BRXM00,XB0000, YZCFID,MXID00,KDKSMC,SFXMID,SFXS00,SFCS00,CXSL00,GFJE00,JZJE00,ZFJE00,YBBZ00,SFXX00,SFSX00,ID0000,GJBM00,LSCL00,BH0000,SFLB00,CKMXID ,(select K.SJKCSL from VW_WZ_FJSFXM M,KS_YPKCXX K where M.SFXMID=B.SFXMID and M.YPNM00=K.YPNM00 and K.YFBMBH=2240 and rownum=1) SJKCSL,b.BKEH83,b.GJBZMC ,c.JJID00 from vw_ss_ywjj00 b,WZ_GZHCJJ c,BM_JJHCB0 D where b.YJDJH0 = ? and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a