1       09:17:51  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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',65,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1150,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1150 AND b.JSKSBH = '65')
  AND (INSTR (',' || a.jsksbh || ',',',65,') > 0 or a.jsksbh is null)  

2       09:17:52  SQL Execute: ORACLE - select 1 from zY_brxxb0 where substr(brzt00,1,1)='2' and zyh000='1708633'
 and dqks00 = 65 or dqbq00 = 65

3       09:17:52  SQL Data In: ORACLE - Param = 1, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20000177.000000
4       09:17:52  SQL Data In: ORACLE - Param = 2, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171030
5       09:17:52  SQL Data In: ORACLE - Param = 3, Name = P_QYSJ00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 09:17
6       09:17:52  SQL Data In: ORACLE - Param = 4, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:17:42
7       09:17:52  SQL Data In: ORACLE - Param = 5, Name = P_LRRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = Ò×ÁªÖÚ
8       09:17:52  SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
9       09:17:52  SQL Data In: ORACLE - Param = 7, Name = V_KCBZYP, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      09:17:52  SQL Data In: ORACLE - Param = 8, Name = P_ZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1708633
11      09:17:52  SQL Data In: ORACLE - Param = 9, Name = p_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000
12      09:17:52  SQL Execute: ORACLE - BEGIN "SP_ZS_YPYZFZ" (P_YZID00 => :P_YZID00,P_QYRQ00 => :P_QYRQ00,P_QYSJ00 => :P_QYSJ00,P_PXSJ00 => :P_PXSJ00,P_LRRXM0 => :P_LRRXM0,V_ERROR0 => :V_ERROR0,V_KCBZYP => :V_KCBZYP,P_ZYH000 => :P_ZYH000,p_CZY000 => :p_CZY000); END;
13      09:17:52  SQL Data In: ORACLE - Param = 1, Name = V_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2675381.000000
14      09:17:52  SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
15      09:17:52  SQL Data In: ORACLE - Param = 3, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
16      09:17:52  SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
17      09:17:52  SQL Data In: ORACLE - Param = 5, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
18      09:17:52  SQL Data In: ORACLE - Param = 6, Name = V_KDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000
19      09:17:52  SQL Execute: ORACLE - BEGIN "SP_ZS_YJTSXZ" (V_ZYID00 => :V_ZYID00,V_YJDJH0 => :V_YJDJH0,V_FLAG00 => :V_FLAG00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_KDYS00 => :V_KDYS00); END;
20      09:17:52  SQL Data In: ORACLE - Param = 1, Name = V_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2675381.000000
21      09:17:52  SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
22      09:17:52  SQL Data In: ORACLE - Param = 3, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
23      09:17:52  SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
24      09:17:52  SQL Data In: ORACLE - Param = 5, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
25      09:17:52  SQL Data In: ORACLE - Param = 6, Name = V_KDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1150.000000
26      09:17:52  SQL Execute: ORACLE - BEGIN "SP_ZS_YJTSXZ" (V_ZYID00 => :V_ZYID00,V_YJDJH0 => :V_YJDJH0,V_FLAG00 => :V_FLAG00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_KDYS00 => :V_KDYS00); END;
27      09:17:52  SQL Execute: ORACLE - Commit

28      09:17:52  SQL Data In: ORACLE - Rows affected = 0
29      09:17:52  SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 2675381
and CLBZ00 = '0'
and (YZZT00 in ('7','0','1','2','5','9','7') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD')))
order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID