1 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 2 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 3 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 4 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 5 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 6 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 7 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 8 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 9 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 10 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 11 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 12 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 13 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 14 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 15 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 16 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 17 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 18 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 19 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 20 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 21 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 22 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 23 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 24 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 25 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 26 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 27 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 28 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 29 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 30 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 31 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 32 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 33 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 34 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 35 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 36 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 37 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 38 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 39 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 40 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 41 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 42 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 43 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 44 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 45 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 46 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 47 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 48 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 49 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 50 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 51 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 52 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 53 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 54 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 55 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 56 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 57 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 58 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 59 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 60 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 61 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 62 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 63 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 64 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 65 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 66 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 67 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 68 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 69 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 70 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 71 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 72 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 73 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 74 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 75 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 76 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 77 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 78 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 79 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 80 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 81 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 82 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 83 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 84 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 85 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 86 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 87 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 88 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 89 16:30:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 90 16:30:54 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 91 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 92 16:30:55 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=? AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 93 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 94 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=9000017743 95 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 96 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 97 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 98 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 99 16:30:55 SQL Execute: ORACLE - SELECT BRID00,FBBH00 FROM SF_BRXXB0 WHERE GHH000='10251060' 100 16:30:55 SQL Execute: ORACLE - SELECT X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00, B.BMMC00 AS GHKSMC,X.GHH000,X.GHY000,X.GHRQ00, (SELECT BRBLH0 FROM SF_BRXXB0 WHERE GHH000=X.GHH000 AND ROWNUM=1) BRBLH0,X.YBSBK0 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.BRID00=5584770 AND X.GHKS00=B.BMBH00 ORDER BY X.GHID00 DESC 101 16:30:55 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19570110) AS NL FROM DUAL 102 16:30:55 SQL Execute: ORACLE - Select SF_SF_GETKYJE(5584770) KYYE00 from dual 103 16:30:55 SQL Execute: ORACLE - SELECT COUNT(1) GHCS00 FROM SF_BRXXB0 WHERE BRID00=5584770 AND GHY000=1513 AND GHRQ00=20241029 AND THBZ00<>'0' 104 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10251060' 105 16:30:55 SQL Execute: ORACLE - SELECT 'N' NX, NVL(C.TSYS00,0) TSYS00,nvl(C.SHBZ00,'N') SHBZ00 ,decode(nvl(C.SHBZ00,'N'),'Y','审核','M','退回','未审核') SHQK00,C.CFLSH0,C.GHH000,C.BRXM00,C.XB0000,C.BRID00,nvl(C.CFDGS0,'5') CFDGS0, C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,decode(substr(SF_PY_ZYPYLB(C.CFLSH0),1,10),'0',0,'1',0,C.ZYTS00) ZYTS00,C.ZYDJS0,C.GHKS00 GHKSBM, C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000, substr(SF_XT_GETMZZD(C.GHH000),1,150) /*(SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') */ as ZZDMC0, (SELECT BRBLH0 FROM SF_BRXXB0 WHERE GHH000=C.GHH000 AND ROWNUM=1) BRBLH0,nvl(C.CFDGS0,'5') CFDGS0,C.BZ0000,c.fyrq00,c.fysj00, decode(substr(SF_PY_ZYPYLB(C.CFLSH0),1,10),'2','中草药','6','中草药','4','全成分','5','全成分','0','西药','1','成药') PYLBBH, decode(C.PSZT00,'1','需皮试','2','皮试未通过不能发药','3','皮试通过可发药','0','非皮试') PSJG00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.JZRQ00>='20241022' AND C.JZRQ00<='20241029' AND C.YFBMBH=1105 AND C.CFZT00 = '1' AND C.GHH000 is not null AND NOT EXISTS (SELECT 1 FROM YF_MZCF00 WHERE BRID00=C.BRID00 and GHH000=C.GHH000 and BCCFH0=C.CFLSH0 AND CFZT00='0') AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='Y' ORDER BY C.CFLSH0 DESC 106 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 107 16:30:55 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=? AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 108 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 109 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=9000017743 110 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 111 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 112 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 113 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 114 16:30:55 SQL Execute: ORACLE - SELECT BRID00,FBBH00 FROM SF_BRXXB0 WHERE GHH000='10251060' 115 16:30:55 SQL Execute: ORACLE - SELECT X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00, B.BMMC00 AS GHKSMC,X.GHH000,X.GHY000,X.GHRQ00, (SELECT BRBLH0 FROM SF_BRXXB0 WHERE GHH000=X.GHH000 AND ROWNUM=1) BRBLH0,X.YBSBK0 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.BRID00=5584770 AND X.GHKS00=B.BMBH00 ORDER BY X.GHID00 DESC 116 16:30:55 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19570110) AS NL FROM DUAL 117 16:30:55 SQL Execute: ORACLE - Select SF_SF_GETKYJE(5584770) KYYE00 from dual 118 16:30:55 SQL Execute: ORACLE - SELECT COUNT(1) GHCS00 FROM SF_BRXXB0 WHERE BRID00=5584770 AND GHY000=1513 AND GHRQ00=20241029 AND THBZ00<>'0' 119 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10251060' 120 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10247172' 121 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10247172' 122 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10247172' 123 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10251060' 124 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 125 16:30:55 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=? AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 126 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 127 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=9000017743 128 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 129 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 130 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 131 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 132 16:30:55 SQL Execute: ORACLE - SELECT BRID00,FBBH00 FROM SF_BRXXB0 WHERE GHH000='10251060' 133 16:30:55 SQL Execute: ORACLE - SELECT X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00, B.BMMC00 AS GHKSMC,X.GHH000,X.GHY000,X.GHRQ00, (SELECT BRBLH0 FROM SF_BRXXB0 WHERE GHH000=X.GHH000 AND ROWNUM=1) BRBLH0,X.YBSBK0 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.BRID00=5584770 AND X.GHKS00=B.BMBH00 ORDER BY X.GHID00 DESC 134 16:30:55 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19570110) AS NL FROM DUAL 135 16:30:55 SQL Execute: ORACLE - Select SF_SF_GETKYJE(5584770) KYYE00 from dual 136 16:30:55 SQL Execute: ORACLE - SELECT COUNT(1) GHCS00 FROM SF_BRXXB0 WHERE BRID00=5584770 AND GHY000=1513 AND GHRQ00=20241029 AND THBZ00<>'0' 137 16:30:55 SQL Execute: ORACLE - select YWGM00,FYWGM0 from YS_MZBLWS where GHH000='10251060' 138 16:30:55 SQL Execute: ORACLE - SELECT X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00, B.BMMC00 AS GHKSMC,X.GHH000,X.GHY000,X.GHRQ00, (SELECT BRBLH0 FROM SF_BRXXB0 WHERE GHH000=X.GHH000 AND ROWNUM=1) BRBLH0,X.YBSBK0 FROM VW_YF_MZBRZH X,BM_BMBM00 B WHERE X.BRID00=5584770 AND X.GHKS00=B.BMBH00 ORDER BY X.GHID00 DESC 139 16:30:55 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19570110) AS NL FROM DUAL 140 16:30:55 SQL Execute: ORACLE - Select SF_SF_GETKYJE(5584770) KYYE00 from dual 141 16:30:55 SQL Execute: ORACLE - SELECT COUNT(1) GHCS00 FROM SF_BRXXB0 WHERE BRID00=5584770 AND GHY000=1513 AND GHRQ00=20241029 AND THBZ00<>'0' 142 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 143 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 144 16:30:55 SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=? AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 145 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 146 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=9000017743 147 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 148 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=7170 149 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 150 16:30:55 SQL Execute: ORACLE - Select BMMC00 from BM_YPBM00 Where YPNM00=6431 151 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 152 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 153 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 154 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 155 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 156 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 157 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 158 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 159 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 160 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 161 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 162 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 163 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 164 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 165 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 166 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 167 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 168 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 169 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 170 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 171 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 172 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 173 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 174 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 175 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 176 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 177 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 178 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 179 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 180 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 181 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 182 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 183 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 184 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 185 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 186 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 187 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 188 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 189 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 190 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 191 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 192 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 193 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 194 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 195 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 196 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 197 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 198 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 199 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 200 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 201 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 202 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 203 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 204 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 205 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 206 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 207 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 208 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 209 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 210 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 211 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 212 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 213 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 214 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 215 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 216 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 217 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 218 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 219 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 220 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 221 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 222 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 223 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 224 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 225 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 226 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 227 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 228 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 229 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 230 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 231 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 232 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 233 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 234 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 235 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 236 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 237 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 238 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=? 239 16:30:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7074432 240 16:30:55 SQL Execute: ORACLE - SELECT CFZT00 FROM YF_MZCF00 WHERE CFLSH0=?