1       09:19:40  SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,F.BRBLH0,C.BRXM00,F.BRDH00,C.XB0000,
C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,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,F.FBMC00,(SELECT DECODE(BRZJLX,'Ιν·έΦ€',BRZJBH,'') FROM 
 BM_BRXXB0 WHERE BRID00=C.BRID00) AS SFZBH0,nvl(c.CFDGS0,'5') CFDGS0,
(Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000 
 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F
 WHERE C.YFBMBH+0=133
 AND C.FYRQ00>='20210101'
 AND C.FYRQ00<='20210131'
 AND C.CFZT00 in('1','2','5','6')
 AND C.CFXZ00<>'0'
 AND C.GHKS00=M.BMBH00
 AND C.CZY000=G.YGBH00
 AND C.FYR000=H.YGBH00(+)
 AND C.BRID00=F.BRID00
 AND C.GHID00=F.GHID00
 ORDER BY C.CFLSH0

2       09:19:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190642
3       09:19:40  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,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX
WHERE  CFLSH0=? AND SFZBY0='N'
ORDER BY ZB0000

4       09:19:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190642
5       09:19:40  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,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX
WHERE  CFLSH0=? AND SFZBY0='N'
ORDER BY ZB0000

6       09:19:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190642
7       09:19:40  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,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX
WHERE  CFLSH0=? AND SFZBY0='N'
ORDER BY ZB0000

8       09:19:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190642
9       09:19:40  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,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX
WHERE  CFLSH0=? AND SFZBY0='N'
ORDER BY ZB0000

10      09:19:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190642
11      09:19:40  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,YPZSL0-JYSL00 SJSL00
FROM YF_MZCFMX
WHERE  CFLSH0=? AND SFZBY0='N'
ORDER BY ZB0000