select ssbh00,ssqsrq,ssqssj,ssmc00,SSYSXM,MZMC00,QKDJMC,MZYSXM,IYSMC0,IIYSMC,SSDJMC,ssdj00 from (
 select distinct SSM000 ssbh00,ssrq00 ssqsrq,sssj00 ssqssj,SF_ZS_ZDMCFWBW_DZBL(FWMC00,BWMC00,SSMC00,BCSM00)  ssmc00,SSYSMC SSYSXM, 
 nvl(MZFS00,'！') MZMC00,nvl(QKYHDJ,'！') QKDJMC,nvl(MZYSMC,'！') MZYSXM,nvl(IYSMC0,'！') IYSMC0,nvl(IIYSMC,'！') IIYSMC,sszl00 SSDJMC ,
 (select  decode(SSDJBH,'0','4','1','3','2','2','3','1') from BM_SSDJ00  where SSDJMC=sszl00)ssdj00 ,ssxh00 from Ba_Brssxx 
  WHERE LSH000 = 1103133 union all select null ,null,null,null,null,null,null,null,null,null,null,null,null from bm_yd0000
   where rownum<=11) where rownum<=8 order by  ssqsrq ,ssqssj,ssxh00