1       17:40:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13351
2       17:40:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2207
3       17:40: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 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 = '1810145'  and KDRQ00 between '20231021' and '20231024'  order by XMZT00,YJDJH0 Desc 

4       17:40:45  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 = 10474950 order by c.NBID00,a.ID0000

5       17:40:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
6       17:40:45  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, 10474950 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 

7       17:40:45  SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=13351

8       17:40:45  SQL Execute: ORACLE - select SF_YJ_GetBrzhye(13351,'0',1810145) from dual

9       17:40:45  SQL Execute: ORACLE - select '13351' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13960708664' BRLXDH,'1810145' ZYHGHH, '杨枫钦' BRXM00, '女' BRXB00, '44岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '13351') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00,  (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='13351' ) JZFPBZ from dual 

10      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','0','') as BRGMXX from dual 

11      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','1','') as BRGMXX from dual 

12      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','2','') as BRGMXX from dual 

13      17:40:45  SQL Execute: ORACLE - select SF_YJ_GetBrzhye(13351,'0',1810145) from dual

14      17:40:45  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 = 10474950 order by c.NBID00,a.ID0000

15      17:40:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
16      17:40:45  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, 10474950 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 

17      17:40:45  SQL Execute: ORACLE - select * from VW_BM_BRXXB0 where BRID00=13351

18      17:40:45  SQL Execute: ORACLE - select SF_YJ_GetBrzhye(13351,'0',1810145) from dual

19      17:40:45  SQL Execute: ORACLE - select '13351' BRID00, '0' MZZYBZ, '门诊' MZZYMC, '13960708664' BRLXDH,'1810145' ZYHGHH, '杨枫钦' BRXM00, '女' BRXB00, '44岁' NL0000, (select a.YBMC00 from IC_YBBRLB a,BM_BRXXB0 b where a.YBLB00=b.YBLB00 and a.FBBH00=b.FBBH00 and b.BRID00 = '13351') FBMC00 , ' ' CH0000,(select BMMC00 from BM_BMBM00 where BMBH00=0) BQMC00,  (select decode(SFJZFP,'1','精准扶贫',' ') from BM_BRXXB0 where BRID00='13351' ) JZFPBZ from dual 

20      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','0','') as BRGMXX from dual 

21      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','1','') as BRGMXX from dual 

22      17:40:45  SQL Execute: ORACLE - select SF_XT_BRGMJL_DZBL('0','13351','2','') as BRGMXX from dual