1       10:44:27  SQL Execute: ORACLE -  select A.*,0 flag00,substrb(SF_ZY_RQDXX0(a.zyid00,a.QDH000,null),1,200) qdfjxx from  VW_BQ_RQD000 A where  1 = 1 
 and  A.RYBQ00+0=1832 and  A.ZYH000    = '494934' and  A.CZRQ00 >= '20231007' and  A.CZRQ00 <  '20231008'
 order by rycwh0,qdh000

2       10:44:27  SQL Execute: ORACLE -  select * from VW_BQ_RQDMX0  where QDH000 = '20231007'
 and  zyh000 = '494934' and zyid00=921547

3       10:44:27  SQL Execute: ORACLE -  select * from VW_BQ_QDXXXX  where QDH000 = '20231007'
 and  zyh000 = '494934'

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

5       10:44:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
6       10:44:28  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
7       10:44:28  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
8       10:44:28  SQL Execute: ORACLE -  select SF_ZY_DBZBRJYXZ(?,?,?)FHJG00 from dual

9       10:44:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
10      10:44:28  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
11      10:44:28  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
12      10:44:28  SQL Execute: ORACLE -  select SF_BQ_DBZBRDYXZ(?,?,?)FHJG00 from dual

13      10:44:28  SQL Execute: ORACLE -  select max(QDH000) QDH000,max(zyid00) zyid00,max(xm0000) xm0000,max(zyh000)zyh000,max(czrq00)czrq00,max(rybqmc)rybqmc,max(rycwh0)rycwh0,max(rzksmc)rzksmc,sum(hjje00) hjje00,sum(zfje00) zfje00 from  VW_BQ_RQD000  where  QDH000 BETWEEN '20231007'
 AND '20231007'
 and  ZYH000 = '494934'

14      10:44:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
15      10:44:28  SQL Execute: ORACLE -  select NVL(sum(JFJE00),0) JE0000 from VW_BQ_BRYJJE where ZYID00 =? and JFRQ00='20231007'

16      10:44:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
17      10:44:28  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
18      10:44:28  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 921547.000000
19      10:44:28  SQL Execute: ORACLE - select brye00 from zy_brfy00 where djh000=(select max(djh000) from zy_brfy00 where ZYID00 =? and czrq00='20231007') union all
select sum(jfje00) from VW_BQ_BRYJJE where ZYID00 =? and jfrq00='20231007' and jfsj00>(select czsj00 from zy_brfy00 where djh000=(select max(djh000) from zy_brfy00 where ZYID00 =? and czrq00='20231007'))

20      10:44:28  SQL Execute: ORACLE - select * from ( 
 select xmmc00,xmdj00,sum(xmsl00)xmsl00,xmgg00,xmdw00,sum(hjje00)hjje00,bh0000,xmbh00,ZFBL00 
 from VW_BQ_RQDMX0  where QDH000 BETWEEN '20231007'
 AND '20231007'
 and  ZYH000 = '494934' and zyid00=921547
 group by  xmmc00,xmdj00,xmdw00,bh0000,xmbh00,xmgg00,ZFBL00
) where xmsl00<>0 order  by  BH0000

21      10:44:28  SQL Execute: ORACLE -  SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='BQ_RQDGSCS'