select ZYID00,
       BRID00,
       MRN000,
       ZYH000,
       YBZYH0,
       XM0000,
       XB0000,
       FBBH00,
       FBXX00,
       FBMC00,
       CYRQ00,
       CYSJ00,
       RYRQ00,
       RYSJ00,
       RYCZY0,
       RYZD00,
       RYSQK0,
       RYLB00,
       RYBQ00,
       RZKS00,
       RYCWH0,
       DQBQ00,
       DQBQMC,
       DQKS00,
       DQKSMC,
       ZZYS00,
       ZZYSXM,
       ZRYS00,
       ZRYSXM,
       SXYS00,
       SXYSXM,
       BRRYCS,
       ZYZHID,
       JFLBID,
       JFLBMC,
       SFDJ00,
       KHRQ00,
       KHSJ00,
       CZYBH0,
       CZYXM0,
       YJZJE0,
       WJSJE0,
       XJYE00,
       ZZYE00,
       ZYE000,
       YKZYE0,
       WSFCFE,
       WSFYJE,
       BJJE00,
       TYJE00,
       YXQFJE,
       KL0000,
       BRZT00,
       YBYJS0,
       YBYZF0,
       WGZXM0,
       NVL(ZYE000, 0) - NVL(WSFCFE, 0) - NVL(WSFYJE, 0) - NVL(WGZXM0, 0) BRQF00,
       sf_bq_kyje00(ZYID00, BRID00, 2) BRKYJE,
       (select jybj00
          from VW_BQ_ZYBRLB_YDHL
         where zyid00 = a.zyid00
           and zyh000 = a.zyh000
           and rownum = 1) jybj00
  from VW_ZY_BRZHCJ a
 where 1 = 1
   and sf_bq_kyje00(ZYID00, BRID00) <= '1000.0'
   and dqbq00 = '2406'
   and id0000 = '279063'
 order by dqbq00, RYCWH0