SELECT '1' NX,C.CFLSH0,C.GHH000,F.BRBLH0,C.BRXM00,F.BRDH00,C.XB0000,
(substr(SF_YF_CSRQTONL(C.CSRQ00,null),1,10)) 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=29
 AND C.FYRQ00>='20190902'
 AND C.FYRQ00<='20190902'
 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