select a.*,b.ickh00,b.kmh000 from vw_ys_brxxb0_mzdzbl a,(select * from ic_yhxx00 where zt0000='1') b where rownum <= 2000 and  a.BRID00 = b.brid00(+)   and a.BRID00='5610356' 



select SF_SF_YYTCARDNO(5610356) kmh000 from dual