1 10:36:52 Log started for: SQL Navigator for Oracle 2 10:37:00 Log started for: 检验信息系统 3 10:37:00 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','J',''||'+'||'检 验 管 理 系 统','131','3007' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@3305:DE728A1BDA8D0FA8F56D790B2A2726DB' from dual 4 10:37:00 SQL Data In: ORACLE - Rows affected = 1 5 10:37:00 SQL Execute: ORACLE - Commit 6 10:37:00 SQL Data In: ORACLE - Rows affected = 0 7 10:37:00 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:37:00 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 9 10:37:00 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3305' and CZBZ00 in ('1') 10 10:37:00 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 10:37:00 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.9','J',''||'+'||'检 验 管 理 系 统','139','4009' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@3305:FED610BB3DC837738C905406BE02AC32' from dual 12 10:37:00 SQL Data In: ORACLE - Rows affected = 1 13 10:37:00 SQL Execute: ORACLE - Commit 14 10:37:00 SQL Data In: ORACLE - Rows affected = 0 15 10:37:00 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 16 10:37:00 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3305' and CZBZ00 in ('1') 17 10:37:00 SQL Execute: ORACLE - Select SYSDATE from Dual 18 10:37:00 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 10:37:00 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 20 10:37:00 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 21 10:37:00 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 22 10:37:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 23 10:37:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'YB-MMRK' 24 10:37:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'YB-SBK' 25 10:37:00 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3305')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3305')) order by b.PLXH00,a.BH0000 26 10:37:00 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '3305'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3305')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3305') 27 10:37:00 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=336 28 10:37:00 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 10:37:00 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 10:37:00 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 10:37:00 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 32 10:37:00 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 33 10:37:01 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3666713,336,'DNZX小陈','J',nvl('20163537',' '),'192.168.9.9#139:4009@+检 验 管 理 系 统',52) 34 10:37:01 SQL Data In: ORACLE - Rows affected = 1 35 10:37:01 SQL Execute: ORACLE - Commit 36 10:37:01 SQL Data In: ORACLE - Rows affected = 0 37 10:37:01 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 52 38 10:37:01 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221094' 39 10:37:01 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 40 10:37:01 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.9' 41 10:37:01 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 42 10:37:01 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 52 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 43 10:37:01 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 44 10:37:01 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 45 10:37:02 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='336' and name00='SYSTEMSKIN' 46 10:37:02 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 47 10:37:02 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140716' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',52,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 48 10:37:02 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',52,' )>0 ) and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'J') 49 10:37:02 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 50 10:37:02 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 51 10:37:02 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='J') and YXQ000>='20140716' and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',52,' )>0 ) order by XH0000 52 10:37:03 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 53 10:37:03 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 54 10:37:03 SQL Execute: ORACLE - select sysdate from dual 55 10:37:03 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 336 56 10:37:03 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 57 10:37:03 SQL Execute: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 52 58 10:37:03 SQL Execute: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 59 10:37:03 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 60 10:37:03 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 61 10:37:03 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 336= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=336 and XTDM00='J'))) 62 10:37:03 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 63 10:37:03 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((336= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=336 and XTDM00='0 '))) 64 10:37:03 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 65 10:37:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 336= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=336 and XTDM00='+ '))) 66 10:37:07 SQL Execute: ORACLE - select MC0000,ID0000 from JY_DYFZB0 where LB0000='2' ORDER BY MC0000 67 10:37:07 SQL Execute: ORACLE - select MC0000,ID0000 from JY_DYFZB0 where LB0000='6' ORDER BY MC0000 68 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DH' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 69 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DH' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 70 10:37:07 SQL Execute: ORACLE - select bbid00,rownum||'|'||bbmc00 bbmc00 from BM_BBZD00 order by bbid00 71 10:37:07 SQL Execute: ORACLE - select ZYZBMC,ZYZBID from BM_JYZYZB where SYBZ00='Y' 72 10:37:07 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1'))ORDER BY YQDH00 73 10:37:07 SQL Execute: ORACLE - select VALUE0,DM0000 from XT_ZD0000 where YXBZ00='1' AND ZDBM00='BBZT00' ORDER BY DM0000 74 10:37:07 SQL Execute: ORACLE - select ZYZBID from bm_jyzyzb where zyzbid=(select ZYZBID from jy_jyyqzd WHERE yqdh00='XS') 75 10:37:07 SQL Execute: ORACLE - select BBID00 from JY_JYYQZD where YQDH00='XS' 76 10:37:07 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='XS' 77 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 78 10:37:07 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 79 10:37:07 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 80 10:37:07 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'XS' 81 10:37:07 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'XS%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 82 10:37:07 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 83 10:37:07 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 10:37:07 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 85 10:37:07 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='XS' 86 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 87 10:37:07 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'XS' 88 10:37:07 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 89 10:37:07 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 90 10:37:07 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 91 10:37:07 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 92 10:37:07 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 93 10:37:07 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 94 10:37:07 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 95 10:37:07 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 96 10:37:07 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='' and pyrq00='' 97 10:37:07 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='XS' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 98 10:37:07 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='XS' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XS') 99 10:37:07 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='XS' 100 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 101 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 102 10:37:07 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'XS%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 103 10:37:07 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 104 10:37:07 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 105 10:37:07 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 106 10:37:07 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='XS' 107 10:37:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 108 10:37:07 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='7' 109 10:37:12 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'XS' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 110 10:37:12 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 111 10:37:12 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 031407150221 112 10:37:12 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 113 10:37:12 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 114 10:37:12 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = XS0001 115 10:37:12 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 116 10:37:12 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 117 10:37:12 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 118 10:37:12 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 119 10:37:12 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 120 10:37:12 SQL Error: ORACLE - ORA-20001: 乙肝常规检查,已签收,请选择【TE|TECAN】！ ！* ORA-06512: 在 "SD_HOSPITAL.SP_JY_JYBBPY", line 296 ORA-06512: 在 line 1 121 10:37:12 SQL Error: ORACLE - Unmapped SQL Error Code: 20001 122 10:37:18 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='3' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 123 10:37:18 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CA' 124 10:37:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 125 10:37:18 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 126 10:37:18 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 127 10:37:18 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 128 10:37:18 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 129 10:37:18 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 10:37:18 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 10:37:18 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 132 10:37:18 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 133 10:37:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 134 10:37:18 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 135 10:37:18 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 136 10:37:18 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 137 10:37:18 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 138 10:37:18 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 139 10:37:18 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 140 10:37:18 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 141 10:37:18 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 142 10:37:18 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 143 10:37:18 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='' and pyrq00='' 144 10:37:18 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 145 10:37:18 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CA' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CA') 146 10:37:18 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CA' 147 10:37:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 148 10:37:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 149 10:37:18 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 150 10:37:18 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 151 10:37:18 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 152 10:37:18 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 153 10:37:18 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 154 10:37:18 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 155 10:37:21 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='TE' 156 10:37:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 157 10:37:21 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 158 10:37:21 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 159 10:37:21 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'TE' 160 10:37:21 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 161 10:37:21 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 162 10:37:21 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 163 10:37:21 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 164 10:37:21 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='TE' 165 10:37:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 166 10:37:21 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'TE' 167 10:37:21 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 168 10:37:21 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 169 10:37:21 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 170 10:37:21 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 171 10:37:21 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 172 10:37:21 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 173 10:37:21 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 174 10:37:21 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 175 10:37:21 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='' and pyrq00='' 176 10:37:21 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='TE' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 177 10:37:21 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='TE' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='TE') 178 10:37:21 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='TE' 179 10:37:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 180 10:37:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 181 10:37:21 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 182 10:37:21 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 183 10:37:21 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 184 10:37:21 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 185 10:37:21 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='TE' 186 10:37:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 187 10:37:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 188 10:37:23 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 189 10:37:23 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 031407150221 190 10:37:23 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 191 10:37:23 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 192 10:37:23 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 193 10:37:23 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 194 10:37:23 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 195 10:37:23 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 196 10:37:23 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 197 10:37:23 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 198 10:37:23 SQL Execute: ORACLE - COMMIT 199 10:37:23 SQL Data In: ORACLE - Rows affected = 0 200 10:37:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 201 10:37:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 202 10:37:23 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 203 10:37:23 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 204 10:37:23 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 205 10:37:23 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 206 10:37:23 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 207 10:37:23 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 208 10:37:23 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 209 10:37:23 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 210 10:37:23 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 211 10:37:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 212 10:37:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 213 10:37:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 214 10:37:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 215 10:37:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 216 10:37:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 217 10:37:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 218 10:37:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 219 10:37:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 220 10:37:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 221 10:37:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 222 10:37:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 223 10:37:23 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 224 10:37:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 225 10:37:23 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 226 10:37:23 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 227 10:37:23 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 228 10:37:23 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 229 10:37:23 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 230 10:37:23 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 231 10:37:23 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 232 10:37:23 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 233 10:37:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 234 10:37:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 235 10:37:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 236 10:37:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 237 10:37:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 238 10:37:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 239 10:37:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 240 10:37:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 241 10:37:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 242 10:37:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 243 10:37:23 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 244 10:37:23 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 245 10:37:23 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 246 10:37:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 247 10:37:30 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CA' 248 10:37:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 249 10:37:30 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 250 10:37:30 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 251 10:37:30 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 252 10:37:30 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 253 10:37:30 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 254 10:37:30 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 255 10:37:30 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 256 10:37:30 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 257 10:37:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 258 10:37:30 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 259 10:37:30 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 260 10:37:30 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 261 10:37:30 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 262 10:37:30 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 263 10:37:30 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 264 10:37:30 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 265 10:37:30 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 266 10:37:30 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 267 10:37:30 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 268 10:37:30 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 269 10:37:30 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CA' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CA') 270 10:37:30 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CA' 271 10:37:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 272 10:37:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 273 10:37:30 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 274 10:37:30 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 275 10:37:30 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 276 10:37:30 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 277 10:37:30 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 278 10:37:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 279 10:37:33 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 280 10:37:33 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 281 10:37:33 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 031407150221 282 10:37:33 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 283 10:37:33 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 284 10:37:33 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CA0001 285 10:37:33 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 286 10:37:33 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 287 10:37:33 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 288 10:37:33 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 289 10:37:33 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 290 10:37:33 SQL Error: ORACLE - ORA-20001: 乙肝常规检查,已排样,20140716,TE0001 ！！* ORA-06512: 在 "SD_HOSPITAL.SP_JY_JYBBPY", line 296 ORA-06512: 在 line 1 291 10:37:33 SQL Error: ORACLE - Unmapped SQL Error Code: 20001 292 10:37:38 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='TE' 293 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 294 10:37:38 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 295 10:37:38 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 296 10:37:38 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'TE' 297 10:37:38 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 298 10:37:38 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 299 10:37:38 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 300 10:37:38 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 301 10:37:38 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 302 10:37:38 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 303 10:37:38 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 304 10:37:38 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 305 10:37:38 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 306 10:37:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 307 10:37:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 308 10:37:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 309 10:37:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 310 10:37:38 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 311 10:37:38 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 312 10:37:38 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 313 10:37:38 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 314 10:37:38 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 315 10:37:38 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 316 10:37:38 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 317 10:37:38 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 318 10:37:38 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 319 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 320 10:37:38 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 321 10:37:38 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 322 10:37:38 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 323 10:37:38 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 324 10:37:38 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 325 10:37:38 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 326 10:37:38 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 327 10:37:38 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 328 10:37:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 329 10:37:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 330 10:37:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 331 10:37:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 332 10:37:38 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 333 10:37:38 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 334 10:37:38 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 335 10:37:38 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 336 10:37:38 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 337 10:37:38 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 338 10:37:38 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 339 10:37:38 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 340 10:37:38 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 341 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 342 10:37:38 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'TE' 343 10:37:38 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='TE0001' AND PYRQ00='20140716') d 344 10:37:38 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 345 10:37:38 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 346 10:37:38 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 347 10:37:38 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 348 10:37:38 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 349 10:37:38 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 350 10:37:38 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 351 10:37:38 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 352 10:37:38 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='TE' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 353 10:37:38 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='TE' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='TE') 354 10:37:38 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='TE' 355 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 356 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 357 10:37:38 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 358 10:37:38 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 359 10:37:38 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 360 10:37:38 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 361 10:37:38 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 362 10:37:38 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 363 10:37:38 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 364 10:37:38 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 365 10:37:38 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 366 10:37:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 367 10:37:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 368 10:37:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 369 10:37:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 370 10:37:38 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 371 10:37:38 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 372 10:37:38 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 373 10:37:38 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 374 10:37:38 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 375 10:37:38 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 376 10:37:38 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 377 10:37:38 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 378 10:37:38 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 379 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 380 10:37:38 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00='TE' and YQDH00||YBH000='TE0001' AND SFZY00 = 'Y' 381 10:37:38 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 382 10:37:38 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 383 10:37:38 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 384 10:37:38 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='TE0001' and PYRQ00='20140716' order by jyywid desc 385 10:37:38 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='TE' 386 10:37:38 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 387 10:37:38 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'TE0001' and PYRQ00 = '20140716') 388 10:37:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 389 10:37:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 390 10:37:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 391 10:37:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 392 10:37:38 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 393 10:37:38 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 394 10:37:38 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 395 10:37:38 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 396 10:37:38 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 397 10:37:38 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 398 10:37:38 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 399 10:37:38 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0001 400 10:37:38 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 401 10:37:38 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 402 10:37:40 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 403 10:37:40 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 404 10:37:40 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 031407150221 405 10:37:40 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 406 10:37:40 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 407 10:37:40 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0002 408 10:37:40 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 409 10:37:40 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 410 10:37:40 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 411 10:37:40 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 412 10:37:40 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 413 10:37:40 SQL Error: ORACLE - ORA-20005: 标本已排样,排样日期：20140716,样本号：TE0001* ORA-06512: 在 "SD_HOSPITAL.SP_JY_JYBBPY", line 304 ORA-06512: 在 line 1 414 10:37:40 SQL Error: ORACLE - Unmapped SQL Error Code: 20005 415 10:37:52 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1221' 416 10:37:52 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 417 10:37:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 418 10:37:52 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1221 ) Order By PYSM00) where Rownum<=99 419 10:37:54 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 420 10:37:54 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1221' 421 10:37:54 SQL Data In: ORACLE - Rows affected = 1 422 10:37:54 SQL Execute: ORACLE - commit 423 10:37:54 SQL Data In: ORACLE - Rows affected = 0 424 10:37:54 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1222' 425 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 426 10:37:54 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1222 ) Order By PYSM00) where Rownum<=99 427 10:37:55 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 428 10:37:55 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1222' 429 10:37:55 SQL Data In: ORACLE - Rows affected = 1 430 10:37:55 SQL Execute: ORACLE - commit 431 10:37:55 SQL Data In: ORACLE - Rows affected = 0 432 10:37:56 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1223' 433 10:37:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 434 10:37:56 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1223 ) Order By PYSM00) where Rownum<=99 435 10:37:57 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 436 10:37:57 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1223' 437 10:37:57 SQL Data In: ORACLE - Rows affected = 1 438 10:37:57 SQL Execute: ORACLE - commit 439 10:37:57 SQL Data In: ORACLE - Rows affected = 0 440 10:37:57 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1224' 441 10:37:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 442 10:37:57 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1224 ) Order By PYSM00) where Rownum<=99 443 10:37:58 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 444 10:37:58 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1224' 445 10:37:58 SQL Data In: ORACLE - Rows affected = 1 446 10:37:58 SQL Execute: ORACLE - commit 447 10:37:58 SQL Data In: ORACLE - Rows affected = 0 448 10:37:59 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1225' 449 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 450 10:37:59 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1225 ) Order By PYSM00) where Rownum<=99 451 10:38:00 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 452 10:38:00 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1225' 453 10:38:00 SQL Data In: ORACLE - Rows affected = 1 454 10:38:00 SQL Execute: ORACLE - commit 455 10:38:00 SQL Data In: ORACLE - Rows affected = 0 456 10:38:00 SQL Execute: ORACLE - select count(*) from VW_JY_LBJGMB where BGXMID='1226' 457 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 458 10:38:00 SQL Execute: ORACLE - Select * from (select MC0000,PYSM00,WBSM00,BGXMID from VW_JY_LBJGMB where (PYSM00 Like ?) and( BGXMID = 1226 ) Order By PYSM00) where Rownum<=99 459 10:38:04 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGSH' 460 10:38:04 SQL Execute: ORACLE - select count(*) from jy_yw0000 where ybh000='TE0001' and PYRQ00='20140716' and CZY000 = '336' 461 10:38:04 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='阴性',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '336',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='TE0001' and PYRQ00='20140716' and bgxmid='1226' 462 10:38:04 SQL Data In: ORACLE - Rows affected = 1 463 10:38:04 SQL Execute: ORACLE - commit 464 10:38:04 SQL Data In: ORACLE - Rows affected = 0 465 10:38:04 SQL Execute: ORACLE - delete JY_JYJG00_temp where YBH000='TE0001' and yqdh00 in (select yqdh00 from jy_jyyqzd where SCKJL0='1') and PYRQ00='20140716' and BGXMID in (0) 466 10:38:04 SQL Data In: ORACLE - Rows affected = 0 467 10:38:04 SQL Execute: ORACLE - update JY_YW0000 set bbid00='1' where YBH000='TE0001' and PYRQ00='20140716' 468 10:38:04 SQL Data In: ORACLE - Rows affected = 1 469 10:38:04 SQL Execute: ORACLE - update JY_YW0000 set JGZT00='6',DYBZ00='',JYJS00='',BGJYR0='336',CBGRQ0=TO_CHAR(SYSDATE,'YYYYMMDD'),CBGSJ0=TO_CHAR(SYSDATE,'HH24:MI:SS'),YXBZ00='N',BBSM00='', BBBZ00='', SFKY00='N' where YBH000='TE0001' and PYRQ00='20140716' 470 10:38:04 SQL Data In: ORACLE - Rows affected = 1 471 10:38:04 SQL Execute: ORACLE - select * from vw_jy_jyjg00 where YBH000='TE0001' and PYRQ00='20140716' and SFCJJZ='Y' 472 10:38:05 SQL Execute: ORACLE - Commit 473 10:38:05 SQL Data In: ORACLE - Rows affected = 0 474 10:38:05 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 475 10:38:05 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 476 10:38:05 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'TE%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 477 10:38:05 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 478 10:38:05 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 479 10:38:05 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 480 10:38:05 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='TE' 481 10:38:05 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 482 10:38:14 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'TE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 483 10:38:14 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 484 10:38:14 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 011407150219 485 10:38:14 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 486 10:38:14 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 487 10:38:14 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TE0002 488 10:38:14 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 489 10:38:14 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 490 10:38:14 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 491 10:38:14 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 492 10:38:14 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 493 10:38:14 SQL Error: ORACLE - ORA-20001: 红细胞沉降率,已签收,请选择【MO|Monitor】！ ！* ORA-06512: 在 "SD_HOSPITAL.SP_JY_JYBBPY", line 296 ORA-06512: 在 line 1 494 10:38:14 SQL Error: ORACLE - Unmapped SQL Error Code: 20001 495 10:38:19 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='4' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 496 10:38:19 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='DA' 497 10:38:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 498 10:38:19 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 499 10:38:19 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 500 10:38:19 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'DA' 501 10:38:19 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'DA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 502 10:38:19 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='') d 503 10:38:19 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 504 10:38:19 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 505 10:38:19 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 506 10:38:19 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 507 10:38:19 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 508 10:38:19 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 509 10:38:19 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 510 10:38:19 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 511 10:38:19 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 512 10:38:19 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 513 10:38:19 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='DA' 514 10:38:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 515 10:38:19 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'DA' 516 10:38:19 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 517 10:38:19 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 518 10:38:19 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 519 10:38:19 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 520 10:38:19 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 521 10:38:19 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 522 10:38:19 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 523 10:38:19 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 524 10:38:19 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 525 10:38:19 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='DA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 526 10:38:19 SQL Execute: ORACLE - select distinct zlxmid from jy_zlyqdy where yqdh00='DA' 527 10:38:19 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='DA' 528 10:38:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 529 10:38:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 530 10:38:19 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'DA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 531 10:38:19 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='') d 532 10:38:19 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 533 10:38:19 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 534 10:38:19 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 535 10:38:19 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 536 10:38:19 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 537 10:38:19 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 538 10:38:19 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 539 10:38:19 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 540 10:38:19 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 541 10:38:19 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 542 10:38:19 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='DA' 543 10:38:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 544 10:38:20 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='GS' 545 10:38:20 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'GS' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 546 10:38:20 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 547 10:38:20 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 548 10:38:20 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'GS' 549 10:38:20 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'GS%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 550 10:38:21 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 551 10:38:21 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 552 10:38:21 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 553 10:38:21 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='GS' 554 10:38:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'GS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 555 10:38:21 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'GS' 556 10:38:21 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 557 10:38:21 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 558 10:38:21 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 559 10:38:21 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 560 10:38:21 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 561 10:38:21 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 562 10:38:21 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 563 10:38:21 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 564 10:38:21 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 565 10:38:21 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='GS' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 566 10:38:21 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='GS' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='GS') 567 10:38:21 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='GS' 568 10:38:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'GS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 569 10:38:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'GS' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 570 10:38:21 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'GS%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 571 10:38:21 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 572 10:38:21 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 573 10:38:21 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 574 10:38:21 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='GS' 575 10:38:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'GS' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 576 10:38:24 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='3' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 577 10:38:24 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CA' 578 10:38:24 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 579 10:38:24 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 580 10:38:24 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 581 10:38:24 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 582 10:38:24 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 583 10:38:24 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 584 10:38:24 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 585 10:38:24 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 586 10:38:24 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 587 10:38:24 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 588 10:38:24 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 589 10:38:24 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 590 10:38:24 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 591 10:38:24 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 592 10:38:24 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 593 10:38:24 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 594 10:38:24 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 595 10:38:24 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 596 10:38:24 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 597 10:38:24 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 598 10:38:24 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 599 10:38:24 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CA' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CA') 600 10:38:24 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CA' 601 10:38:24 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 602 10:38:24 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 603 10:38:24 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 604 10:38:24 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 605 10:38:24 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 606 10:38:24 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 607 10:38:24 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 608 10:38:24 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 609 10:38:27 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='8' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 610 10:38:27 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CL' 611 10:38:27 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 612 10:38:27 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 613 10:38:27 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 614 10:38:27 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CL' 615 10:38:27 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CL%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 616 10:38:27 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 617 10:38:27 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 618 10:38:27 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 619 10:38:27 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CL' 620 10:38:27 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 621 10:38:27 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CL' 622 10:38:27 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 623 10:38:27 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 624 10:38:27 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 625 10:38:27 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 626 10:38:27 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 627 10:38:27 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 628 10:38:27 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 629 10:38:27 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 630 10:38:27 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 631 10:38:27 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CL' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 632 10:38:27 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CL' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CL') 633 10:38:27 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CL' 634 10:38:27 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 635 10:38:27 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 636 10:38:27 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CL%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 637 10:38:27 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 638 10:38:27 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 639 10:38:27 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 640 10:38:27 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CL' 641 10:38:27 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 642 10:38:29 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 643 10:38:29 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 644 10:38:29 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 011407150219 645 10:38:29 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 646 10:38:29 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 647 10:38:29 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CL0001 648 10:38:29 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 649 10:38:29 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 650 10:38:29 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 651 10:38:29 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 652 10:38:29 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 653 10:38:29 SQL Error: ORACLE - ORA-20001: 红细胞沉降率,已签收,请选择【MO|Monitor】！ ！* ORA-06512: 在 "SD_HOSPITAL.SP_JY_JYBBPY", line 296 ORA-06512: 在 line 1 654 10:38:29 SQL Error: ORACLE - Unmapped SQL Error Code: 20001 655 10:38:35 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='3' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 656 10:38:35 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CA' 657 10:38:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 658 10:38:35 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 659 10:38:35 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 660 10:38:35 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 661 10:38:35 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 662 10:38:35 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 663 10:38:35 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 664 10:38:35 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 665 10:38:35 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 666 10:38:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 667 10:38:35 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 668 10:38:35 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 669 10:38:35 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 670 10:38:35 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 671 10:38:35 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 672 10:38:35 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 673 10:38:35 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 674 10:38:35 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 675 10:38:35 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 676 10:38:35 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 677 10:38:35 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 678 10:38:35 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CA' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CA') 679 10:38:35 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CA' 680 10:38:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 681 10:38:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 682 10:38:35 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 683 10:38:35 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 684 10:38:35 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 685 10:38:35 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 686 10:38:35 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 687 10:38:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 688 10:38:37 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='3' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 689 10:38:37 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CA' 690 10:38:37 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 691 10:38:37 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 692 10:38:37 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 693 10:38:37 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 694 10:38:37 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 695 10:38:37 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 696 10:38:37 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 697 10:38:37 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 698 10:38:37 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 699 10:38:37 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 700 10:38:37 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CA' 701 10:38:37 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 702 10:38:37 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 703 10:38:37 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 704 10:38:37 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 705 10:38:37 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 706 10:38:37 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 707 10:38:37 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 708 10:38:37 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 709 10:38:37 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 710 10:38:37 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 711 10:38:37 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CA' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CA') 712 10:38:37 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CA' 713 10:38:37 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 714 10:38:37 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 715 10:38:37 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 716 10:38:37 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 717 10:38:37 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 718 10:38:37 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 719 10:38:37 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CA' 720 10:38:37 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 721 10:38:41 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='4' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 722 10:38:41 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='DA' 723 10:38:41 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 724 10:38:41 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 725 10:38:41 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 726 10:38:41 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'DA' 727 10:38:41 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'DA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 728 10:38:41 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='') d 729 10:38:41 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 730 10:38:41 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 731 10:38:41 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 732 10:38:41 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 733 10:38:41 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 734 10:38:41 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 735 10:38:41 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 736 10:38:41 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 737 10:38:41 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 738 10:38:41 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 739 10:38:41 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='DA' 740 10:38:41 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 741 10:38:41 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'DA' 742 10:38:41 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 743 10:38:41 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 744 10:38:41 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 745 10:38:41 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 746 10:38:41 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 747 10:38:41 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 748 10:38:41 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 749 10:38:41 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 750 10:38:41 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 751 10:38:41 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='DA' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 752 10:38:41 SQL Execute: ORACLE - select distinct zlxmid from jy_zlyqdy where yqdh00='DA' 753 10:38:41 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='DA' 754 10:38:41 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 755 10:38:41 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 756 10:38:41 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'DA%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 757 10:38:41 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='') d 758 10:38:41 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 759 10:38:41 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 760 10:38:41 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 761 10:38:41 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 762 10:38:41 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 763 10:38:41 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 764 10:38:41 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 765 10:38:41 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 766 10:38:41 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 767 10:38:41 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 768 10:38:41 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='DA' 769 10:38:41 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 770 10:38:45 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='10' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 771 10:38:45 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='MY' 772 10:38:45 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 773 10:38:45 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 774 10:38:45 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 775 10:38:45 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MY' 776 10:38:46 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MY%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 777 10:38:46 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 778 10:38:46 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 779 10:38:46 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 780 10:38:46 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MY' 781 10:38:46 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 782 10:38:46 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MY' 783 10:38:46 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 784 10:38:46 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 785 10:38:46 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 786 10:38:46 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 787 10:38:46 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 788 10:38:46 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 789 10:38:46 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 790 10:38:46 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 791 10:38:46 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 792 10:38:46 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='MY' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 793 10:38:46 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='MY' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='MY') 794 10:38:46 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='MY' 795 10:38:46 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 796 10:38:46 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 797 10:38:46 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MY%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 798 10:38:46 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 799 10:38:46 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 800 10:38:46 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 801 10:38:46 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MY' 802 10:38:46 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 803 10:38:48 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='MY' 804 10:38:48 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 805 10:38:48 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 806 10:38:48 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 807 10:38:48 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MY' 808 10:38:48 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MY%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 809 10:38:48 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 810 10:38:48 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 811 10:38:48 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 812 10:38:48 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MY' 813 10:38:48 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 814 10:38:48 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MY' 815 10:38:48 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 816 10:38:48 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 817 10:38:48 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 818 10:38:48 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 819 10:38:48 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 820 10:38:48 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 821 10:38:48 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 822 10:38:48 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 823 10:38:48 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 824 10:38:48 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='MY' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 825 10:38:48 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='MY' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='MY') 826 10:38:48 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='MY' 827 10:38:48 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 828 10:38:48 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 829 10:38:48 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MY%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 830 10:38:48 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 831 10:38:48 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 832 10:38:48 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 833 10:38:48 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MY' 834 10:38:48 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MY' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 835 10:38:51 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='2' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 836 10:38:51 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='B8' 837 10:38:51 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'B8' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 838 10:38:51 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 839 10:38:51 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 840 10:38:51 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'B8' 841 10:38:51 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'B8%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 842 10:38:51 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 843 10:38:51 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 844 10:38:51 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 845 10:38:51 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='B8' 846 10:38:51 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'B8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 847 10:38:51 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'B8' 848 10:38:51 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 849 10:38:51 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 850 10:38:51 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 851 10:38:51 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 852 10:38:51 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 853 10:38:51 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 854 10:38:51 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 855 10:38:51 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 856 10:38:51 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 857 10:38:51 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='B8' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 858 10:38:51 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='B8' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='B8') 859 10:38:51 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='B8' 860 10:38:51 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'B8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 861 10:38:51 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'B8' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 862 10:38:51 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'B8%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 863 10:38:51 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 864 10:38:51 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 865 10:38:51 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 866 10:38:51 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='B8' 867 10:38:51 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'B8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 868 10:38:58 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='8' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 869 10:38:58 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CL' 870 10:38:58 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 871 10:38:58 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 872 10:38:58 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 873 10:38:58 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CL' 874 10:38:58 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CL%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 875 10:38:58 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 876 10:38:58 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 877 10:38:58 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 878 10:38:58 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CL' 879 10:38:58 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 880 10:38:58 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CL' 881 10:38:58 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 882 10:38:58 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 883 10:38:58 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 884 10:38:58 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 885 10:38:58 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 886 10:38:58 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 887 10:38:58 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 888 10:38:58 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 889 10:38:58 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 890 10:38:58 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CL' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 891 10:38:58 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CL' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CL') 892 10:38:58 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CL' 893 10:38:58 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 894 10:38:58 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 895 10:38:58 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CL%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 896 10:38:58 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 897 10:38:58 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 898 10:38:58 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 899 10:38:58 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CL' 900 10:38:58 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CL' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 901 10:39:03 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and zyzbid='7' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='336' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1')) ORDER BY XSXH00 desc,YQDH00 902 10:39:03 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='CB' 903 10:39:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CB' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 904 10:39:03 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 905 10:39:03 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 906 10:39:03 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CB' 907 10:39:03 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CB%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 908 10:39:03 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 909 10:39:03 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 910 10:39:03 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 911 10:39:03 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CB' 912 10:39:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CB' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 913 10:39:03 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'CB' 914 10:39:03 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 915 10:39:03 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 916 10:39:03 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 917 10:39:03 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 918 10:39:03 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 919 10:39:03 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 920 10:39:03 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 921 10:39:03 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 922 10:39:03 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 923 10:39:03 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CB' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 924 10:39:03 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CB' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CB') 925 10:39:03 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CB' 926 10:39:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CB' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 927 10:39:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CB' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 928 10:39:03 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'CB%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 929 10:39:03 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 930 10:39:03 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 931 10:39:03 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 932 10:39:03 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='CB' 933 10:39:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'CB' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 934 10:39:07 SQL Execute: ORACLE - select JYXXYS from JY_JYYQZD where yqdh00='MO' 935 10:39:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'WSBBDR' 936 10:39:07 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 937 10:39:07 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 938 10:39:07 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MO' 939 10:39:07 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MO%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 940 10:39:07 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 941 10:39:07 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 942 10:39:07 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 943 10:39:07 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MO' 944 10:39:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 945 10:39:07 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00 like 'BICLIAISON%' and YQDH00 = 'MO' 946 10:39:07 SQL Execute: ORACLE - select (select scbgrq from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) scbgrq, (select SCXJJG from vw_jy_xjbgjg c where c.jyywid=d.jyywid and c.scbgrq is not null and rownum=1) SCXJJG , d.* from ( SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20140716') d 947 10:39:07 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 948 10:39:07 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 949 10:39:07 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 950 10:39:07 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 951 10:39:07 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 952 10:39:07 SQL Execute: ORACLE - select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0), 0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000 from VW_JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ) ORDER BY XH0000) JG 953 10:39:07 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0001,XH0000 954 10:39:07 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='TE0001' and pyrq00='20140716' 955 10:39:07 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='MO' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 956 10:39:07 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='MO' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='MO') 957 10:39:07 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='MO' 958 10:39:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 959 10:39:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 960 10:39:07 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ,'1','住','门') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00 from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00 from VW_JYYW_JYJG00_TEMP A where YBH000 LIKE 'MO%' and PYRQ00 between '20140716' and '20140716' and JGZT00||'A' in ('4A','5A') ) order by YBH000 961 10:39:07 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 962 10:39:07 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 963 10:39:07 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 964 10:39:07 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='MO' 965 10:39:07 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 966 10:39:09 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '336' and YQDH00 = 'MO' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 967 10:39:09 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 968 10:39:09 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 011407150219 969 10:39:09 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 970 10:39:09 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140716 971 10:39:09 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = MO0001 972 10:39:09 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 973 10:39:09 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 974 10:39:09 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 336 975 10:39:09 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 976 10:39:09 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 977 10:39:09 SQL Error: ORACLE - ORA-03113: 通信通道的文件结束