SELECT X.ZYH000,X.XM0000,X.XB0000,X.RYCWH0,X.KYJE00,X.ZDMC00,X.SXYSXM,X.NL0000,X.BRZJBH,X.ICKH00,X.FBXX00,X.BRID00, 
substrb(SF_YF_GETZYBRZDXX(X.ZYID00,'1'),1,200) SYZDMC,(select max(ZDMC00) from BQ_YPYZ00 where YZID00=155009735) DMZD00, 
(select YSXM00 from VW_YF_ZYBYXX where YZID00=155009735 and rownum=1) KDYSXM 
 FROM  VW_YF_ZYBRXX X where X.ZYID00=5990865