1       16:48:16  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.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00,C.DMCFBH,
(select substrb(SF_BQ_CSRQTONL(C.CSRQ00),1,100) from dual) BRNL00,C.YEXM00 
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20210713' AND C.SRRQ00<='20210720'
 and ((C.SFKSLY='-1') or ('-1'='-1')) 
 AND C.YFBMBH=479
 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

2       16:48:17  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 648816
3       16:48:17  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
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N' 


4       16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415182) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415182) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415182) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415182'
 and X.ZYID00='717900'
 order by X.ZYID00 desc

5       16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19870621) AS NL FROM DUAL

6       16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415182) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415182) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415182) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415182'
 and X.ZYID00='717900'
 order by X.ZYID00 desc

7       16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19870621) AS NL FROM DUAL

8       16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415281) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415281) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415281) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415281'
 and X.ZYID00='717950'
 order by X.ZYID00 desc

9       16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19940612) AS NL FROM DUAL

10      16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415281) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415281) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415281) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415281'
 and X.ZYID00='717950'
 order by X.ZYID00 desc

11      16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19940612) AS NL FROM DUAL

12      16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415281) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415281) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415281) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415281'
 and X.ZYID00='717950'
 order by X.ZYID00 desc

13      16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19940612) AS NL FROM DUAL

14      16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415182) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415182) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415182) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415182'
 and X.ZYID00='717900'
 order by X.ZYID00 desc

15      16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19870621) AS NL FROM DUAL

16      16:48:17  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 648816
17      16:48:17  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
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N' 


18      16:48:17  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=3415182) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=3415182) BRLXXM,
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=3415182) LXRSFZ,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='3415182'
 and X.ZYID00='717900'
 order by X.ZYID00 desc

19      16:48:17  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19870621) AS NL FROM DUAL

20      16:48:17  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 648816
21      16:48:17  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
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N' 


22      16:48:44  Log started for: SQL Navigator for Oracle