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

2       17:49:13  SQL Execute: ORACLE - select SF_BQ_CXQSJJY(32582766,3113) MSG000 from dual 

3       17:49:14  SQL Execute: ORACLE - select SF_YJ_PACK_XMCXTS_MTYW(32582766) ZT0000 from dual

4       17:49:14  SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32582766.000000
5       17:49:14  SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
6       17:49:14  SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2364.000000
7       17:49:14  SQL Data In: ORACLE - Param = 4, Name = PSFZJTF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
8       17:49:14  SQL Data In: ORACLE - Param = 5, Name = PCXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
9       17:49:14  SQL Execute: ORACLE - BEGIN "SP_YJ_YWCX00" (PYJDJH0 => :PYJDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PSFZJTF => :PSFZJTF,PCXSL00 => :PCXSL00); END;
10      17:49:14  SQL Execute: ORACLE - Commit

11      17:49:14  SQL Data In: ORACLE - Rows affected = 0
12      17:49:14  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795217.000000
13      17:49:14  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230919
14      17:49:14  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:31:35
15      17:49:14  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795217.000000
16      17:49:14  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20078651.000000
17      17:49:14  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230919
18      17:49:14  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:31:35
19      17:49:14  SQL Execute: ORACLE - select b.djh000 from zy_fymx00 a,zy_brfy00 b where a.djh000=b.djh000 and b.zyid00=? and b.czrq00=? and b.czsj00=? and FLAG00='7' and DJID00 in 
(select id0000 From BQ_JZXM00 where zyid00=? and yzmxid =? and  LRRQ00=? and LRSJ00=? and CLBZ00='1' and XMLB00='3') 

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

21      17:49:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32582768.000000
22      17:49:16  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000 
from yj_ywmx00  
where yjdjh0=?

23      17:49:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 409473      
24      17:49:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3113.000000
25      17:49:16  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3113.000000
26      17:49:16  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3113.000000
27      17:49:16  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230919
28      17:49:16  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230919
29      17:49:16  SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,
XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,CXSL00,
DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,
KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,
APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,
ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,
YPNM00,JGZCBZ,DCBZ00,TQPC00,CXDJH0,ZJE000,YJLRBZ,
BZ0000,KDBQ00,CH0000,NL0000,BQSFBZ,YYID00,decode(YYID00,0,' ','ÒÑÔ¤Ô¼') YYBZ00,
(select czyxm0 from zy_brfy00 m where b.sfdjh0=m.djh000) czyxm0  from VW_BQ_YJYW00 b
where xmzt00 not in('7') and ZYHGHH=?
 and yjlrbz='N' 
 and (kdksbh  in (select  ksh000 from bm_bqks00 where bqh000=?) or b.KDBQ00=?) 
 and zlxmid<>0 
 and (  (yjksbh =0) 
  or ZLXMID in (Select ZLXMID FROM BQ_HZYZXMST ) 
  or not exists(select ' 1 ' from bm_bmbm00 m where m.bmbh00 = b.yjksbh and m.bmxz00 = ' 5 ' and b.xmzt00 in (' 3 ', ' 4 '))) 
 and  xmzt00<>'6' and SL0000-nvl(CXSL00,0)>0
and ((not exists (select '1' from YJ_YW0000 a Where a.yjdjh0=b.yjdjh0 and (a.XMZT00 in ('3','4') or a.ZXSL00>0)  and a.YJKSBH not in (select ksh000 from bm_bqks00 where (bqh000=? or nvl(b.ybqh00,'0')>0))) 
  or ZLXMID in (Select ZLXMID FROM BQ_HZYZXMST ) ))
 and kdrq00 between ? and  ?
 order by yjdjh0

30      17:49:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32582766.000000
31      17:49:16  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000 
from yj_ywmx00  
where yjdjh0=?

32      17:49:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 32582768.000000
33      17:49:16  SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000 
from yj_ywmx00  
where yjdjh0=?