1       12:16:23  SQL Prepare: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=476) and  (BMBH00=0 or  BMBH00=125)
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' order by YGBH00 

2       12:16:23  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=476) and  (BMBH00=0 or  BMBH00=125)
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_WZRKCX' order by YGBH00 

3       12:16:23  SQL Prepare: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH

4       12:16:23  SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH

5       12:16:23  SQL Prepare: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 
WHERE RCKBZ0 = '1' and RCKBBH<>'35' AND SFYX00 = 'Y'

6       12:16:23  SQL Execute: ORACLE - SELECT RCKBBH,RCKBMC FROM BM_RCKLB0 
WHERE RCKBZ0 = '1' and RCKBBH<>'35' AND SFYX00 = 'Y'

7       12:16:23  SQL Prepare: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,CGYGXM,BZ0000,RCKID0,KFBMBH,QRRQ00,FHBMMC,RCKLX0,SHRQ00,GJZJE0,LSZJE0,
RKYGXM,QRYGXM,SHYGXM,(select max(FPH000) from WZ_RCKMX0 D where D.RCKID0=C.RCKID0) FPH000 
FROM VW_WZ_RCK000  WHERE 
rckid0 in (select distinct b.RCKID0  FROM VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID  
 and a.KFBMBH = :1 AND a.RCKLB0 ='1' and c.WZDMBM||'' like :2 ||'%'
 AND a.QRRQ00 >=:3 AND a.QRRQ00 <=:4
 and a.rcklx0<>'35' 
and b.BZSL00<>'0' 
 and ((a.RCKLX0 =:5) OR (:6 = '-1'))) order by RCKDH0 desc

8       12:16:23  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 125.000000
9       12:16:23  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
10      12:16:23  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150107
11      12:16:23  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150107
12      12:16:23  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
13      12:16:23  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
14      12:16:23  SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,CGYGXM,BZ0000,RCKID0,KFBMBH,QRRQ00,FHBMMC,RCKLX0,SHRQ00,GJZJE0,LSZJE0,
RKYGXM,QRYGXM,SHYGXM,(select max(FPH000) from WZ_RCKMX0 D where D.RCKID0=C.RCKID0) FPH000 
FROM VW_WZ_RCK000  WHERE 
rckid0 in (select distinct b.RCKID0  FROM VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID  
 and a.KFBMBH = ? AND a.RCKLB0 ='1' and c.WZDMBM||'' like ? ||'%'
 AND a.QRRQ00 >=? AND a.QRRQ00 <=?
 and a.rcklx0<>'35' 
and b.BZSL00<>'0' 
 and ((a.RCKLX0 =?) OR (? = '-1'))) order by RCKDH0 desc

15      12:16:23  SQL Data In: ORACLE - Rows affected = 0