RYBF00, RYKBMC, DQBQ00, SJRYRQ, SJCYRQ, MZCYFH, RYRQ00, ZYH000, BRXM00, 
BRXB00, HYZK00, ZY0000, JTDZ00, CYRQ00, LXRDH0, JTDZ01, LXRDZ1, XX0000, 
BZ0000, BRLY00, SFZH00, HIVAB0, RYTSMS, SZYSXM, SXYSXM, RYCS00, ZRZYBZ



select (select BMMC00 from BM_BMBM00 where BMBH00=a.DQBQ00) RYBF00
      ,(select BMMC00 from BM_BMBM00 where BMBH00=a.DQKS00) RYKBMC
      ,a.DQBQ00
      ,a.SJRYRQ
      ,a.SJCYRQ
      ,a.RYCWH0 MZCYFH
      ,a.RYRQ00
      ,a.ZYH000
      ,a.XM0000 BRXM00
      ,a.XB0000 BRXB00
      ,sf_xt_csrqtonl(b.BRCSRQ)HYZK00
      ,b.BRZY00 ZY0000
      ,b.BRLXDZ JTDZ00
      ,(select CYRQ00||' '||CYSJ00 from ZY_BRXXB0 where ZYID00=a.ZYID00) CYRQSJ
      ,b.BRLXDH LXRDH0
      ,(select ZDMC00 From BQ_BRZDXX where ZYID00=a.ZYID00 and ZDLB00='2' AND ROWNUM=1) JTDZ01
      ,(select ZDMC00 From BQ_BRZDXX where ZYID00=a.ZYID00 and ZDLB00='3' AND ROWNUM=1) LXRDZ1
      ,decode((select ZLXG00 From BQ_BRZDXX where ZYID00=a.ZYID00 and ZDLB00='3' AND ROWNUM=1),'1','1','2','2','3','3','4','4','5','9','6','9','7','9','8','9')  XX0000
      ,(select FMFS00 from BQ_JSXX00 where ZYID00=a.ZYID00 and rownum=1) bz0000
      ,(select zymd00 from zy_brxxb0 where ZYID00=a.ZYID00) BRLY00
      ,b.BRZJBH SFZH00
      ,decode(ZRZYBZ,'1','是','2','是','否') HIVAB0
      ,to_char(greatest(decode(nvl(a.SJCYRQ,'20991231'),'20991231',to_date(to_char(sysdate,'yyyyMMdd'),'yyyyMMdd'),to_date(a.SJCYRQ,'yyyymmdd'))-to_date(a.SJRYRQ,'yyyymmdd'),1))||'天' RYTSMS
      ,(select ZWXM00 From BM_YGBM00 where YGBH00=a.SZYS00) SZYSXM
      ,a.SXYSXM
      ,b.RYCS00
      ,a.ZRZYBZ
 from zy_brxxb0 a,bm_brxxb0 b 
where a.brid00=b.brid00
order by a.RYRQ00 desc,a.RYCWH0