1       11:00:35  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 = '4') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 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 = '44')
  AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)  

2       11:00:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
3       11:00:36  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5459089.000000
4       11:00:36  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32050366.000000
5       11:00:36  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
6       11:00:36  SQL Execute: ORACLE - select SF_SF_GETYWLSH0(?,?,?,?) AS  FHXX00 from dual 

7       11:00:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5459089.000000
8       11:00:36  SQL Execute: ORACLE -  select tyje01 from VW_SF_BRZHXX where brid00= ?

9       11:00:36  SQL Execute: ORACLE - select * from  VW_SF_YJYW00 where   CXDJH0  is  null  and  SFDJH0+0 = 0 and XMZT00 = '1'
 and  BRID00 = 5459089
 and  YJDJH0  not in ( 0 ) 
 and  GHH000 = '15919021'

10      11:00:36  SQL Execute: ORACLE -  select  SQ_SF_BRJFB0_DJH000.nextval  DJH000   from dual 

11      11:00:36  SQL Data In: ORACLE - Param = 1, Name = ad_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5459089.000000
12      11:00:36  SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35510394.000000
13      11:00:36  SQL Data In: ORACLE - Param = 3, Name = AD_JE0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
14      11:00:36  SQL Data In: ORACLE - Param = 4, Name = ad_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
15      11:00:36  SQL Data In: ORACLE - Param = 5, Name = AS_BZ0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
16      11:00:36  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
17      11:00:36  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
18      11:00:36  SQL Execute: ORACLE - BEGIN "SP_SF_YJCF00_QZFJE0" (ad_BRID00 => :ad_BRID00,AD_ID0000 => :AD_ID0000,AD_JE0000 => :AD_JE0000,ad_JZJE00 => :ad_JZJE00,AS_BZ0000 => :AS_BZ0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
19      11:00:36  SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 12955515        
20      11:00:36  SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 86148696.000000
21      11:00:36  SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000
22      11:00:36  SQL Data In: ORACLE - Param = 4, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
23      11:00:36  SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
24      11:00:36  SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
25      11:00:36  SQL Data In: ORACLE - Param = 7, Name = AS_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
26      11:00:36  SQL Data In: ORACLE - Param = 8, Name = AS_ZYDJQT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
27      11:00:36  SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AS_SFQZF0 => :AS_SFQZF0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CZY000 => :AS_CZY000,AS_ZYDJQT => :AS_ZYDJQT); END;