1 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '核酸开单参数设置' and BH0000 = 'YJ_HSKDYJZXJCSFZSJHM' 2 15:54:02 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 3 15:54:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 4 15:54:02 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 5 15:54:02 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 6 15:54:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 7 15:54:02 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 8 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 9 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 10 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 11 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 12 15:54:02 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 13 15:54:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 14 15:54:02 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 15 15:54:02 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 16 15:54:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 17 15:54:02 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 18 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 19 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 20 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 21 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 22 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医技项目推送通用接口字典' and BH0000 = 'LBBH00' 23 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医技项目推送通用接口字典' and BH0000 = 'BMBH00' 24 15:54:02 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 25 15:54:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 15:54:02 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 27 15:54:02 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 28 15:54:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 29 15:54:02 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 30 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 31 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 32 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 33 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 34 15:54:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10479388 35 15:54:02 SQL Execute: ORACLE - select nvl(sum(A.zfje00),0) from yj_ywjj00 A where A.yjdjh0=? and not exists ( select 1 from yj_yw0000 where zlxmid in (0) and yjdjh0=A.YJDJH0 ) 36 15:54:02 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 37 15:54:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 15:54:02 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 39 15:54:02 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 40 15:54:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 41 15:54:02 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 42 15:54:02 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 43 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 44 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 45 15:54:02 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 46 15:54:02 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 47 15:54:02 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10479388 48 15:54:02 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 22089 49 15:54:02 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 50 15:54:02 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 51 15:54:02 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 52 15:54:02 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2207 53 15:54:02 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 15:54:02 SQL Data In: ORACLE - Param = 8, Name = PSFXKCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 15:54:02 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ0 => :PZXMBZ0,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT,PSFXKCS => :PSFXKCS); END; 56 15:54:03 SQL Execute: ORACLE - select count(1) SL0000 from bm_tyzd00 where ZDMC00 = '检测登记项目' and BH0000 = '22089' 57 15:54:03 SQL Execute: ORACLE - select count(1) SL0000 from BM_JCDJ00 where MZZYBZ='0' and ZYGHID ='1814045' 58 15:54:03 SQL Execute: ORACLE - commit 59 15:54:03 SQL Data In: ORACLE - Rows affected = 0 60 15:54:41 SQL Execute: ORACLE - commit 61 15:54:41 SQL Data In: ORACLE - Rows affected = 0 62 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 12329 63 15:54:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2207 64 15:54:41 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? and (YJKSBH+0 = ? or (YJKSBH in (2301,2305) and a.SFQZX0 = 'Y' )) and (1=1 and (a.MZZYBZ = '0' or a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and ZYHGHH = '1814045' and KDRQ00 between '20240301' and '20240304' order by XMZT00,YJDJH0 Desc 65 15:54:41 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 66 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 67 15:54:41 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 68 15:54:41 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 69 15:54:41 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 70 15:54:41 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 71 15:54:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 72 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 73 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 74 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 75 15:54:41 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 76 15:54:41 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 77 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 78 15:54:41 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 79 15:54:41 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 80 15:54:41 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 81 15:54:41 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 82 15:54:41 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 83 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 84 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 85 15:54:41 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual 86 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 12329 87 15:54:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2207 88 15:54:41 SQL Execute: ORACLE - select 'N' NX,decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'是','否') as SFJSMC,a.* from VW_YJ_YW0000 a where 1=1 and BRID00 = ? and (YJKSBH+0 = ? or (YJKSBH in (2301,2305) and a.SFQZX0 = 'Y' )) and (1=1 and (a.MZZYBZ = '0' or a.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9') or XMZT00 in ('2') or XMZT00 in ('3','4') ) ) and nvl(a.CXDJH0,0) = 0 and a.SJSL00 > 0 and ZYHGHH = '1814045' and KDRQ00 between '20240301' and '20240304' order by XMZT00,YJDJH0 Desc 89 15:54:41 SQL Execute: ORACLE - select a.*,c.ZTM000,c.CTM000 from VW_YJ_YWJJ00 a,SS_GZHCJK c where a.ID0000 = c.JJID00(+) and a.YJDJH0 = 10479388 order by c.NBID00,a.ID0000 90 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 15:54:42 SQL Execute: ORACLE - select distinct B.CFID00, B.CFLSH0, nvl(B.ZB0000, F.CFID00) ZB0000, B.YPNM00, B.YPMC00, B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0, B.CFDW00, B.YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, B.CFDW00, B.PSLBID, (select PSMC00 from BM_PS0000 where PSID00 = B.PSLBID and rownum=1) PSMC00, 10479388 YJDJH0, (select YFLBID from BM_YPYF00 c where c.ypyfmc = b.ypyfmc and rownum = 1) YFLBID from MZ_DCXMGZ A, YS_CFMX00 F, YF_MZCFMX B where B.CFLSH0 = ? and B.CFID00 = F.CFID00 and ((to_number(A.LYXMID) = to_number(F.PSLBID) and A.CSLY00='1') or (to_number(A.LYXMID) = to_number(nvl(f.yfid00,f.zjyfid)) and A.CSLY00 = '0')) order by ZB0000 92 15:54:42 SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=12329 93 15:54:42 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(12329,'0',1814045) from dual 94 15:54:42 SQL Execute: ORACLE - select '12329' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13045910665' BRLXDH,'1814045' ZYHGHH, '陈惠金' BRXM00, '女' BRXB00, '61岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '12329') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='12329' ) JZFPBZ from dual 95 15:54:42 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '住院无陪护业务字典' and BH0000 = 'WithoutAccompanying_Open' 96 15:54:42 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','0','') as BRGMXX from dual 97 15:54:42 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','1','') as BRGMXX from dual 98 15:54:42 SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','12329','2','') as BRGMXX from dual