Select *
  from (select ZLXMJC,
               ZLXMID,
               DW0000,
               ZLXMBH,
               PYSM00,
               WBSM00,
               BZ0000,
               SFJE00,
               ZFBL00,
               YBLBMC,
               BH0000,
               NBLBMC,
               NBZFBL,
               LBBH00,
               JCLBID,
               BWBH00,
               BWMC00,
               GGBZTS
          from VW_YS_YBFYYZ A
         where (PYSM00 Like '%')
           and (LBBH00 not in ('4') and ZLXMID not in (-1) and
               ((YBZXLB = '1' 
			   and YBBRLB = 'A' --新增的类别
			   and FBBH00 = '3') or
               (SFSFXM = 'N')) and (FYID00 = rpad('0', 6, ' ') or
               FYID00 = rpad('220045', 6, ' ')))
         Order By PYSM00)
 where Rownum <= 500