1 11:15:38 SQL Execute: ORACLE - Select BMBH00,XKH000 from VW_XT_YHBMQX where UPPER(XKH000)='A9999' and BMBH00='431' 2 11:15:38 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='A9999' and CZBZ00<>'2' 3 11:15:38 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 4 11:15:38 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='A9999' and CZBZ00 in ('1') 5 11:15:38 SQL Execute: ORACLE - Commit 6 11:15:38 SQL Data In: ORACLE - Rows affected = 0 7 11:15:38 SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 8 11:15:38 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 9 11:15:38 SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 431.000000 10 11:15:38 SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 11 11:15:38 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 11:15:38 SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 13 11:15:38 SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 14 11:15:38 SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 15 11:15:38 SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 16 11:15:38 SQL Data In: ORACLE - Param = 10, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 11:15:38 SQL Data In: ORACLE - Param = 11, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 11:15:38 SQL Data In: ORACLE - Param = 12, Name = P_PYR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 19 11:15:38 SQL Data In: ORACLE - Param = 13, Name = P_SHBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 20 11:15:38 SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_PYR000 => :P_PYR000,P_SHBZ00 => :P_SHBZ00); END; 21 11:15:39 SQL Execute: ORACLE - UPDATE YF_KSJY00 SET BZ0000='1064195' WHERE JYDH00='' 22 11:15:39 SQL Data In: ORACLE - Rows affected = 0 23 11:15:39 SQL Execute: ORACLE - commit 24 11:15:39 SQL Data In: ORACLE - Rows affected = 0 25 11:15:44 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 26 11:15:47 SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00, C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00, K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00, C.CKDH00,K.QRSJ00, X.GZDJ00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL) GWYPFL, SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X WHERE C.CKDH00 ='1064195' AND C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00 AND C.YPNM00=X.YPNM00 AND X.YFBMBH=45 GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,D.Lbbh00,SF_YF_GWGZDJFL(X.GZDJ00,D.GWYPFL), C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000, C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00 ,C.CKDH00,K.QRSJ00 ORDER BY D.DXSYBZ,X.GZDJ00,GWYPFL,D.JXBH00,D.YLBH00,D.YPBM00,D.Lbbh00 27 11:15:47 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 28 11:15:47 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 29 11:15:47 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 30 11:15:47 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 31 11:15:47 SQL Execute: ORACLE - SELECT COUNT(1) as Counter FROM YF_YZYPSQ WHERE BQBMBH=431 AND YFBMBH=45 AND QLZT00 IN ('0','1') AND CXBZ00='Z' AND THBZ00='0' 32 11:15:47 SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='1' WHERE YFBMBH=45 AND BQBMBH=431 33 11:15:47 SQL Data In: ORACLE - Rows affected = 1 34 11:15:47 SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='0' WHERE YFBMBH=45 AND BQBMBH=431 AND QLZT00 IN ('0','1') AND FYBZ00 <>'0' 35 11:15:47 SQL Data In: ORACLE - Rows affected = 10 36 11:15:47 SQL Execute: ORACLE - COMMIT 37 11:15:47 SQL Data In: ORACLE - Rows affected = 0 38 11:15:47 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' and B.CZBZ00<>'2' ORDER BY B.BH0000 39 11:15:54 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)