select 0 XZBZ00,ZYID00, BRID00, trim(MRN000) MRN000, trim(ZYH000) ZYH000, XM0000, XB0000, CSRQ00, RYRQSJ,RYSQK0, RYBQ00, DQBQ00, DQBQMC, RZKS00, RYCWH0, CYDJSJ, SJCYRQ, ZZYSXM,FBBH00,ZRYSXM, SXYSXM, BRRYCS, BRZT00, DQKSMC, SHBZ00, BAZT00, YBMC00,decode(FSRQ00,'20991231','',FSRQ00) FSRQ00,ZYCS00,BAHCS0, CYZD00,SHRXM0, SHSJ00, YBKH00,  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','已完成','2','审核完成','未完成') BAWCBZ,  decode(dbzmc0,null,'否','是')  SFDBZ0,ZZZT00,GDGDSJ,decode(nvl(QSRQSJ,'0'),'0','',decode(nvl(GDGDSJ,'0'),'0','',ASGD00)) ASGD00,SCTJRQ,nvl(a.GDTJRQ, SF_ZS_ComputeGdtjrq(a.CYRQ00, 3)) GDTJRQ, case  when ZZZT00 = '未提交' then '否' when ZZZT00 = '未创建' then '否' when to_date(SF_ZS_ComputeGdtjrq(nvl(a.GDTJRQ, a.CYRQ00),3), 'yyyy-MM-dd') -to_date(a.SCTJRQ, 'yyyy-MM-dd') >= 0 then  '是' else '否' end SFGDTJ  FROM vw_ba_cybaxx a  where 1=1  and SHBZ00 in ('1')  and DQKS00 = '10553'  and CYRQ00 between '20200401' and '20200412'  and exists(select 1 from bm_bmbm00 where bmbh00=A.DQKS00 and yyid00='220006') order by SJCYRQ