1       11:36:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4151163.000000
2       11:36:24  SQL Execute: ORACLE -  select  a.*,b.sfxnh0  from  bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00= ?

3       11:36:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 777898.000000
4       11:36:26  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 862596.000000
5       11:36:26  SQL Execute: ORACLE -  select  max(YBDJH0) YBDJH0  from  zy_brfy00  where  zyid00= ? and JZDH00 = ?

6       11:36:26  SQL Data In: ORACLE - Param = 1, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 862596.000000
7       11:36:26  SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1245.000000
8       11:36:26  SQL Data In: ORACLE - Param = 3, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ³Âæ¥
9       11:36:26  SQL Data In: ORACLE - Param = 4, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      11:36:26  SQL Data In: ORACLE - Param = 5, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      11:36:26  SQL Execute: ORACLE - BEGIN "SP_ZY_ZYFYJS_CANCEL" (AD_JZDH00 => :AD_JZDH00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
12      11:36:28  SQL Execute: ORACLE - Commit

13      11:36:28  SQL Data In: ORACLE - Rows affected = 0
14      11:36: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 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',494,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1245
  AND b.JSKSBH = '494')
  AND (INSTR (',' || a.jsksbh || ',',',494,') > 0 or a.jsksbh is null)