1 11:17:27 SQL Execute: ORACLE - select ZDMC00 from YS_BRZDXX where GHH000 = '948014' 2 11:17:27 SQL Execute: ORACLE - select a.LBMC00,b.GHLB00 from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 and b.GHH000='948014' 3 11:17:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='特定挂号类别项目' and BH0000='111' and MC0000='-1' 4 11:17:27 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 = -1 and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 5 11:17:27 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 = -1 and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 6 11:17:27 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 = -1 and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 7 11:17:27 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 = -1 and b.ID0000=c.JJID00(+) AND B.ID0000=D.JJID00(+) order by b.ID0000) a 8 11:17:27 SQL Execute: ORACLE - select * from SF_BRXXB0 where GHH000='948014' and THBZ00<>'0' 9 11:17:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2240 10 11:17:27 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(?) SFBZDJ from dual 11 11:17:27 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000='9999' 12 11:17:27 SQL Execute: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' AND SFYXSQ='Y' and zlxmbh Like '%' and QYRQ00 IS NOT NULL AND ((TZRQ00 IS NULL) OR (TZRQ00>TO_CHAR(SYSDATE,'YYYYMMDD'))) order by zlxmbh 13 11:17:27 SQL Execute: ORACLE - Select a.ZLXMID, a.LBBH00, a.ZLXMJC, a.ZLXMBH, a.PYSM00, a.WBSM00, a.DW0000, a.SFJE00, a.ZFBL00, a.LBBHMC as LBMC00, a.SFBZDJ,' ' as YDBZ00,a.BWMC00,a.BQZY00,' ' SCCJ00 from VW_YJ_YBFYYZ_DJBZ a where a.LBBZ00='1' and a.zlxmbh like '%' and ((fbbh00='1' and ybbrlb='0' and ybzxlb='0' and sfsfxm='Y') or (sfsfxm='N')) and SFBZDJ=1 and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh 14 11:17:34 SQL Execute: ORACLE - select a.gxid00,a.zlxmid,a.sfxmid,c.xmmc00,a.gdbz00,a.BQSFBZ,trim(substr(C.bz0000,1,200)) BZ0000,a.FJFYBZ,a.sfcs00,a.mxxmid,a.JSXZ00,C.GG0000,(select XMNH00 from BM_YYSFXM where SFXMID=a.SFXMID) XMNH00, C.SFJE00,A.GJBM00,a.TYBZ00,a.SFLB00,C.DW0000,c.BH0000,c.JSXMMC,(SELECT YPBM00 FROM (SELECT A.SFXMID,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID) D WHERE D.SFXMID = C.SFXMID) YPBM00 ,(SELECT DISTINCT YPMC00 FROM (SELECT A.SFXMID,B.YPMC00,MAX(B.YPBM00) YPBM00 FROM BM_WZQTXX A,BM_YD0000 B WHERE A.YPNM00 = B.YPNM00 GROUP BY A.SFXMID,B.YPMC00) D WHERE D.SFXMID = C.SFXMID) YPMC00,c.BKEH83,c.GJBZMC,b.LBBH00 from XT_ZLSFGX a,BM_ZLZD00 B,VW_BM_YYSFXM_DJBZ C where a.zlxmid=b.zlxmid and a.sfxmid=c.sfxmid and B.ZLXMID=17746 and c.SFBZDJ=1 order by xmmc00