1 11:05:53 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'R') )
and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',453,')> 0)
and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2360,')> 0)
AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2360 AND b.JSKSBH = '453')
AND (INSTR (',' || a.jsksbh || ',',',453,') > 0 or a.jsksbh is null)
2 11:05:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
3 11:05:53 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
4 11:05:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
5 11:05:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
6 11:05:53 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
7 11:05:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
8 11:05:53 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
9 11:05:53 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281121 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
10 11:05:53 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928217'
11 11:05:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
12 11:05:53 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
13 11:05:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7213996
14 11:05:55 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
15 11:05:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
16 11:05:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7213996
17 11:05:55 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
18 11:05:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7213996
19 11:05:55 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
20 11:05:55 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281119 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
21 11:05:55 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928215'
22 11:05:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
23 11:05:55 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
24 11:05:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
25 11:05:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
26 11:05:55 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
27 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214004
28 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
29 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281121 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
30 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928217'
31 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214008
32 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
33 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
34 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214008
35 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
36 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214008
37 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
38 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15280232 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
39 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8927328'
40 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214000
41 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
42 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
43 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214000
44 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
45 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214000
46 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
47 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15280232 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
48 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8927328'
49 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214009
50 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
51 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
52 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214009
53 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
54 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214009
55 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
56 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15280232 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
57 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8927328'
58 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214013
59 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
60 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
61 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214013
62 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
63 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214013
64 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
65 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281140 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
66 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928236'
67 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214012
68 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
69 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
70 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214012
71 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
72 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214012
73 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
74 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281140 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
75 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928236'
76 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214025
77 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
78 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
79 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214025
80 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
81 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214025
82 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
83 11:05:56 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281153 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
84 11:05:56 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928249'
85 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214016
86 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
87 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
88 11:05:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214016
89 11:05:56 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
90 11:05:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214016
91 11:05:56 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
92 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281133 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
93 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928229'
94 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214015
95 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
96 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
97 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214015
98 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
99 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214015
100 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
101 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281133 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
102 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928229'
103 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214032
104 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
105 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
106 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214032
107 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
108 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281107 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
109 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928203'
110 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214026
111 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
112 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
113 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214026
114 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
115 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15279813 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
116 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8927009'
117 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214036
118 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
119 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
120 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214036
121 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
122 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281220 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
123 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928266'
124 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214019
125 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
126 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
127 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214019
128 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
129 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281116 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
130 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928212'
131 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
132 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
133 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
134 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
135 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
136 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
137 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
138 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281121 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
139 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928217'
140 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
141 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
142 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 453
143 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
144 11:05:57 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00 AS KDYS00,M.BMMC00 AS KDKS00,C.ZYTS00,C.ZYDJS0,C.SRRQ00,C.JZRQ00,C.CFZJE0 YPJE00,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,'Y'FLAG00,substr(sf_BQ_csrqtonl(C.csrq00),1,10) BRNL00,substr(((select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='3' and rownum='1')||' '||(select ZDMC00 from YS_BRZDXX where GHH000=C.GHH000 and ZZDBZ0='1' and rownum='1')),1,120) ZD0000, (select ZWXM00 from BM_YGBM00 where YGBH00= nvl( c.PFR000,-1 ) ) PYRXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.YFBMBH=? AND C.CFLSH0=? AND C.CFZT00 in ('0','1','4') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC
145 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 7214048
146 11:05:57 SQL Execute: ORACLE - select ' ' TSYSMC,a.*, decode(a.YPYFMC,'煎服','',a.YPYFMC) as yfmcbm,a.YPZSL0*a.lsdj00 as xjje00, trim(substrb(trim(a.ypmc00)||'/'||trim(a.ypgg00),1,35)) as ypmcgg,trim(a.ypzsl0)||'('||trim(a.cfdw00)||')' as sldw00,trim(a.csl000)||'('||trim(a.JLDW00)||')' as jl00dw,(select SFJG00 from YF_MZCF00 where CFLSH0=a.CFLSH0) SFJG00, ' ' HTSHDJ,substr(SF_YF_GETYPGWFL(a.YPNM00),1,20) GWFLMC, (select MC0000 from BM_TYZD00 where ZDMC00='海泰皮试结果' and BH0000=trim(a.PSLBID) ) HTPSJG,substr(SF_YF_GETYPSCCJ('0',a.CFID00),1,100) SCCJZW, decode(substr(trim(a.csl000),1,1),'.','0'||trim(a.csl000),trim(a.csl000))||'('||trim(a.jldw00)||')/'||trim(a.pcmc00)||'*'||trim(a.yysj00)||'/'||trim(a.ypyfmc) as xxyf00 from yf_mzcfmx a, yf_cfdl00 b where SFZBY0='N' and b.cflsh0=a.cflsh0 and a.cflsh0=?
147 11:05:57 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=15281121 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc
148 11:05:57 SQL Execute: ORACLE - SELECT SJLY00 FROM SF_BRXXB0
WHERE GHH000='8928217'
149 11:05:57 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'SFSSQZ_MZ'
150 11:05:57 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7213996
151 11:05:57 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2360.000000
152 11:05:57 SQL Data In: ORACLE - Param = 3, Name = PFLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
153 11:05:57 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
154 11:05:57 SQL Data In: ORACLE - Param = 5, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
155 11:05:57 SQL Data In: ORACLE - Param = 6, Name = POTHER0, Type = fldZSTRING, Precision = 38, Scale = 0, Data = 05.0
156 11:05:57 SQL Execute: ORACLE - BEGIN "SP_YF_MZFYZDFPZSM_DLL" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PFLAG00 => :PFLAG00,PMZZYBZ => :PMZZYBZ,PCOMMIT => :PCOMMIT,POTHER0 => :POTHER0); END;
157 11:05:57 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7214004
158 11:05:57 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2360.000000
159 11:05:57 SQL Data In: ORACLE - Param = 3, Name = PFLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
160 11:05:57 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
161 11:05:57 SQL Data In: ORACLE - Param = 5, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
162 11:05:57 SQL Data In: ORACLE - Param = 6, Name = POTHER0, Type = fldZSTRING, Precision = 38, Scale = 0, Data = 05.0
163 11:05:57 SQL Execute: ORACLE - BEGIN "SP_YF_MZFYZDFPZSM_DLL" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PFLAG00 => :PFLAG00,PMZZYBZ => :PMZZYBZ,PCOMMIT => :PCOMMIT,POTHER0 => :POTHER0); END;
164 11:05:57 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7214036
165 11:05:57 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2360.000000
166 11:05:57 SQL Data In: ORACLE - Param = 3, Name = PFLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
167 11:05:57 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
168 11:05:57 SQL Data In: ORACLE - Param = 5, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
169 11:05:57 SQL Data In: ORACLE - Param = 6, Name = POTHER0, Type = fldZSTRING, Precision = 38, Scale = 0, Data = 05.0
170 11:05:57 SQL Execute: ORACLE - BEGIN "SP_YF_MZFYZDFPZSM_DLL" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PFLAG00 => :PFLAG00,PMZZYBZ => :PMZZYBZ,PCOMMIT => :PCOMMIT,POTHER0 => :POTHER0); END;
171 11:05:57 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP'
172 11:05:57 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('0','7213996','7214004','7214036') order by A.ZB0000,A.CFID00
173 11:05:57 SQL Execute: ORACLE - select X.XM0000||' '||X.XB0000||' '||SF_XT_CSRQTONL(X.CSRQ00)||' '||X.FBMC00||' '||B.BMMC00 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.GHID00 in ( select c.GHID00 from YF_MZCF00 C where C.CFLSH0 = '7214004' ) AND X.GHKS00=B.BMBH00
174 11:05:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
175 11:05:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
176 11:05:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7214004
177 11:05:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23636.000000
178 11:05:57 SQL Execute: ORACLE - select A.*,A.ZSM000,nvl(A.YPZSL0,B.ZSMZHL)/B.ZSMZHL||B.ZSMDW0 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.MZZYBZ = ? and A.YZLB00 = ? and trim(A.CFLSH0) = ? and A.YPNM00 = ?
179 11:05:58 SQL Execute: ORACLE - select X.XM0000||' '||X.XB0000||' '||SF_XT_CSRQTONL(X.CSRQ00)||' '||X.FBMC00||' '||B.BMMC00 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.GHID00 in ( select c.GHID00 from YF_MZCF00 C where C.CFLSH0 = '7214004' ) AND X.GHKS00=B.BMBH00
180 11:05:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
181 11:05:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
182 11:05:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7214004
183 11:05:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23636.000000
184 11:05:58 SQL Execute: ORACLE - select A.*,A.ZSM000,nvl(A.YPZSL0,B.ZSMZHL)/B.ZSMZHL||B.ZSMDW0 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B where A.YPNM00 = B.YPNM00 AND A.MZZYBZ = ? and A.YZLB00 = ? and trim(A.CFLSH0) = ? and A.YPNM00 = ?