1       08:54:33  SQL Execute: ORACLE - SELECT C.CFLSH0,C.ZYH000,C.BRXM00,C.XB0000,C.CH0000,
C.CSRQ00,C.YSXM00,C.ZYTS00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,
C.DJH000,C.FYRQ00,C.FYSJ00,C.BZMC00,C.BRDZ00,G.ZWXM00 AS LRY000,
H.ZWXM00 AS FYR000,C.LYDH00,F.FBMC00,C.YEXM00,c.BYJXX0
 FROM YF_ZYCF00 C,BM_YGBM00 G,BM_YGBM00 H,VW_YF_ZYBRZH F
 WHERE C.YFBMBH+0=670
 AND C.FYRQ00>='20200702'
 AND C.FYRQ00<='20200703'
 AND C.CFZT00 in('2','5','6')
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00
 AND C.FYR000=H.YGBH00
 AND C.BRID00=F.BRID00
 AND C.ZYID00=F.ZYID00
 ORDER BY C.CFLSH0

2       08:54:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402620
3       08:54:34  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


4       08:54:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402620
5       08:54:34  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


6       08:54:34  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402621
7       08:54:34  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


8       08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402626
9       08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


10      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402627
11      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


12      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402628
13      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


14      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402630
15      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


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


18      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402632
19      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


20      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402633
21      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


22      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402634
23      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


24      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402635
25      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


26      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402636
27      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


28      08:54:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402637
29      08:54:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


30      08:54:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402638
31      08:54:36  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


32      08:54:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402639
33      08:54:36  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


34      08:54:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402643
35      08:54:36  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


36      08:54:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402645
37      08:54:37  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


38      08:54:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402648
39      08:54:37  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


40      08:54:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402639
41      08:54:37  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


42      08:54:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402620
43      08:54:44  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


44      08:54:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402639
45      08:54:44  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


46      08:54:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402639
47      08:54:44  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


48      08:54:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1402704
49      08:54:46  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,CXBZ00,
  YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
  YYSJ00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,HSKPPH,
  ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


50      08:54:47  SQL Execute: ORACLE - SELECT (select ZWXM00 from BM_YGBM00 where YGBH00=a.LYR000) LYRXM0 FROM YF_ZYCF00 a WHERE CFLSH0='1402704'

51      08:54:47  SQL Execute: ORACLE - SELECT (select sum(count(1)) from YF_ZYCFMX WHERE CFLSH0='1402704'
 group by CFLSH0)  Rec,
C.CFLSH0,C.ZYH000,C.CH0000,C.BRXM00,C.XB0000,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,M.ZWXM00 FHR000,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.ZYDJS0,
C.DJH000,C.FYRQ00,C.FYSJ00,
(SELECT M.BMMC00 FROM BM_BMBM00 M WHERE M.BMBH00=C.DQBQ00) SZBQ00,
C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,C.FJFDJH,
(SELECT SF_YF_GETZYZD0(ZYID00) FROM YF_ZYCF00 WHERE CFLSH0='1402704') as RYZD00,
X.YPMC00,X.YPGG00,
X.PCMC00,
X.LSDJ00,X.YPZSL0,X.CFDW00,X.YBLB00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC) as YYFF00,
TRIM(X.YYSJ00)||TRIM(X.YYSJDW) AS YYTS00,X.ZB0000,
SF_YF_EXROUND(YPZSL0*LSDJ00,0,2) AS C_YPJE
 FROM BM_YGBM00 M,YF_ZYCF00 C,o X
 WHERE C.CFLSH0=X.CFLSH0 AND C.CFLSH0='1402704'
 AND C.FHR000=M.YGBH00(+) ORDER BY X.ZB0000,X.CFID00

52      08:54:47  SQL Error: ORACLE - ORA-00942: 表或视图不存在

53      08:54:47  SQL Data In: ORACLE - Rows affected = 0