1       13:07:14  SQL Execute: ORACLE - select a.zlxmid,a.zlxmjc,a.pysm00,a.wbsm00,
a.tzrq00,b.lbmc00,a.dw0000,a.zlxmbh,a.lbbh00,
rpad(nvl(a.fyid00,'0'),6,' ') fyid00,
(select yymc00 from vw_xt_fyxx00 where yyid00=rpad(nvl(a.fyid00,'0'),6,' ')) fymc00 
 from   BM_ZLZD00 a,bm_zlxmlb b where a.lbbh00=b.lbbh00 
 and (FYID00=rpad('0',6,' ') or FYID00=rpad('222142',6,' '))
 and zhxmbz='1' order by zlxmbh

2       13:07:14  SQL Execute: ORACLE - Select zlxmbh,zlxmjc from VW_BM_YXZLZD where lbbz00='0' order by zlxmbh

3       13:07:14  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18900.000000
4       13:07:14  SQL Execute: ORACLE - select * from VW_XT_ZHMX00 where zhxmid=?

5       13:07:20  SQL Execute: ORACLE - Select ZXMBH0, GDXMBZ, ZXMID0, LBBZ00, ZLXMJC, FBZXBZ, JGDW00, CKZ000, DW0000, LBBH00, BZ0000, ZHXMBZ,FYID00 from VW_YS_YWMXXM where SJXMBH ='Z' and lbbz00='1' and zhxmbz='0' 
 and FYID00=rpad('0',6,' ') 
 order by ZXMBH0

6       13:07:31  SQL Execute: ORACLE - Select ZXMBH0, GDXMBZ, ZXMID0, LBBZ00, ZLXMJC, FBZXBZ, JGDW00, CKZ000, DW0000, LBBH00, BZ0000, ZHXMBZ,FYID00 from VW_YS_YWMXXM where SJXMBH ='Z003002013' and lbbz00='1' and zhxmbz='0' 
 and FYID00=rpad('0',6,' ') 
 order by ZXMBH0