select JYYWID,YJDJH0,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CH0000,BBID00,NL0000, (select JZBZ00 from YJ_YW0000 where YJDJH0=a.YJDJH0) JZBZ00, (select XMZT00 from YJ_YW0000 where YJDJH0=a.YJDJH0) XMZT00, (select decode(XMZT00,'0','申请','1','计价','2','已收费','3','已执行','4','已报告','5','疑退','6','作废') from YJ_YW0000 where YJDJH0=a.YJDJH0) XMZTMC, (select BBMC00 from BM_BBZD00 where BBID00=a.BBID00)BBMC00,TXM000, BBCJR0,(select ZWXM00 from BM_YGBM00 where YGBH00=a.BBCJR0)BBCJXM,BBCYRQ,BBCYSJ, SQRQ00,SQSJ00,SQYS00,(select ZWXM00 from BM_YGBM00 where YGBH00=a.SQYS00)SQYSXM, SQBQ00,(select BMMC00 from BM_BMBM00 where BMBH00=a.SQBQ00)SQBQMC, SQKS00,(select BMMC00 from BM_BMBM00 where BMBH00=a.SQKS00)SQKSMC, (select TXMQZ0 from JY_TXMDY0 where ZLXMID=a.ZLXMID)TXMQZ0, (select c.TXMYSZ from JY_TXMLB0 c,JY_TXMDY0 d where c.TXMQZ0=d.TXMQZ0 and d.ZLXMID=a.ZLXMID and rownum=1)TXMYSZ, (select ZLXMJC from BM_ZLZD00 where ZLXMID=a.ZLXMID)ZLXMJC,ZLXMID, JGZT00,decode(a.JGZT00,'0','申请', '1','采集', '2','签收', '3','退回', '4','排样', '5','对应', '6','确认', '7','删除', '8','打印')JGZTMC,sfbz00, (select TMTZBH from BM_ZLZD00 where ZLXMID=a.ZLXMID) jytzbh,nvl(dycs00,0) dycs00,BRID00,THYY00,YEXM00, (select '1' from JY_HGSJJL where TXM000=a.txm000 and JJLB00='1') SFBQQS, (select '1' from JY_HGSJJL where TXM000=a.txm000 and JJLB00='2') SFJYQS from JY_YW0000 a where MZZYBZ='1'  and ZYGHID in(130373) and MZZYBZ='1' and JGZT00 in ('0','3','1') and SQRQ00 >= '20190301' and SQRQ00 <= '20190313' and BBCYRQ is null  and TXM000 is not null  and exists(select 1 from YJ_YW0000 where YJDJH0=a.YJDJH0 and yjlrbz='N' ) and dycs00>0  ORDER BY ZYGHID, TXM000, TXMQZ0,ZLXMID