1 11:15:12 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 2 11:15:12 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 3 11:15:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 4 11:15:14 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 5 11:15:16 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 6 11:15:17 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 7 11:15:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 8 11:15:19 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 9 11:15:21 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 10 11:15:21 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 11 11:15:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 12 11:15:23 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 13 11:15:25 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 14 11:15:25 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 15 11:15:27 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 16 11:15:27 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 17 11:15:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 18 11:15:29 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 19 11:15:31 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 20 11:15:31 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 21 11:15:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 22 11:15:33 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 23 11:15:35 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 24 11:15:35 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 25 11:15:37 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 26 11:15:37 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 27 11:15:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 28 11:15:38 SQL Execute: ORACLE - select * from VW_PY_MZCFMX where CFLSH0 = ? order by CFID00 29 11:15:38 SQL Execute: ORACLE - select GMS000 from ys_mzblws where GHH000 = '54199002' 30 11:15:38 SQL Execute: ORACLE - select SF_PY_GETMZBRTZXX(18488896) BRTZXX from dual 31 11:15:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 32 11:15:39 SQL Execute: ORACLE - select * from VW_PY_MZCFMX where CFLSH0 = ? order by CFID00 33 11:15:39 SQL Execute: ORACLE - select GMS000 from ys_mzblws where GHH000 = '54199002' 34 11:15:39 SQL Execute: ORACLE - select SF_PY_GETMZBRTZXX(18488896) BRTZXX from dual 35 11:15:39 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'SFSSQZ_MZ' 36 11:15:39 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 37 11:15:39 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 38 11:15:39 SQL Data In: ORACLE - Param = 3, Name = PFLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 11:15:39 SQL Execute: ORACLE - BEGIN "SP_YF_MZFYZDFPZSM" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PFLAG00 => :PFLAG00); END; 40 11:15:39 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP' 41 11:15:39 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 42 11:15:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 43 11:15:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 44 11:15:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 45 11:15:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 46 11:15:39 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 47 11:15:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 48 11:15:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 49 11:15:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 50 11:15:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 51 11:15:39 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 52 11:15:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 53 11:15:39 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 = ? ) AND X.GHKS00=B.BMBH00 54 11:15:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 55 11:15:39 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 56 11:15:41 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 57 11:15:41 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 58 11:15:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 59 11:15:43 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 60 11:15:45 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 61 11:15:45 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 62 11:15:47 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 63 11:15:47 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 64 11:15:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 65 11:15:49 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 66 11:15:51 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 67 11:15:51 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 68 11:15:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 11:15:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 11:15:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 71 11:15:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 72 11:15:51 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 73 11:15:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 74 11:15:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 75 11:15:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 76 11:15:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 77 11:15:51 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 78 11:15:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 79 11:15:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 80 11:15:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 81 11:15:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 82 11:15:51 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 83 11:15:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 84 11:15:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 85 11:15:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 86 11:15:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257812.000000 87 11:15:51 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 88 11:15:51 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 83603740294451505167 89 11:15:51 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 90 11:15:51 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 91 11:15:51 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 92 11:15:51 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 93 11:15:51 SQL Data In: ORACLE - Rows affected = 1 94 11:15:51 SQL Execute: ORACLE - COMMIT WORK 95 11:15:51 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 96 11:15:51 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 97 11:15:51 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 98 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 99 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 100 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 101 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 102 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 103 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 106 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 107 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 108 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 109 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 110 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 111 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 112 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 113 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 114 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 115 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 116 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257812.000000 117 11:15:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 118 11:15:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 83603740294451351227 119 11:15:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 120 11:15:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 121 11:15:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 122 11:15:52 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 123 11:15:52 SQL Data In: ORACLE - Rows affected = 1 124 11:15:52 SQL Execute: ORACLE - COMMIT WORK 125 11:15:52 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 126 11:15:52 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 127 11:15:52 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 128 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 129 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 130 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 131 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 132 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 133 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 134 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 135 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 136 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 137 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 138 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 139 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 140 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 141 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 142 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 143 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 144 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 145 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 146 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257812.000000 147 11:15:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 148 11:15:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 83603740294452404929 149 11:15:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 150 11:15:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 151 11:15:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 152 11:15:52 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 153 11:15:52 SQL Data In: ORACLE - Rows affected = 1 154 11:15:52 SQL Execute: ORACLE - COMMIT WORK 155 11:15:52 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 156 11:15:52 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 157 11:15:52 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 158 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 159 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 160 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 161 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 162 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 163 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 164 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 165 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 166 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 167 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 168 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 169 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 170 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 171 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 172 11:15:52 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 173 11:15:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 174 11:15:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 175 11:15:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 176 11:15:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257812.000000 177 11:15:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 178 11:15:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 83603740294452708694 179 11:15:52 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 180 11:15:52 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 181 11:15:52 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 182 11:15:52 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 183 11:15:52 SQL Data In: ORACLE - Rows affected = 1 184 11:15:52 SQL Execute: ORACLE - COMMIT WORK 185 11:15:52 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 186 11:15:52 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 187 11:15:52 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 188 11:15:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 189 11:15:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 190 11:15:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 191 11:15:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 192 11:15:53 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 193 11:15:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 194 11:15:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 195 11:15:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 196 11:15:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 197 11:15:53 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 198 11:15:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 199 11:15:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 200 11:15:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 201 11:15:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 202 11:15:53 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 203 11:15:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 204 11:15:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 205 11:15:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 206 11:15:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257812.000000 207 11:15:53 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 208 11:15:53 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 83603740294452558677 209 11:15:53 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 210 11:15:53 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 211 11:15:53 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 212 11:15:53 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 213 11:15:53 SQL Data In: ORACLE - Rows affected = 1 214 11:15:53 SQL Execute: ORACLE - COMMIT WORK 215 11:15:53 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 216 11:15:53 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 217 11:15:53 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 218 11:15:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 219 11:15:53 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 220 11:15:55 SQL Execute: ORACLE - select SF_XT_GETYHTZXHLIST(1901,29) as XHLIST from dual 221 11:15:55 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (-1) 222 11:15:55 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 223 11:15:55 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 224 11:15:57 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 225 11:15:57 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 226 11:15:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 227 11:15:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 228 11:15:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 229 11:15:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016033.000000 230 11:15:59 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 231 11:15:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 232 11:15:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 233 11:15:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 234 11:15:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 235 11:15:59 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 236 11:15:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 237 11:15:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 238 11:15:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 239 11:15:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 240 11:15:59 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 241 11:15:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 242 11:15:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 243 11:15:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 244 11:15:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257811.000000 245 11:15:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 246 11:15:59 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 84556710235092020762 247 11:15:59 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 248 11:15:59 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 249 11:15:59 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 250 11:15:59 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 251 11:15:59 SQL Data In: ORACLE - Rows affected = 1 252 11:15:59 SQL Execute: ORACLE - COMMIT WORK 253 11:15:59 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 254 11:15:59 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 255 11:15:59 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 256 11:15:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 257 11:15:59 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 258 11:16:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 259 11:16:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 260 11:16:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 261 11:16:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 262 11:16:00 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 263 11:16:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 264 11:16:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 265 11:16:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 266 11:16:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 267 11:16:00 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 268 11:16:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 269 11:16:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 270 11:16:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 271 11:16:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 272 11:16:00 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 273 11:16:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 274 11:16:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 275 11:16:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 276 11:16:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257810.000000 277 11:16:00 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 278 11:16:00 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 84009508533492957506 279 11:16:00 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 280 11:16:00 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 281 11:16:00 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 282 11:16:00 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 283 11:16:00 SQL Data In: ORACLE - Rows affected = 1 284 11:16:00 SQL Execute: ORACLE - COMMIT WORK 285 11:16:00 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 286 11:16:00 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 287 11:16:00 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 288 11:16:01 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 289 11:16:01 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 290 11:16:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 291 11:16:03 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 292 11:16:05 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 293 11:16:05 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 294 11:16:07 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 295 11:16:07 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 296 11:16:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 297 11:16:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 298 11:16:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 299 11:16:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 300 11:16:08 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 301 11:16:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 302 11:16:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 303 11:16:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 304 11:16:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 305 11:16:08 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 306 11:16:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 307 11:16:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 308 11:16:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 309 11:16:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 310 11:16:08 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 311 11:16:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 312 11:16:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 313 11:16:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 314 11:16:08 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257811.000000 315 11:16:08 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 316 11:16:08 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 84556710235106606326 317 11:16:08 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 318 11:16:08 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 319 11:16:08 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 320 11:16:08 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 321 11:16:08 SQL Data In: ORACLE - Rows affected = 1 322 11:16:08 SQL Execute: ORACLE - COMMIT WORK 323 11:16:08 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 324 11:16:08 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 325 11:16:08 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 326 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 327 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 328 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 329 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 330 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 331 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 332 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 333 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 334 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 335 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 336 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 337 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 338 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 339 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 340 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 341 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 342 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 343 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 344 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257814.000000 345 11:16:09 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 346 11:16:09 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 84186750163663681891 347 11:16:09 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 348 11:16:09 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 349 11:16:09 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 350 11:16:09 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 351 11:16:09 SQL Data In: ORACLE - Rows affected = 1 352 11:16:09 SQL Execute: ORACLE - COMMIT WORK 353 11:16:09 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 354 11:16:09 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 355 11:16:09 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 356 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 357 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 358 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 359 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 360 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 361 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 362 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 363 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 364 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 365 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 366 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 367 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 368 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 369 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 370 11:16:09 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 371 11:16:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 372 11:16:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 373 11:16:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 374 11:16:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57257814.000000 375 11:16:09 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016829.000000 376 11:16:09 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 84186750163664580553 377 11:16:09 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 378 11:16:09 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 379 11:16:09 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 380 11:16:09 SQL Execute: ORACLE - insert into YF_CFZSMX(ID0000,MZZYBZ,YZLB00,CFLSH0,YPQLPC,YPNM00,ZSM000,FYTYBZ,CZY000,SFLB00,YPZSL0,SFCLBZ) Values(SQ_YF_CFZSMX_ID0000.NEXTVAL,?,?,?,?,?,?,'0',?,'3',?,?) 381 11:16:09 SQL Data In: ORACLE - Rows affected = 1 382 11:16:09 SQL Execute: ORACLE - COMMIT WORK 383 11:16:09 SQL Execute: ORACLE - select * from BM_TYCJBM where XTDM00 = 'YBZSMJK' and SFQY00 = '1' and CJBM00 = 'SMJSSFGBTC' 384 11:16:09 SQL Execute: ORACLE - select 1 from VW_YF_ZSMCFMX where MZZYBZ='0' and ZSMSL1 > YSMSL0 and ( ZSMSL1 > 0 and PZBSM0 is not null ) and CFLSH0 in ('18488896') 385 11:16:09 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 386 11:16:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 387 11:16:09 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 388 11:16:11 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 389 11:16:11 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 390 11:16:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 391 11:16:13 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 392 11:16:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 393 11:16:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 394 11:16:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 395 11:16:14 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000016161.000000 396 11:16:14 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 397 11:16:15 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 398 11:16:15 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 399 11:16:15 SQL Data In: ORACLE - Param = 3, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 400 11:16:15 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1901 401 11:16:15 SQL Data In: ORACLE - Param = 5, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 402 11:16:15 SQL Data In: ORACLE - Param = 6, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 403 11:16:15 SQL Data In: ORACLE - Param = 7, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 404 11:16:15 SQL Data In: ORACLE - Param = 8, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 405 11:16:15 SQL Execute: ORACLE - BEGIN "SP_YF_YBZSRZ_EDIT" (POPFLAG => :POPFLAG,PMZZYBZ => :PMZZYBZ,PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 406 11:16:15 SQL Data In: ORACLE - Rows affected = 1 407 11:16:15 SQL Execute: ORACLE - update RCACCEPT set LZH000='202 , 271',CKH000='4' where CFLSH0='18488896' 408 11:16:15 SQL Data In: ORACLE - Rows affected = 1 409 11:16:15 SQL Execute: ORACLE - commit 410 11:16:15 SQL Data In: ORACLE - Rows affected = 0 411 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2016508 412 11:16:15 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000 = ? 413 11:16:15 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 414 11:16:15 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 415 11:16:15 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1901 416 11:16:15 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1901 417 11:16:15 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 29 418 11:16:15 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 419 11:16:15 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 420 11:16:15 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 421 11:16:15 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 422 11:16:15 SQL Data In: ORACLE - Param = 10, Name = PDKFYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 423 11:16:15 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PDKFYBZ => :PDKFYBZ); END; 424 11:16:15 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_YFBMBH' 425 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10487433 426 11:16:15 SQL Execute: ORACLE - select b.bmmc00,count(1) SL0000 from yf_mzcf00 a,bm_bmbm00 b where a.yfbmbh=b.bmbh00 and a.BRID00=? and a.CFZT00='1' and nvl(fyrq00,'20991231')='20991231' and a.jzrq00 >= to_char(sysdate-1,'YYYYMMDD') and a.CFZJE0>0 and not exists (select 1 from yf_mzcf00 where brid00=a.brid00 and jzrq00=a.jzrq00 and BCCFH0=a.cflsh0 and cfzje0<0) group by b.bmmc00 427 11:16:15 SQL Execute: ORACLE - commit 428 11:16:15 SQL Data In: ORACLE - Rows affected = 0 429 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 25, Scale = 0, Data = MZPY_SFBDYPRINTMZPY_FYBQ1 430 11:16:15 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 431 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = MZPY_CFDYPAHWHPX 432 11:16:15 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 433 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1901 434 11:16:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 435 11:16:15 SQL Execute: ORACLE - select dycs00,decode(dycs00,0,'',1,'(重制)','(重制第'||to_char(dycs00)||'次)')as dycz00,decode(nvl(SFCAQM,'0'),'1',(select DZQM00 from BM_ZJ0000 where YGBH00=?)) DZQM00 from yf_mzcf00 WHERE CFLSH0 = ? 436 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 437 11:16:15 SQL Execute: ORACLE - select a.* from VW_PY_BRCF00_MSQL a WHERE a.CFLSH0 = ? 438 11:16:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 439 11:16:15 SQL Execute: ORACLE - select substr(ypmc00,1,10)as ypmc00,a.* from VW_PY_BRCFMX_DSQL a WHERE a.CFLSH0 = ? order by CFID00 440 11:16:15 SQL Execute: ORACLE - select nvl(SF_PY_PYBZ00('18488896'),' ') as PYBZ00 from dual 441 11:16:15 SQL Execute: ORACLE - select '*' as BZ0000,' ' szs from dual 442 11:16:15 SQL Execute: ORACLE - select 1901 as UserId,'2016508' as UserCode,'陈秀雄' as UserName,29 as UserLogDepId,'门诊西药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'222285' as HospitalCode,'福建省福清市医院' as HospitalName, '222285' as UserLogDepYYID,'福清市医院' as UserLogDepYYMC from dual 443 11:16:15 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 444 11:16:15 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 445 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = MZPY_PYCFDYFYBQ 446 11:16:16 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 447 11:16:16 SQL Execute: ORACLE - select trim(MC0000) from BM_TYZD00 where ZDMC00 = '门诊配药_接收预配药_打印药签顺序' and BH0000 = '0' and rownum = 1 448 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 449 11:16:16 SQL Execute: ORACLE - select * from VW_PY_YPBQXX_DSQL WHERE CFLSH0 = ? 450 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 451 11:16:16 SQL Execute: ORACLE - select dycs00,decode(dycs00,0,'','重制') dycz00 from yf_mzcf00 WHERE CFLSH0 = ? 452 11:16:16 SQL Execute: ORACLE - select 1901 as UserId,'2016508' as UserCode,'陈秀雄' as UserName,29 as UserLogDepId,'门诊西药房' as UserLogDepName, 'R' as UserLogSysCode,'门诊药房配药系统' as UserLogSysName,'222285' as HospitalCode,'福建省福清市医院' as HospitalName, '222285' as UserLogDepYYID,'福清市医院' as UserLogDepYYMC from dual 453 11:16:16 SQL Execute: ORACLE - update YF_MZCF00 set CFBDCS = nvl(CFBDCS, 0) + 1,DYCS00=nvl(DYCS00, 0) + 1 where CFLSH0 = '18488896' 454 11:16:16 SQL Data In: ORACLE - Rows affected = 1 455 11:16:16 SQL Execute: ORACLE - commit 456 11:16:16 SQL Data In: ORACLE - Rows affected = 0 457 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:14:22 458 11:16:16 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20250416' and '20250416' and FYCKBH = 13 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 459 11:16:16 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250416' and '20250416' and FYCKBH = 13 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 460 11:16:16 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20250416' and '20250416' and FYCKBH = 13 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 461 11:16:16 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'SFSSQZ_MZ' 462 11:16:16 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 463 11:16:16 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1901.000000 464 11:16:16 SQL Data In: ORACLE - Param = 3, Name = PFLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 465 11:16:16 SQL Execute: ORACLE - BEGIN "SP_YF_MZFYZDFPZSM" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PFLAG00 => :PFLAG00); END; 466 11:16:16 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP' 467 11:16:16 SQL Execute: ORACLE - select A.* from VW_YF_ZSMCFMX A where a.MZZYBZ='0' and A.PZBSM0 is not null and A.CFLSH0 in ('18488896') order by A.ZB0000,A.CFID00 468 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 469 11:16:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 470 11:16:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 471 11:16:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 472 11:16:16 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 473 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 474 11:16:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 475 11:16:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 476 11:16:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2927.000000 477 11:16:16 SQL Execute: ORACLE - select A.*,nvl(A.YPZSL0,B.ZSMZHL)/C.ZHL000||C.CFDW00 ZSMSL0 from YF_CFZSMX A,BM_YD0000 B,YF_MZCFMX C where A.YPNM00 = B.YPNM00 AND A.CFLSH0 = C.CFLSH0 AND A.YPQLPC = C.CFID00 AND A.MZZYBZ = ? and A.YZLB00 = ? and A.CFLSH0 = ? and A.YPNM00 = ? 478 11:16:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 18488896 479 11:16:16 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 = ? ) AND X.GHKS00=B.BMBH00 480 11:16:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 481 11:16:18 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 482 11:16:20 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 483 11:16:20 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 484 11:16:22 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00 485 11:16:22 SQL Execute: ORACLE - select * from VW_PY_DYCFDL A where 1=1 and CFSRBZ <> '4' and JZRQ00 > to_char(sysdate - 3, 'YYYYMMDD') and ZT0000 in ('0') and YFBMBH=29 and PYCKBH = 201 order by decode(CFDGS0,'3',0,'4',0,'9',1,2), FYDLXH, DLXH00