1       16:05:38  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

2       16:05:38  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

3       16:05:40  SQL Prepare: 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||',', ',422,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1085,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1085 AND b.JSKSBH = '422')
  AND (INSTR (',' || a.jsksbh || ',',',422,') > 0 or a.jsksbh is null)  

4       16:05:40  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||',', ',422,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1085,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1085 AND b.JSKSBH = '422')
  AND (INSTR (',' || a.jsksbh || ',',',422,') > 0 or a.jsksbh is null)  

5       16:05:42  SQL Prepare: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='2300'
 and CZBZ00<>'2' and BMBH00='57'

6       16:05:42  SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='2300'
 and CZBZ00<>'2' and BMBH00='57'

7       16:05:42  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

8       16:05:42  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

9       16:05:42  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00 in ('1') 

10      16:05:42  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00 in ('1') 

11      16:05:42  SQL Prepare: ORACLE - Commit

12      16:05:42  SQL Execute: ORACLE - Commit

13      16:05:42  SQL Data In: ORACLE - Rows affected = 0
14      16:05:42  SQL Prepare: 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_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END;
15      16:05:42  SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
16      16:05:42  SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 422.000000
17      16:05:42  SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
18      16:05:42  SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1575363.000000
19      16:05:42  SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
20      16:05:42  SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
21      16:05:42  SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1085.000000
22      16:05:42  SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1662.000000
23      16:05:42  SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
24      16:05:42  SQL Data In: ORACLE - Param = 10, Name = P_BYFHR0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
25      16:05:42  SQL Data In: ORACLE - Param = 11, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
26      16:05:42  SQL Data In: ORACLE - Param = 12, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
27      16:05:42  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_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END;