1 11:04:03 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 2 11:04:03 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 3 11:04:03 SQL Execute: ORACLE - Select * From BM_YPYL00 where LBBH00 like '0%' order by LBBH00,YLBH00 4 11:04:03 SQL Execute: ORACLE - Select * From BM_YPYL00 where LBBH00 LIKE '0%' order BY LBBH00,YLBH00 5 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='01' ORDER BY LSH000 6 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='02' ORDER BY LSH000 7 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='03' ORDER BY LSH000 8 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='04' ORDER BY LSH000 9 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='05' ORDER BY LSH000 10 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='06' ORDER BY LSH000 11 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='07' ORDER BY LSH000 12 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='08' ORDER BY LSH000 13 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='09' ORDER BY LSH000 14 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='10' ORDER BY LSH000 15 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='11' ORDER BY LSH000 16 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='12' ORDER BY LSH000 17 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='13' ORDER BY LSH000 18 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='14' ORDER BY LSH000 19 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='15' ORDER BY LSH000 20 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='16' ORDER BY LSH000 21 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='17' ORDER BY LSH000 22 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='18' ORDER BY LSH000 23 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='19' ORDER BY LSH000 24 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='20' ORDER BY LSH000 25 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='21' ORDER BY LSH000 26 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='22' ORDER BY LSH000 27 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='23' ORDER BY LSH000 28 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='24' ORDER BY LSH000 29 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='25' ORDER BY LSH000 30 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='26' ORDER BY LSH000 31 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='28' ORDER BY LSH000 32 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='29' ORDER BY LSH000 33 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='30' ORDER BY LSH000 34 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='31' ORDER BY LSH000 35 11:04:03 SQL Execute: ORACLE - Select * From BM_CJYLBM where LBBH00='0' and YLBH00='32' ORDER BY LSH000 36 11:04:03 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00 like '%0%' 37 11:04:03 SQL Execute: ORACLE - Select QZFSID,QZFSMC from BQ_YPQZFS 38 11:04:03 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=1913) and (BMBH00=0 or BMBH00=522) and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' order by YGBH00 39 11:04:03 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=1913 and (BMBH00=0 or BMBH00=522) and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh1' order by LS0000 40 11:04:03 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=1913 and (BMBH00=0 or BMBH00=522) and DLXTMC='药库管理系统' and CTMC00='frmYK_YDWH' and DBGRIN='DBGridEh2' order by LS0000 41 11:04:04 SQL Execute: ORACLE - select distinct MC0000,BH0000 from BM_TYZD00 where ZDMC00='药品性质' order by BH0000 42 11:04:04 SQL Execute: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP, MZFPMC,ZFBL00,YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM , (SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL, (SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX, substr(SF_YK_GetYBYLMC(C.YBYLID),1,120) YBYLMC, 0 YBYLXG ,substr(SF_YK_GetLJYPFL(C.YPNM00),1,120) LJYPFL FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW,substr(SF_YK_GetYBYLID(a.YPNM00),1,100) YBYLID from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+) and A.LBBH00 like '0%' and A.YLBH00 like '%' and A.JXBH00 like '%' and A.YKBMBH=522 and A.TZRQ00 IS NULL ) C, (select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00, DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB, DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM from VW_BM_YBSFDYYPMCFP where 1=1 and FBBH00='0' and YBZXLB='' and SFYBXM like '%' AND TZBZ00 like '%' ) B where C.YPNM00=B.SFXMID(+) order by C.YPBM00 43 11:04:04 SQL Data In: ORACLE - Rows affected = 0