SELECT *
  FROM (select ypmc00,
               wbsm00,
               ypgg00,
               ypbm00,
               pysm00,
               scph00,
               sjkcsl,
               spm000,
               ypnm00,
               kcdw00,
               k2j000,
               lsj000,
               z2j000,
               m2j000,
               gjj000,
               ykbmbh,
               ykrkpc,
               zyfydw
          from VW_YF_YPPCKCTS
         where 1 = 1
           and YFBMBH = 2275
           and YPNM00 in (select ypnm00
                            from yf_ypkcxx
                           where yfbmbh = 2275
                             and ZTBZ00 = '0')
           and (PYSM00 like '%mst%'))
 WHERE ROWNUM <= 100
