1       10:03:57  SQL Execute: ORACLE - select count(*) from VW_JY_YGQXZD where yqdh00='00' and qxlx00='XTQX' and  QXGNDH='JYSQZJQX' and ygbh00=152

2       10:03:57  SQL Execute: ORACLE - select count(*) from VW_JY_YGQXZD where yqdh00='00' and qxlx00='XTQX' and  QXGNDH='JYSQXGQX' and ygbh00=152

3       10:03:57  SQL Execute: ORACLE - select count(*) from VW_JY_YGQXZD where yqdh00='00' and qxlx00='XTQX' and  QXGNDH='JYSQSCQX' and ygbh00=152

4       10:03:57  SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,DW0000,YJKSBH,XMZTMC,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,YPNM00,DCBZ00,CXDJH0,ZJE000,BZ0000,KDKSMC,YJLRBZ,KDBQ00,JGZCBZ,BQSFBZ,ZLXMBH,YJKSMC,BBID00,BBMC00 from VW_JY_JYSQXM b where ZYHGHH='1600377' and (KDKSBH='49' or YJKSBH='49')
and XMZT00 in ('0','1','2') 
and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 )) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) 
order by YJDJH0 

5       10:03:58  SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,DW0000,YJKSBH,XMZTMC,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,YPNM00,DCBZ00,CXDJH0,ZJE000,BZ0000,KDKSMC,YJLRBZ,KDBQ00,JGZCBZ,BQSFBZ,ZLXMBH,YJKSMC,BBID00,BBMC00 from VW_JY_JYSQXM b where ZYHGHH='1600377' and (KDKSBH='49' or YJKSBH='49')
and XMZT00 in ('4','3') 
and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 )) and ((cxdjh0=0) or (cxdjh0 is null) or sl0000>0) 
order by YJDJH0 

6       10:03:58  SQL Execute: ORACLE - select a.zlxmjc,a.zxmid0 zlxmid,decode(b.zlxmid,null,'N','Y')gdxmbz,b.jgms00,a.jgdw00, b.ckz000,a.bbid00,a.zyzbid  from VW_YS_YWMXXM a,(select * from YJ_YWMX00 where yjdjh0=7959538) b where a.zxmid0=b.zlxmid(+) and a.sjxmid=17537 order by a.zxmbh0 

7       10:03:58  SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=17537 AND A.BBID00=B.BBID00