select 0 XZBZ00,
       ZYID00,
       BRID00,
       trim(MRN000) MRN000,
       trim(ZYH000) ZYH000,
       XM0000,
       XB0000,
       CSRQ00,
       RYRQSJ,
       RYZD00,
       RYSQK0,
       RYBQ00,
       DQBQ00,
       DQBQMC,
       RZKS00,
       RYCWH0,
       CYDJSJ,
       SJCYRQ,
       ZZYSXM,
       FBBH00,
       GSDJH0,
       ZRYSXM,
       SXYSXM,
       BRRYCS,
       BRZT00,
       DQKSMC,
       SHBZ00,
       BAZT00,
       YBMC00,
       decode(FSRQ00, '20991231', '', FSRQ00) FSRQ00,
       ZYCS00,
       BAHCS0,
       CYZD00,
       SHRXM0,
       SHSJ00,
       YBKH00,
       YBID00,
       YBZYH0,
       QSRQSJ,
       QSRXM0,
       HTRQ00,
       HTRXM0,
       LRRQ00,
       (select dpbz00
          from BA_BASYDP b
         where b.LSH000 = a.zyid00
           and rownum <= 1) HTYY00,
       LXRDH0,
       HJJE00,
       SCSHR0,
       SCSHRQ,
       decode(bawcbz, '1', '已完成', '未完成') BAWCBZ,
       decode(dbzmc0, null, '否', '是') SFDBZ0,
       ZZZT00,
       GDGDSJ,
       decode(nvl(QSRQSJ, '0'),
              '0',
              '',
              decode(nvl(GDGDSJ, '0'), '0', '', ASGD00)) ASGD00,
       SCTJRQ,
       nvl(a.gdtjrq, to_char(to_date(a.sjcyrq, 'yyyyMMdd') + 3, 'yyyyMMdd')) GDTJRQ,
       case
         when ZZZT00 = '未提交' then
          '否'
         when ZZZT00 = '未创建' then
          '否'
         when to_date(nvl(a.gdtjrq,
                          to_char(to_date(a.sjcyrq, 'yyyyMMdd') + 3,
                                  'yyyyMMdd')),
                      'yyyy-MM-dd') -
              to_date(nvl(SCTJRQ, '20991231'), 'yyyy-MM-dd') >= 0 then
          '是'
         else
          '否'
       end SFGDTJ
  FROM VW_ZS_CYBAXX_ZYDZBL a
 where SJCYRQ between '20180901' and '20180930'
   and DQKS00 = '2238'
   and A.DQKS00 in (select bmbh00 from bm_bmbm00 where yyid00 = '220006')
 order by a.CYDJRQ