1 12:13:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
2 12:13:57 SQL Execute: ORACLE - select SFDTBY from YF_BYTJ00 where ID0000 =?
3 12:13:57 SQL Execute: ORACLE - select count(*) from YF_YZYPSQ where YPQLPC IN(46312863) and nvl(ZBYBZ0,'0')='0'
4 12:13:59 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_BQBYQY'
5 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL
6 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL
7 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'yyyymmdd') RQ0000,to_char(sysdate,'hh24:mi:ss') SJ0000 from dual
8 12:13:59 SQL Execute: ORACLE - Select SQ_YF_ZYFYJL_ID0000.NextVal Val from Dual
9 12:13:59 SQL Execute: ORACLE - INSERT INTO YF_ZYFYJL(ID0000,CKDH00,YZID00,YYRQ00,BQBMBH,CZY000,CZRQ00,CZSJ00,ZYID00,BZ0000,YPQLPC,DQKS00)
SELECT 270027,'0',a.YZID00,a.YYRQ00,a.BQBMBH,121,'20260302','12:13:58',a.ZYID00,b.RYCWH0||'床 '||b.XM0000 BZ0000,a.YPQLPC,a.DQKS00
FROM YF_YZYPSQ a,ZY_BRXXB0 b where a.YPQLPC IN(46312863) and a.ZYID00=b.ZYID00 and nvl(a.ZBYBZ0,'0')='0'
10 12:13:59 SQL Data In: ORACLE - Rows affected = 1
11 12:13:59 SQL Execute: ORACLE - commit
12 12:13:59 SQL Data In: ORACLE - Rows affected = 0
13 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
14 12:13:59 SQL Execute: ORACLE - select nvl(max(TJRXX0),'0') from YF_BYTJ00 where SFBZLC = '5' and ID0000=?
15 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL
16 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL
17 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
18 12:13:59 SQL Execute: ORACLE - select nvl(HFRXX0,'0') from YF_BYTJ00 where SFBZLC = '4' and ID0000=?
19 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL
20 12:13:59 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL
21 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
22 12:13:59 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=?
23 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
24 12:13:59 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=?
25 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
26 12:13:59 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=?
27 12:13:59 SQL Execute: ORACLE - select SF_YF_GETYZBQ(270027,121) BQBMBH from dual
28 12:13:59 SQL Execute: ORACLE - select SF_YK_GETLSH('YF_CKDH00') CKDH00 from dual
29 12:13:59 SQL Execute: ORACLE - update YF_ZYFYJL set CKDH00='1792519' where ID0000=270027 and CZY000=121 and BQBMBH=41
30 12:13:59 SQL Data In: ORACLE - Rows affected = 1
31 12:13:59 SQL Execute: ORACLE - Commit
32 12:13:59 SQL Data In: ORACLE - Rows affected = 0
33 12:13:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270027
34 12:13:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121
35 12:13:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 41
36 12:13:59 SQL Execute: ORACLE - select distinct ZYID00,BZ0000 from YF_ZYFYJL a where a.ID0000=? and a.CZY000=? and a.BQBMBH=?
37 12:13:59 SQL Data In: ORACLE - Param = 1, Name = PBCFYID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270027
38 12:13:59 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2082750
39 12:13:59 SQL Data In: ORACLE - Param = 3, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
40 12:13:59 SQL Data In: ORACLE - Param = 4, Name = PBQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000
41 12:13:59 SQL Data In: ORACLE - Param = 5, Name = PLYRBH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
42 12:13:59 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000
43 12:13:59 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
44 12:13:59 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
45 12:13:59 SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
46 12:13:59 SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
47 12:13:59 SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
48 12:13:59 SQL Data In: ORACLE - Param = 12, Name = PBYTJID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
49 12:13:59 SQL Data In: ORACLE - Param = 13, Name = PSFKSFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
50 12:13:59 SQL Execute: ORACLE - BEGIN "SP_YF_BQFY00" (PBCFYID => :PBCFYID,PZYID00 => :PZYID00,PYFBMBH => :PYFBMBH,PBQBMBH => :PBQBMBH,PLYRBH0 => :PLYRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PBYTJID => :PBYTJID,PSFKSFY => :PSFKSFY); END;
51 12:13:59 SQL Execute: ORACLE - rollback
52 12:13:59 SQL Data In: ORACLE - Rows affected = 0
53 12:13:59 SQL Execute: ORACLE - Update YF_ZYFYJL set FYSBYY='可用余额[-2913.83]不够，扣费金额[3.17]' where ID0000=270027 and CZY000=121 and BQBMBH=41 and ZYID00=2082750
54 12:13:59 SQL Data In: ORACLE - Rows affected = 1
55 12:13:59 SQL Execute: ORACLE - Commit
56 12:13:59 SQL Data In: ORACLE - Rows affected = 0
57 12:13:59 SQL Data In: ORACLE - Param = 1, Name = PBCFYID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270027
58 12:13:59 SQL Data In: ORACLE - Param = 2, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
59 12:13:59 SQL Data In: ORACLE - Param = 3, Name = PBQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000
60 12:13:59 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000
61 12:13:59 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
62 12:13:59 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
63 12:13:59 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
64 12:13:59 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
65 12:13:59 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
66 12:13:59 SQL Data In: ORACLE - Param = 10, Name = Pfyckbh, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 11
67 12:13:59 SQL Data In: ORACLE - Param = 11, Name = Ptjr000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
68 12:13:59 SQL Data In: ORACLE - Param = 12, Name = PSFKSFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
69 12:13:59 SQL Data In: ORACLE - Param = 13, Name = Pfhr000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
70 12:13:59 SQL Execute: ORACLE - BEGIN "SP_YF_BQFY00_CKQR" (PBCFYID => :PBCFYID,PYFBMBH => :PYFBMBH,PBQBMBH => :PBQBMBH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,Pfyckbh => :Pfyckbh,Ptjr000 => :Ptjr000,PSFKSFY => :PSFKSFY,Pfhr000 => :Pfhr000); END;
71 12:13:59 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_BQZYBYFPTS'
72 12:13:59 SQL Execute: ORACLE - SELECT count(1) FROM VW_YF_YZZSYP where SFCLYP = 'Y' and ZSMSL0 > SMSL00 and CKDH00 = '1792519'
73 12:13:59 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_BQBYQRFPZSM'
74 12:13:59 SQL Data In: ORACLE - Param = 1, Name = PCKDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1792519
75 12:13:59 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000
76 12:13:59 SQL Data In: ORACLE - Param = 3, Name = PSFTS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
77 12:13:59 SQL Data In: ORACLE - Param = 4, Name = POTHER0, Type = fldZSTRING, Precision = 36, Scale = 0, Data = 1Y
78 12:13:59 SQL Execute: ORACLE - BEGIN "SP_YF_ZYFYZDFPZSM" (PCKDH00 => :PCKDH00,PCZY000 => :PCZY000,PSFTS00 => :PSFTS00,POTHER0 => :POTHER0); END;
79 12:13:59 SQL Error: ORACLE - ORA-20002: ORA-01403: 未找到任何数据zsm000=YPQLPC=!*
ORA-06512: 在 "SD_HOSPITAL.SP_YF_ZYFYZDFPZSM", line 194
ORA-06512: 在 line 1
80 12:13:59 SQL Error: ORACLE - Unmapped SQL Error Code: 20002
81 12:14:02 SQL Execute: ORACLE - rollback
82 12:14:02 SQL Data In: ORACLE - Rows affected = 0
83 12:14:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
84 12:14:03 SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N'
or GLMC00 = '医嘱属性' and tjmc00<>'长期医嘱' )
85 12:14:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
86 12:14:03 SQL Execute: ORACLE - select count(1) NUM from YF_BYTJMX where bytjid=? and (tjmc00='非注射剂' or GLMC00='配送批次' and SFFZ00='N'
or GLMC00 = '医嘱属性' and tjmc00='长期医嘱' )
87 12:14:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
88 12:14:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000
89 12:14:03 SQL Execute: ORACLE - select count(distinct(ZYID00)) SL0000 from VW_YF_ZYBYXX a where a.YFBMBH=? and a.BQBMBH=? and (( (a.YFLBID<>0)) and ( Exists (select 1 from YF_YZYPSQ jj,BM_YD0000 kk where jj.ypqlpc=a.ypqlpc and jj.ypnm00=kk.ypnm00 and (( KK.DPDJ00='0' and KK.MZDJ00='0' and KK.SJDJ00='0' and KK.FSDJ00='0' )))) and ( (a.YZXZ00<>'3')) and ( (a.YZXZ00<>'1')) and ( (a.YZXZ00<>'2'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
and nvl(a.ZBYBZ0,'0')='0'
Order by a.CH0000,a.YYRQ00,a.yzid00,a.YZMXID
90 12:14:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270027
91 12:14:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000
92 12:14:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000
93 12:14:03 SQL Execute: ORACLE - select a.*,(select FYSBYY from yf_zyfyjl where ID0000=? and ZYID00=a.ZYID00 and YZID00=a.YZID00 and rownum=1) as FYSBYY,' ' as NEWPC0 from VW_YF_ZYBYXX a where a.YFBMBH=? and a.BQBMBH=? and (( (a.YFLBID<>0)) and ( Exists (select 1 from YF_YZYPSQ jj,BM_YD0000 kk where jj.ypqlpc=a.ypqlpc and jj.ypnm00=kk.ypnm00 and (( KK.DPDJ00='0' and KK.MZDJ00='0' and KK.SJDJ00='0' and KK.FSDJ00='0' )))) and ( (a.YZXZ00<>'3')) and ( (a.YZXZ00<>'1')) and ( (a.YZXZ00<>'2'))) and ( a.PSPC00 is null or a.PSPC00 is not null and a.YYRQ00>=to_char(sysdate,'YYYYMMDD') )
and a.ZBYBZ0='0'
Order by a.CH0000,a.YYRQ00,a.yzid00,a.YZMXID