/* Formatted on 2016/06/06 10:03 (Formatter Plus v4.8.7) */
SELECT   b.brxm00, b.xb0000, b.rycwh0, zyghid zyid00, yzcfid yzid00, zlxmjc,
         zje000, kdysxm, kdrq00, kdbq00, bbdybz yjdjdy, yjdjh0, zdmc00,
         dyrqxx, dysjxx, zyhghh, sl0000, bbmc00, zxks00, txm000, jzbz00
    FROM vw_jy_brxxtmdyd b
   WHERE zyghid = 2317165
     AND NVL (cjksbh, kdbq00) = 55
     AND kdrq00 BETWEEN '20160602' AND '20160606'
     AND kdrq00 || kdsj00 BETWEEN '2016060200:00:00' AND '2016060623:59:59'
     AND NVL (dyrqxx, '0') <> '0'
     AND (   INSTR (',51,55,', ',55,') > 0
          OR INSTR (',51,55,', ',' || yjksbh || ',') > 0
         )
ORDER BY bbid00