1       15:57:55  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

2       15:57:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
3       15:57:58  SQL Execute: ORACLE - Select * from (select bmbh00,bmmc00,YKBMMC,PYSM00,WBSM00 from VW_YK_THSHGHDW where (PYSM00 Like ?) and(   YKBMBH=12 )  Order By PYSM00) where Rownum<=30

4       15:57:59  SQL Execute: ORACLE - select Q.*,(SELECT M.BMMC00 FROM BM_BMBM00 M WHERE M.BMBH00=Q.YKBMBH) YKBMMC,
'0' FLAG00 
from YK_YPQLD0 Q
  where Q.QLZT00 in ('1','2')
 AND Q.YKBMBH=12
 and Q.CKQXBH=10447
 and Q.CKLXBH='09'
 and Q.SFSH00='N'
 ORDER BY YPQLDH

5       15:57:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 164281
6       15:57:59  SQL Execute: ORACLE - SELECT Q.YPQLPC, X.YPQLDH,X.BZ0000,Q.FPH000,Q.FPRQ00,Q.YPNM00,
X.YPMC00,X.YPGG00,X.CKDW00,X.CKSL00,X.GJDJ00,X.LSDJ00,X.PFDJ00,
ROUND(X.CKSL00*X.GJDJ00,2) AS C_GJJE,
ROUND(X.CKSL00*X.PFDJ00,2) AS C_PFJE,
ROUND(X.CKSL00*X.LSDJ00,2) AS C_LSJE,
ROUND(ROUND(X.CKSL00*X.LSDJ00,2)-ROUND(X.CKSL00*X.GJDJ00,2),2) AS C_JXCJ,
(SELECT R.SCCJZW FROM YK_YPRKMX R WHERE R.YPRKPC=Q.RKPC00) SCCJZW,
(SELECT R.scph00 FROM YK_YPRKMX R WHERE R.YPRKPC=Q.RKPC00) scph00,
(SELECT R.ypsxrq FROM YK_YPRKMX R WHERE R.YPRKPC=Q.RKPC00) ypsxrq,
ROUND((ROUND(ROUND(X.CKSL00*X.LSDJ00,2)-ROUND(X.CKSL00*X.GJDJ00,2),2)/ROUND(X.CKSL00*X.GJDJ00,2))*100 + 0.0000499)/100 AS C_JXCJL,
(select ypmlbz from bm_yd0000 where ypnm00=Q.ypnm00) ypmlbz,Q.FPH000 FPHOLD,Q.FPRQ00 FPRQOL  
 FROM YK_YPCKMX X,YK_YPQLMX Q
 WHERE X.YPQLDH=? AND X.YPQLDH=Q.YPQLDH AND X.YPNM00=Q.YPNM00 and X.YPQLPC=Q.YPQLPC
 ORDER BY X.YPCKPC
 

7       15:57:59  SQL Error: ORACLE - ORA-01476: ³ýÊýΪ 0

8       15:57:59  SQL Error: ORACLE - Unmapped SQL Error Code: 1476
9       15:57:59  SQL Data In: ORACLE - Rows affected = 0