1 08:38:48 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 2 08:38:49 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160622 3 08:38:49 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160630 4 08:38:49 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5 08:38:49 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 6 08:38:49 SQL Data In: ORACLE - Param = 5, Name = AS_YSYGBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 7 08:38:49 SQL Data In: ORACLE - Param = 6, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 8 08:38:49 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_YSYGBH => :AS_YSYGBH,AS_YYID00 => :AS_YYID00); END; 9 08:39:27 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 10 08:39:28 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 11 08:39:38 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 12 08:39:48 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 13 08:39:58 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 14 08:40:08 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 15 08:40:18 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 16 08:40:28 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 17 08:40:38 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null)