1 08:41:16 SQL Execute: ORACLE - select a.PRBMBH, a.BMBH00, a.BH0000, a.BMMC00, a.BMXZ00, a.PYSM00, a.WBSM00 from VW_BM_BQKSDZ a connect by a.PRBMBH = Prior a.BMBH00 start with a.BMBH00 in (-1) order by a.PRBMBH,a.BH0000
2 08:41:16 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_PUB a where 1=1 and (a.BRZT00 >= '1' and a.BRZT00 <= '3') and Rownum <=999 order by DQBQ00,PXCWH0,ZYH000
3 08:41:18 SQL Execute: ORACLE - select BRID00 from VW_ZY_BRXXB0 where ZYID00 = 1152232.00
4 08:41:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
5 08:41:18 SQL Execute: ORACLE - select count(1) from zy_brxxb0 where zyid00=? and ffbzbm is not null
6 08:41:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
7 08:41:18 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
8 08:41:18 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
9 08:41:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
10 08:41:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
11 08:41:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
12 08:41:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
13 08:41:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
14 08:41:18 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
15 08:41:18 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 ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',487,')>0)) 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 KDRQ00 between '20240109' and '20240116' order by XMZT00,YJDJH0 Desc
16 08:41:18 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
17 08:41:20 SQL Execute: ORACLE - SELECT substr(BRZT00,1,1) as BRZT00 FROM ZY_BRXXB0 WHERE ZYID00= 1152232
18 08:41:20 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(487) as SFBZDJ from dual
19 08:41:20 SQL Execute: ORACLE - select dqks00,SXYS00,SXYSXM,b.bmmc00 from zy_brxxb0 a,bm_bmbm00 b where a.dqks00=b.bmbh00(+) and zyid00=1152232
20 08:41:20 SQL Execute: ORACLE - select yexm00 from bq_jsxx00 where zyid00=1152232
21 08:41:20 SQL Execute: ORACLE - select * from (select bqh000,bmmc00,max(qsrq00||qssj00) qsrqsj from bq_brldxx q,bm_bmbm00 m where zyid00= 1152232 and q.bqh000=m.bmbh00 group by bqh000,bmmc00) order by qsrqsj desc
22 08:41:20 SQL Execute: ORACLE - select sysdate from dual
23 08:41:20 SQL Execute: ORACLE - select * from vw_yj_yw0000_wzx b
where xmzt00 in('0','1') and brid00=4823337
and kdrq00 = '20240116'
and ((YJKSBH = 487) or (KDKSBH = 487) or (LRXM00 = '管理员'))
and YJLRBZ = 'Y'
and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh))
and ((cxdjh0 = 0) or (cxdjh0 is null))
order by YJDJH0 desc
24 08:41:21 SQL Execute: ORACLE - Select distinct zlxmbh,zlxmjc from BM_ZLZD00 where lbbz00='0' AND SFYXSQ='Y' and zlxmbh Like '%' and QYRQ00 IS NOT NULL AND ((TZRQ00 IS NULL) OR (TZRQ00>TO_CHAR(SYSDATE,'YYYYMMDD'))) order by zlxmbh
25 08:41:22 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
26 08:41:22 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000
27 08:41:22 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 42525335.000000
28 08:41:22 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
29 08:41:22 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1057 and CZXH00 = 42525335.00)
30 08:41:23 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%J%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='1' or MZZYBZ='2') and ((ybbrlb='9' and YBZXLB='2' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'0'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
31 08:41:25 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 17905 and a.SFBZDJ = 0 order by xmmc00
32 08:41:25 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%JM%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='1' or MZZYBZ='2') and ((ybbrlb='9' and YBZXLB='2' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'0'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
33 08:41:25 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 25472 and a.SFBZDJ = 0 order by xmmc00
34 08:41:25 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%JMZ%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='1' or MZZYBZ='2') and ((ybbrlb='9' and YBZXLB='2' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'0'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
35 08:41:25 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 17896 and a.SFBZDJ = 0 order by xmmc00
36 08:41:25 SQL Execute: ORACLE - select * from VW_YJ_YBFYYZ_DJBZ a where a.zlxmbh like '%'
and upper(a.PYSM00) like '%JMZS%'
and SFYXSQ='Y' and SFBZDJ='0' and (MZZYBZ='1' or MZZYBZ='2') and ((ybbrlb='9' and YBZXLB='2' and fbbh00='3' and sfsfxm='Y') or (sfsfxm='N')) and MZZYBZ<>'0'
and a.Zlxmid>=100 and rownum<=200 order by a.zlxmbh
37 08:41:26 SQL Execute: ORACLE - select a.*,c.lbbh00 from VW_BM_YYSFXM_DJBZ a,XT_ZLSFGX b,BM_ZLZD00 c where c.ZLXMID = b.ZLXMID and b.SFXMID = a.SFXMID and c.ZLXMID = 17916 and a.SFBZDJ = 0 order by xmmc00
38 08:41:27 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=17916 order by zxmbh0
39 08:41:27 SQL Execute: ORACLE - select * from BM_JYXMBB where ZLXMID=17916
40 08:41:31 SQL Execute: ORACLE - select a.GHQXBZ from bm_ghlbb0 a,SF_BRXXB0 b where a.LBBH00=b.GHLB00 AND b.GHH000='2311898'
41 08:41:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 呼吸与危重症医学科
42 08:41:31 SQL Execute: ORACLE - select BMBH00 from vw_yj_kdks00 where bmmc00=?
43 08:41:31 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
44 08:41:31 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data =
45 08:41:31 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
46 08:41:31 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
47 08:41:31 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
48 08:41:31 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
49 08:41:31 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
50 08:41:31 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
51 08:41:31 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
52 08:41:31 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
53 08:41:31 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
54 08:41:31 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
55 08:41:31 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1864
56 08:41:31 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
57 08:41:31 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 481
58 08:41:31 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
59 08:41:31 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
60 08:41:31 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
61 08:41:31 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
62 08:41:31 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
63 08:41:31 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
64 08:41:31 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
65 08:41:31 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
66 08:41:31 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
67 08:41:31 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
68 08:41:31 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
69 08:41:31 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
70 08:41:31 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
71 08:41:31 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
72 08:41:31 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
73 08:41:31 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
74 08:41:31 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
75 08:41:31 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
76 08:41:31 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
77 08:41:31 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
78 08:41:31 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
79 08:41:31 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
80 08:41:31 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
81 08:41:31 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
82 08:41:31 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
83 08:41:31 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
84 08:41:31 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
85 08:41:31 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
86 08:41:31 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
87 08:41:31 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
88 08:41:31 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
89 08:41:31 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
90 08:41:31 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
91 08:41:31 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
92 08:41:31 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
93 08:41:31 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 53, Scale = 0, Data = 00
94 08:41:31 SQL Execute: ORACLE - BEGIN "SP_YJ_YJSQWH" (POPFLAG => :POPFLAG,PYJDJH0 => :PYJDJH0,PZYGHID => :PZYGHID,PMZZYBZ => :PMZZYBZ,PZLXMID => :PZLXMID,PZXMID0 => :PZXMID0,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PBBID00 => :PBBID00,PBH0000 => :PBH0000,PYJLRBZ => :PYJLRBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PKDBQ00 => :PKDBQ00,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PFJDJBZ => :PFJDJBZ,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYWMXID => :PYWMXID,PBWMC00 => :PBWMC00,PFYJDJH => :PFYJDJH,PCXJJ00 => :PCXJJ00,PYZCFID => :PYZCFID,PSSDH00 => :PSSDH00,PTXM000 => :PTXM000,PWZBM00 => :PWZBM00,PSSBM00 => :PSSBM00,PSSMC00 => :PSSMC00,PSSYJDH => :PSSYJDH,PWZBH00 => :PWZBH00,PTQPC00 => :PTQPC00,PXMZK00 => :PXMZK00,PYJZHJE => :PYJZHJE,PTCID00 => :PTCID00,PMBMXID => :PMBMXID,PSFTJ00 => :PSFTJ00,PSFZF00 => :PSFZF00,PYYGXJG => :PYYGXJG,PBWID00 => :PBWID00,PZLXMJC => :PZLXMJC,PYEXM00 => :PYEXM00,PSFFR00 => :PSFFR00,PDCNYJ0 => :PDCNYJ0,PXMLSTR => :PXMLSTR); END;
95 08:41:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医疗费用智慧管控系统外部接口' and BH0000 = 'SFTCXSJKHHXX'
96 08:41:31 SQL Execute: ORACLE - select nvl(MC0000,'0') MC0000,BH0000 from BM_TYZD00 where ZDMC00='医疗费用智慧管控系统外部接口' and YXBZ00 = '1'
97 08:41:31 SQL Execute: ORACLE - commit
98 08:41:31 SQL Data In: ORACLE - Rows affected = 0
99 08:41:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ'
100 08:41:31 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB'
101 08:41:34 SQL Execute: ORACLE - select sysdate from dual
102 08:41:34 SQL Execute: ORACLE - select * from vw_yj_yw0000_wzx b
where xmzt00 in('0','1') and brid00=4823337
and kdrq00 = '20240116'
and ((YJKSBH = 487) or (KDKSBH = 487) or (LRXM00 = '管理员'))
and YJLRBZ = 'Y'
and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh))
and ((cxdjh0 = 0) or (cxdjh0 is null))
order by YJDJH0 desc
103 08:41:34 SQL Execute: ORACLE - select * from VW_YJ_YWJJ00 where YJDJH0 = 50588162 order by ID0000
104 08:41:34 SQL Execute: ORACLE - select * from VW_YJ_YWMX00 where YJDJH0 = 50588162 order by ID0000
105 08:41:34 SQL Execute: ORACLE - select * from VW_YJ_YWJJ00 where YJDJH0 = 50588162 order by ID0000
106 08:41:34 SQL Execute: ORACLE - select * from VW_YJ_YWMX00 where YJDJH0 = 50588162 order by ID0000
107 08:41:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
108 08:41:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
109 08:41:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
110 08:41:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
111 08:41:34 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
112 08:41:34 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 ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',487,')>0)) 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 KDRQ00 between '20240109' and '20240116' order by XMZT00,YJDJH0 Desc
113 08:41:34 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588162
114 08:41:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
115 08:41:34 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,50588162 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0'
116 08:41:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
117 08:41:34 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
118 08:41:34 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
119 08:41:34 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
120 08:41:34 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
121 08:41:34 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588162
122 08:41:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
123 08:41:34 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,50588162 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0'
124 08:41:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
125 08:41:34 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
126 08:41:34 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
127 08:41:34 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
128 08:41:37 SQL Execute: ORACLE - select * from VW_YJ_YW0000_WZX where xmzt00 in ('0','1','5') and yjdjh0=50588162
129 08:41:37 SQL Execute: ORACLE - select zlxmbh,LBBH00 from bm_zlzd00 where zlxmid=17916
130 08:41:37 SQL Execute: ORACLE - select yexm00 from bq_jsxx00 where zyid00=1152232
131 08:41:37 SQL Execute: ORACLE - select zlxmbh from bm_zlzd00 where zlxmid=17916
132 08:41:37 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=17916 order by zxmbh0
133 08:41:37 SQL Execute: ORACLE - select b.zlxmid zlxmid,a.sl0000 sl0000 from yj_ywmx00 a,bm_zlzd00 b where b.zlxmbh in( select decode(length(d.zlxmbh),13,substr(d.zlxmbh,1,10),d.zlxmbh) from yj_ywmx00 c,bm_zlzd00 d where c.yjdjh0=50588162 and c.zlxmid=d.zlxmid) and a.yjdjh0=50588162 and a.zlxmid=b.zlxmid
134 08:41:37 SQL Execute: ORACLE - select distinct bqh000,bmmc00 from bq_brldxx q,bm_bmbm00 m where zyid00= 1152232 and q.bqh000=m.bmbh00
135 08:41:37 SQL Execute: ORACLE - select BMMC00,BMBH00 from VW_YS_YJZXKS where ZLXMID=17916
136 08:41:37 SQL Execute: ORACLE - SELECT KDBQ00 FROM YJ_YW0000 WHERE YJDJH0=50588162
137 08:41:37 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4823337.000000
138 08:41:37 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
139 08:41:37 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
140 08:41:37 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
141 08:41:37 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
142 08:41:37 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
143 08:41:37 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
144 08:41:37 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
145 08:41:37 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
146 08:41:37 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
147 08:41:37 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
148 08:41:37 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
149 08:41:37 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
150 08:41:37 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
151 08:41:37 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
152 08:41:37 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
153 08:41:37 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
154 08:41:37 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
155 08:41:43 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
156 08:41:43 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 50588162
157 08:41:43 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
158 08:41:43 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
159 08:41:43 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
160 08:41:43 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
161 08:41:43 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = R05.x00
162 08:41:43 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
163 08:41:43 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
164 08:41:43 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
165 08:41:43 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
166 08:41:43 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
167 08:41:43 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1864
168 08:41:43 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
169 08:41:43 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 481
170 08:41:43 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
171 08:41:43 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
172 08:41:43 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
173 08:41:43 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
174 08:41:43 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
175 08:41:43 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
176 08:41:43 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
177 08:41:43 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
178 08:41:43 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
179 08:41:43 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
180 08:41:43 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
181 08:41:43 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
182 08:41:43 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
183 08:41:43 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
184 08:41:43 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
185 08:41:43 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
186 08:41:43 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
187 08:41:43 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
188 08:41:43 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
189 08:41:43 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
190 08:41:43 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
191 08:41:43 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
192 08:41:43 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
193 08:41:43 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
194 08:41:43 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
195 08:41:43 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
196 08:41:43 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
197 08:41:43 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
198 08:41:43 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
199 08:41:43 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
200 08:41:43 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
201 08:41:43 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
202 08:41:43 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
203 08:41:43 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
204 08:41:43 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
205 08:41:43 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 36, Scale = 0, Data = 00
206 08:41:43 SQL Execute: ORACLE - BEGIN "SP_YJ_YJSQWH" (POPFLAG => :POPFLAG,PYJDJH0 => :PYJDJH0,PZYGHID => :PZYGHID,PMZZYBZ => :PMZZYBZ,PZLXMID => :PZLXMID,PZXMID0 => :PZXMID0,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PBBID00 => :PBBID00,PBH0000 => :PBH0000,PYJLRBZ => :PYJLRBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PKDBQ00 => :PKDBQ00,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PFJDJBZ => :PFJDJBZ,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYWMXID => :PYWMXID,PBWMC00 => :PBWMC00,PFYJDJH => :PFYJDJH,PCXJJ00 => :PCXJJ00,PYZCFID => :PYZCFID,PSSDH00 => :PSSDH00,PTXM000 => :PTXM000,PWZBM00 => :PWZBM00,PSSBM00 => :PSSBM00,PSSMC00 => :PSSMC00,PSSYJDH => :PSSYJDH,PWZBH00 => :PWZBH00,PTQPC00 => :PTQPC00,PXMZK00 => :PXMZK00,PYJZHJE => :PYJZHJE,PTCID00 => :PTCID00,PMBMXID => :PMBMXID,PSFTJ00 => :PSFTJ00,PSFZF00 => :PSFZF00,PYYGXJG => :PYYGXJG,PBWID00 => :PBWID00,PZLXMJC => :PZLXMJC,PYEXM00 => :PYEXM00,PSFFR00 => :PSFFR00,PDCNYJ0 => :PDCNYJ0,PXMLSTR => :PXMLSTR); END;
207 08:41:44 SQL Execute: ORACLE - Commit
208 08:41:44 SQL Data In: ORACLE - Rows affected = 0
209 08:41:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ'
210 08:41:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB'
211 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
212 08:41:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
213 08:41:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
214 08:41:45 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
215 08:41:45 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
216 08:41:45 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 ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',487,')>0)) 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 KDRQ00 between '20240109' and '20240116' order by XMZT00,YJDJH0 Desc
217 08:41:45 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588162
218 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
219 08:41:45 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,50588162 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0'
220 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
221 08:41:45 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
222 08:41:45 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
223 08:41:45 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
224 08:41:45 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
225 08:41:45 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588162
226 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
227 08:41:45 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,50588162 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0'
228 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
229 08:41:45 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
230 08:41:45 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
231 08:41:45 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
232 08:41:45 SQL Execute: ORACLE - select a.*,'' as ZTM000,'' as CTM000 from VW_YJ_YWJJ00 a where a.YJDJH0 = 50588162
233 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
234 08:41:45 SQL Execute: ORACLE - select distinct B.YPQLPC CFID00,B.TQDJH0 CFLSH0, nvl(B.YZID00,B.YPQLPC) ZB0000, B.YPNM00, B.YPMC00,B.YPGG00, B.CSL000, B.JLDW00, B.YPYFMC, B.PCMC00, B.YYSJ00, B.YYSJDW, B.YPZSL0,c.zyfydw CFDW00, '' YPSCPH, B.CXBZ00, B.ZJYFMC, B.XMYFMC, '' PSLBID, '' PSMC00,50588162 YJDJH0,F.YFLBID from MZ_DCXMGZ A, YF_YZYPSQ B,BM_YD0000 C,BM_YPYF00 F where B.YPNM00=C.YPNM00 and B.YFID00=F.YFID00 and B.TQDJH0 = ? AND to_number(A.LYXMID) = to_number(B.YFID00) AND A.CSLY00 = '0'
235 08:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
236 08:41:45 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00=?
237 08:41:45 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
238 08:41:45 SQL Execute: ORACLE - select '4823337' BRID00, '1' MZZYBZ, '住院' MZZYMC, '15980272943' BRLXDH,'2311898' ZYHGHH, '陈夏洋' BRXM00, '女' BRXB00, '36岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '4823337') FBMC00 , '13-03' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=481) BQMC00, (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='4823337' ) JZFPBZ from dual
239 08:41:48 SQL Execute: ORACLE - select * from VW_YJ_YW0000_WZX where xmzt00 in ('0','1','5') and yjdjh0=50588162
240 08:41:48 SQL Execute: ORACLE - select zlxmbh,LBBH00 from bm_zlzd00 where zlxmid=17916
241 08:41:48 SQL Execute: ORACLE - select yexm00 from bq_jsxx00 where zyid00=1152232
242 08:41:48 SQL Execute: ORACLE - select zlxmbh from bm_zlzd00 where zlxmid=17916
243 08:41:48 SQL Execute: ORACLE - select zlxmjc,zxmid0 zlxmid,gdxmbz,''jgms00,jgdw00,ckz000,bbid00,zyzbid,zxmbh0 zlxmbh from VW_YS_YWMXXM WHERE SJXMID=17916 order by zxmbh0
244 08:41:48 SQL Execute: ORACLE - select b.zlxmid zlxmid,a.sl0000 sl0000 from yj_ywmx00 a,bm_zlzd00 b where b.zlxmbh in( select decode(length(d.zlxmbh),13,substr(d.zlxmbh,1,10),d.zlxmbh) from yj_ywmx00 c,bm_zlzd00 d where c.yjdjh0=50588162 and c.zlxmid=d.zlxmid) and a.yjdjh0=50588162 and a.zlxmid=b.zlxmid
245 08:41:48 SQL Execute: ORACLE - select distinct bqh000,bmmc00 from bq_brldxx q,bm_bmbm00 m where zyid00= 1152232 and q.bqh000=m.bmbh00
246 08:41:48 SQL Execute: ORACLE - select BMMC00,BMBH00 from VW_YS_YJZXKS where ZLXMID=17916
247 08:41:48 SQL Execute: ORACLE - SELECT KDBQ00 FROM YJ_YW0000 WHERE YJDJH0=50588162
248 08:41:48 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4823337.000000
249 08:41:48 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
250 08:41:48 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
251 08:41:48 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
252 08:41:48 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
253 08:41:48 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
254 08:41:48 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
255 08:41:48 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
256 08:41:48 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
257 08:41:48 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
258 08:41:48 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
259 08:41:48 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
260 08:41:48 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
261 08:41:48 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
262 08:41:48 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
263 08:41:48 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
264 08:41:48 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
265 08:41:48 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END;
266 08:41:55 SQL Execute: ORACLE - select DLKSZX,b.BMBH00,b.BMMC00 from bm_zlzd00 A,bm_bmbm00 b where ZLXMID = 17916 and a.ZXKS00=b.Bmbh00(+)
267 08:41:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000
268 08:41:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17916.000000
269 08:41:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000
270 08:41:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035
271 08:41:55 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJJSKS
where SQXMKS=? and ZLXMID=? order by decode(bmbh00,?,0,1),decode(yyid00,?,0,1),nvl(ksxmid,99999)
272 08:41:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17916.000000
273 08:41:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 487.000000
274 08:41:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035
275 08:41:55 SQL Execute: ORACLE - select BMBH00,BMMC00 from VW_YS_YJZXKS where ZLXMID=? order by decode(bmbh00,?,0,1),decode(yyid00,?,0,1),nvl(ksxmid,99999)
276 08:41:55 SQL Execute: ORACLE - select * from BM_JYXMBB where ZLXMID=17916
277 08:41:55 SQL Execute: ORACLE - select * from BM_BBZD00 where SFYX00='1' and (LBBH00=5 or LBBH00 is null) and BBID00=''
278 08:41:57 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
279 08:41:57 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 50588162
280 08:41:57 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
281 08:41:57 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
282 08:41:57 SQL Data In: ORACLE - Param = 5, Name = PZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
283 08:41:57 SQL Data In: ORACLE - Param = 6, Name = PZXMID0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17916
284 08:41:57 SQL Data In: ORACLE - Param = 7, Name = PZDID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = R05.x00
285 08:41:57 SQL Data In: ORACLE - Param = 8, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
286 08:41:57 SQL Data In: ORACLE - Param = 9, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
287 08:41:57 SQL Data In: ORACLE - Param = 10, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
288 08:41:57 SQL Data In: ORACLE - Param = 11, Name = PYJLRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
289 08:41:57 SQL Data In: ORACLE - Param = 12, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
290 08:41:57 SQL Data In: ORACLE - Param = 13, Name = PKDYS00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1864
291 08:41:57 SQL Data In: ORACLE - Param = 14, Name = PKDKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
292 08:41:57 SQL Data In: ORACLE - Param = 15, Name = PKDBQ00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 481
293 08:41:57 SQL Data In: ORACLE - Param = 16, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 480
294 08:41:57 SQL Data In: ORACLE - Param = 17, Name = PSL0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
295 08:41:57 SQL Data In: ORACLE - Param = 18, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
296 08:41:57 SQL Data In: ORACLE - Param = 19, Name = PFJDJBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
297 08:41:57 SQL Data In: ORACLE - Param = 20, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1057
298 08:41:57 SQL Data In: ORACLE - Param = 21, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
299 08:41:57 SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
300 08:41:57 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
301 08:41:57 SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
302 08:41:57 SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
303 08:41:57 SQL Data In: ORACLE - Param = 26, Name = PYWMXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
304 08:41:57 SQL Data In: ORACLE - Param = 27, Name = PBWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
305 08:41:57 SQL Data In: ORACLE - Param = 28, Name = PFYJDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
306 08:41:57 SQL Data In: ORACLE - Param = 29, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
307 08:41:57 SQL Data In: ORACLE - Param = 30, Name = PYZCFID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
308 08:41:57 SQL Data In: ORACLE - Param = 31, Name = PSSDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
309 08:41:57 SQL Data In: ORACLE - Param = 32, Name = PTXM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
310 08:41:57 SQL Data In: ORACLE - Param = 33, Name = PWZBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
311 08:41:57 SQL Data In: ORACLE - Param = 34, Name = PSSBM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
312 08:41:57 SQL Data In: ORACLE - Param = 35, Name = PSSMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
313 08:41:57 SQL Data In: ORACLE - Param = 36, Name = PSSYJDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
314 08:41:57 SQL Data In: ORACLE - Param = 37, Name = PWZBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
315 08:41:57 SQL Data In: ORACLE - Param = 38, Name = PTQPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
316 08:41:57 SQL Data In: ORACLE - Param = 39, Name = PXMZK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
317 08:41:57 SQL Data In: ORACLE - Param = 40, Name = PYJZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
318 08:41:57 SQL Data In: ORACLE - Param = 41, Name = PTCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
319 08:41:57 SQL Data In: ORACLE - Param = 42, Name = PMBMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
320 08:41:57 SQL Data In: ORACLE - Param = 43, Name = PSFTJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
321 08:41:57 SQL Data In: ORACLE - Param = 44, Name = PSFZF00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
322 08:41:57 SQL Data In: ORACLE - Param = 45, Name = PYYGXJG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
323 08:41:57 SQL Data In: ORACLE - Param = 46, Name = PBWID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
324 08:41:57 SQL Data In: ORACLE - Param = 47, Name = PZLXMJC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
325 08:41:57 SQL Data In: ORACLE - Param = 48, Name = PYEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
326 08:41:57 SQL Data In: ORACLE - Param = 49, Name = PSFFR00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
327 08:41:57 SQL Data In: ORACLE - Param = 50, Name = PDCNYJ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
328 08:41:57 SQL Data In: ORACLE - Param = 51, Name = PXMLSTR, Type = fldZSTRING, Precision = 36, Scale = 0, Data = 00
329 08:41:57 SQL Execute: ORACLE - BEGIN "SP_YJ_YJSQWH" (POPFLAG => :POPFLAG,PYJDJH0 => :PYJDJH0,PZYGHID => :PZYGHID,PMZZYBZ => :PMZZYBZ,PZLXMID => :PZLXMID,PZXMID0 => :PZXMID0,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PBBID00 => :PBBID00,PBH0000 => :PBH0000,PYJLRBZ => :PYJLRBZ,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PKDBQ00 => :PKDBQ00,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,PFJDJBZ => :PFJDJBZ,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYWMXID => :PYWMXID,PBWMC00 => :PBWMC00,PFYJDJH => :PFYJDJH,PCXJJ00 => :PCXJJ00,PYZCFID => :PYZCFID,PSSDH00 => :PSSDH00,PTXM000 => :PTXM000,PWZBM00 => :PWZBM00,PSSBM00 => :PSSBM00,PSSMC00 => :PSSMC00,PSSYJDH => :PSSYJDH,PWZBH00 => :PWZBH00,PTQPC00 => :PTQPC00,PXMZK00 => :PXMZK00,PYJZHJE => :PYJZHJE,PTCID00 => :PTCID00,PMBMXID => :PMBMXID,PSFTJ00 => :PSFTJ00,PSFZF00 => :PSFZF00,PYYGXJG => :PYYGXJG,PBWID00 => :PBWID00,PZLXMJC => :PZLXMJC,PYEXM00 => :PYEXM00,PSFFR00 => :PSFFR00,PDCNYJ0 => :PDCNYJ0,PXMLSTR => :PXMLSTR); END;
330 08:41:57 SQL Execute: ORACLE - Commit
331 08:41:57 SQL Data In: ORACLE - Rows affected = 0
332 08:41:58 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'YJ'
333 08:41:58 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'HIS转调通用接口' and BH0000 = 'KFFSPTZLXMLB'
334 08:41:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1152232
335 08:41:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
336 08:41:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
337 08:41:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
338 08:41:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 487
339 08:41:58 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 ZYGHID = ? and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00=3 and YJDJH0=a.yjdjh0 ) and not exists ( select 1 from YJ_YW0000 where YJKSBH<>? and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) and (YJKSBH+0 = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID = a.ZLXMID and a.SFQZX0 = 'Y' and a.MZZYBZ = '0' ) and instr(',553,819,914,931,480,816,1051,561,978,477,936,729,675,',',487,')>0)) 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 KDRQ00 between '20240109' and '20240116' order by XMZT00,YJDJH0 Desc
340 08:41:58 SQL Execute: ORACLE - select SF_YJ_GetBrzhye(4823337,'1',1152232) from dual
341 08:42:00 SQL Execute: ORACLE - select * from VW_YJ_YW0000 where ZYGHID=1152232 and MZZYBZ = '1'