1 17:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 947868 2 17:59:46 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 3 17:59:46 SQL Execute: ORACLE - select BMBH00,BMMC00 from vw_bm_ywks00 where bmxz00 in ('1','5') 4 17:59:46 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 5 17:59:46 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 947868 6 17:59:46 SQL Data In: ORACLE - Param = 3, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 7 17:59:46 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 8 17:59:46 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 9 17:59:46 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 17:59:46 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 17:59:46 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 17:59:46 SQL Data In: ORACLE - Param = 9, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 17:59:46 SQL Data In: ORACLE - Param = 10, Name = PKSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 17:59:46 SQL Data In: ORACLE - Param = 11, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 17:59:46 SQL Data In: ORACLE - Param = 12, Name = PNL0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 17:59:46 SQL Data In: ORACLE - Param = 13, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 17 17:59:46 SQL Data In: ORACLE - Param = 14, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 17:59:46 SQL Data In: ORACLE - Param = 15, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 17:59:46 SQL Data In: ORACLE - Param = 16, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 17:59:46 SQL Data In: ORACLE - Param = 17, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 17:59:46 SQL Data In: ORACLE - Param = 18, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 17:59:46 SQL Execute: ORACLE - BEGIN "SP_SS_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PMZZYBZ => :PMZZYBZ,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PKSMC00 => :PKSMC00,PKSBH00 => :PKSBH00,PCSRQ00 => :PCSRQ00,PNL0000 => :PNL0000,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PFBBH00 => :PFBBH00); END; 23 17:59:46 SQL Execute: ORACLE - select * from ( select 1 YSF000,b.* from VW_YJ_YW0000 b,ss_ssyjd0 c where c.SSDH00= 17112 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=947868 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= 17112 and c.SSMZBZ='0' and (b.YJKSBH='2240' or b.LBBH00=4) and b.ZYGHID=947868 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 17:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 17:59:46 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 17:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 27 17:59:46 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 28 17:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 29 17:59:46 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 30 17:59:46 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=947868 and MZZYBZ='0' and SSZT00 in ('0','2','4','6')) and c.SSMZBZ='0' and b.YJKSBH='2240' and b.ZYGHID=947868 and ((b.YJDJH0=c.YJDJH0 and b.XMZT00 in ('2','3')) or (b.CXDJH0=c.YJDJH0)) and b.ZXRQ00 is null ) order by YJDJH0