SELECT to_date(a.qyrq00,'yyyy-MM-dd') QYRQ00,to_date(a.TZRQ00,'yyyy-MM-dd') TZRQ00 ,B.YPNM00,b.yzid00, 
 B.YPMC00,A.CLBZ00,B.mcsl00,B.jldw00,to_char(sysdate, 'YYYY - MM - DD') KSRQ00,c.YPGG00,(select SCCJZW from BM_YPSCCJ B 
 where C.SCCJBH=B.SCCJBH and rownum=1) SCCJZW, (select JXMC00 from BM_YPJX00 d where d.LBBH00=c.LBBH00 and d.JXBH00=c.JXBH00) JXMC00, 
 to_char(sysdate, 'YYYY - MM - DD') JSRQ00,A.PCID00,A.PCMC00,A.YFID00,A.YPYFMC,a.yyzf00,B.YZMXID,A.KZYS00,A.KZYSXM,d.LSDJ00  FROM
  VW_BQ_YPYZXG_ZYDZBL A, BQ_YPYZMX B ,VW_BQ_YFYPSC c,VW_BQ_YFYPSC d WHERE A.YZID00 = B.YZID00 and B.YPNM00=C.YPNM00 and B.YPNM00 = d.YPNM00 
   and B.YZMXID = 25816224