SELECT A.CFID00,
       A.CFLSH0,
       A.YPMC00,
       A.YPGG00,
       A.LSDJ00,
       b.FCSL00 YPZSL0,
       a.CFDW00,
       DECODE(SUBSTR(CSL000, 1, 1), '.', '0', '') || CSL000 || JLDW00 AS DJL000,
       PCMC00,
       CXBZ00,
       YFSMMC || YPYFMC || ZJYFMC || XMYFMC as YYFF00,
       YYSJ00 || YYSJDW AS YYTS00,
       YPSCCJ,
       nvl(B.KPHSS0, nvl(B.FCSL00, A.YPZSL0)) KPHSS0,
       nvl(B.HSKPPH,
           nvl(A.HSKPPH,
               (select i.scph00 from yk_yprkmx i where i.yprkpc = B.ykrkpc))) as HSKPPH,
       b.FCSL00 - JYSL00 SJSL00,
       nvl(B.HSKPRQ, nvl(a.HSKPRQ, c.FYRQ00)) as HSKPRQ,
       (select i.scph00
          from yk_yprkmx i
         where i.ypnm00 = b.ypnm00
           and i.yprkpc = b.ykrkpc) as YPSCPH,
       nvl(b.KPHSR0, a.KPHSR0) KPHSR0,
       (select zwxm00
          from bm_ygbm00
         where ygbh00 = nvl(b.KPHSR0, C.FYR000)
           and rownum = 1) KPHSRM,
       c.FYR000,
       B.MXZLSH
  FROM YF_MZCFMX a, YF_YPMXZ0 b, YF_MZCF00 c
 WHERE a.CFLSH0 = '47577736'
   and a.CFLSH0 = B.DJH000
   and A.YPNM00 = B.YPNM00
   and a.CFLSH0 = c.CFLSH0
   and a.SFZBY0 = 'N'
   and B.RCLXBH = '09'
 ORDER BY ZB0000