SELECT  a.*,decode(a.SYBZ00,'1','已送','未送')SYBZMC,decode(a.fyrq00,'20991231','',a.fyrq00)fyrq00,a.clbz00, decode(nvl(pspc00,'0'),'0','','代') sfdp00,decode(thbz00,0,'正常','退回')thbz00,yznr01,ch0000||'床-'||brxm00 brxm00 FROM  VW_BQ_YZCFXX a,bm_yd0000 b WHERE a.ypnm00=b.ypnm00 and BQBMBH = '60' and YYRQ00 >= '20210323' and YYRQ00 <= '20210323' and QLZT00 IN ('0','1') and zyid00 in (1032299) and b.byfl00 = '2' and (a.cxbz00='Z' or (a.ypzsl0-a.zcxsl0)>0) order by SRRQ00,CH0000,yyrq00,fysj00,pspc00, yzid00,yzmxid

SELECT  a.*,decode(a.SYBZ00,'1','已送','未送')SYBZMC,decode(a.fyrq00,'20991231','',a.fyrq00)fyrq00,a.clbz00, decode(nvl(pspc00,'0'),'0','','代') sfdp00,decode(thbz00,0,'正常','退回')thbz00,yznr01,ch0000||'床-'||brxm00 brxm00 FROM  VW_BQ_YZCFXX a,bm_yd0000 b WHERE a.ypnm00=b.ypnm00 and BQBMBH = '60' and YYRQ00 >= '20210323' and YYRQ00 <= '20210323' and QLZT00 IN ('0','1') and zyid00 in (1032299) and b.byfl00 = '0' and (a.cxbz00='Z' or (a.ypzsl0-a.zcxsl0)>0) order by SRRQ00,CH0000,yyrq00,fysj00,pspc00, yzid00,yzmxid

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '60' order by zyid00 

SELECT  a.*,decode(a.SYBZ00,'1','已送','未送')SYBZMC,decode(a.fyrq00,'20991231','',a.fyrq00)fyrq00,a.clbz00, decode(nvl(pspc00,'0'),'0','','代') sfdp00,decode(thbz00,0,'正常','退回')thbz00,yznr01,ch0000||'床-'||brxm00 brxm00 FROM  VW_BQ_YZCFXX a,bm_yd0000 b WHERE a.ypnm00=b.ypnm00 and BQBMBH = '60' and YYRQ00 >= '20210323' and YYRQ00 <= '20210323' and QLZT00 IN ('0','1') and zyid00 in (1032299) and b.byfl00 = '1' and (a.cxbz00='Z' or (a.ypzsl0-a.zcxsl0)>0) order by SRRQ00,CH0000,yyrq00,fysj00,pspc00, yzid00,yzmxid