1       17:16:27  SQL Execute: ORACLE - Select BMBH00,XKH000 from VW_XT_YHBMQX where 
  UPPER(XKH000)='A9999' and BMBH00='65'

2       17:16:27  SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='A9999'
 and CZBZ00<>'2'

3       17:16:27  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

4       17:16:27  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='A9999' and CZBZ00 in ('1') 

5       17:16:27  SQL Execute: ORACLE - Commit

6       17:16:27  SQL Data In: ORACLE - Rows affected = 0
7       17:16:27  SQL Execute: ORACLE - UPDATE YF_ZYCF00 SET LYR000=369
 WHERE CFLSH0='2035540'

8       17:16:27  SQL Data In: ORACLE - Rows affected = 1
9       17:16:27  SQL Data In: ORACLE - Param = 1, Name = P_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2035540
10      17:16:27  SQL Data In: ORACLE - Param = 2, Name = P_CFJSZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
11      17:16:27  SQL Data In: ORACLE - Param = 3, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
12      17:16:27  SQL Data In: ORACLE - Param = 4, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
13      17:16:27  SQL Data In: ORACLE - Param = 5, Name = P_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
14      17:16:27  SQL Data In: ORACLE - Param = 6, Name = P_BYJFY0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
15      17:16:27  SQL Execute: ORACLE - BEGIN "SP_YF_ZYCFCL" (P_CFLSH0 => :P_CFLSH0,P_CFJSZT => :P_CFJSZT,P_YFBMBH => :P_YFBMBH,P_CZYBH0 => :P_CZYBH0,P_DJH000 => :P_DJH000,P_BYJFY0 => :P_BYJFY0); END;
16      17:16: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 = '2') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 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 = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

17      17:16:28  SQL Execute: ORACLE - select CFZT00 from YF_ZYCF00 where CFLSH0='2035540'

18      17:16:30  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=c.brid00) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=c.brid00) LXRSFZ,
C.CFLSH0,C.ZYH000,C.CH0000,C.DQKS00,C.BRID00,C.CSRQ00,C.YSXM00,
C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,substr(SF_YF_GETALLZYZD(C.ZYID00,c.CFLSH0),1,127) RYZD00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00,C.DMCFBH,
(select a.XM0000 from ZY_BRXXB0 a where a.BRID00=c.BRID00 and a.ZYID00=C.ZYID00 and rownum=1) BRXM00,
(select a.XB0000 from ZY_BRXXB0 a where a.BRID00=c.BRID00 and a.ZYID00=C.ZYID00 and rownum=1) XB0000,
(select substrb(SF_BQ_CSRQTONL(a.CSRQ00,a.SJRYRQ),1,30) from ZY_BRXXB0 a where a.BRID00=c.BRID00 and a.ZYID00=C.ZYID00 and rownum=1)  BRNL00,
C.YEXM00,C.LYKS00 
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20220201' AND C.SRRQ00<='20220228'
 AND C.DQBQ00=65
 and ((C.SFKSLY='-1') or ('-1'='-1')) 
 AND C.YFBMBH=45
 AND ((C.CFZT00 in ('0')
 AND C.BCCFH0 IS NULL)
 OR (C.CFZT00 in ('1') AND BCCFH0 IS NULL 
 AND NOT EXISTS (SELECT 1 FROM YF_ZYCF00 D WHERE  C.CFLSH0=D.BCCFH0 AND C.ZYID00=D.ZYID00 AND CFZT00 in ('0','1') )))
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00

19      17:16:30  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2035540         
20      17:16:30  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000,YPNM00
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'