select yjdjh0,
       ZLXMID,
       sf_bq_getyjxmjc(yjdjh0) ZLXMJC,
       sl0000,
       cxsl00,
       to_char(SL0000) || DW0000 sl0000Str,
       ZJE000,
       YJKSBH,
       (select bmmc00 from bm_bmbm00 where bmbh00 = Y.YJKSBH) bmmc00,
       YEXM00,
       KDYSXM,
       TO_DATE(KDRQ00 || KDSJ00, 'yyyymmddhh24:mi:ss') KDRQSJ,
       KDRQ00,
       DECODE(XMZT00, '0', 'ÉêÇë', '1', '¼Æ¼Û') XMZT00,
       CXDJH0,
       BZ0000,
       (select bmmc00
          from bm_bmbm00
         where bmbh00 = Y.KDKSBH
           and rownum = 1) KDKSMC
  FROM YJ_YW0000 Y
 where mzzybz = '1'
   and xmzt00 in ('0', '1')
   AND Y.zje000 > 0
   and zyghid = '5874466'
 order by kdrq00