select decode(SYCZY0, NULL, 'N', 'Y') SYBZ00, 'N' SFXZ00, 0 ID0000, a.*
  from VW_YF_JYXXB0 a
 where 1 = 1
   and A.YFBMBH = ''
   and a.KDJFRQ between ? and ?
   and a.KDJFRQ || a.KDJFSJ between ? || ? and ? || ?
   and (a.MZZYBZ = '0' or a.MZZYBZ = '1' and a.SFCYDY = '1')
   and nvl(a.SYDJID, '0') = '0'
   and nvl(a.TYBZ00, '0') <> '1'
 order by a.MZZYBZ, a.MZFYXH, a.BQBMBH, a.CH0000