1       09:09:34  SQL Execute: ORACLE -  SELECT A.YGBH00 AS YGBH00,A.ZWXM00 AS ZWXM00,NVL(A.YJJE00,0) AS YJJE00,NVL(B.SJJE00,0) AS SJJE00 FROM 
 (SELECT -7 AS YGBH00, '合计' AS ZWXM00, SUM(JFJE00) AS YJJE00 FROM VW_ZH_BRJFJK )  A, 
 (SELECT -7 AS YGBH00, '合计' AS ZWXM00, SUM(JFJE00) AS SJJE00 FROM VW_ZH_BRJFJK WHERE JKBID0<>0 ) B WHERE A.YGBH00=B.YGBH00 
 UNION ALL SELECT A.JFCZY0 AS YGBH00,A.CZYXM0 AS ZWXM00,NVL(A.YJJE00,0) AS YJJE00,NVL(B.SJJE00,0) AS SJJE00 FROM 
 (SELECT JFCZY0,CZYXM0,SUM(JFJE00) AS YJJE00 FROM VW_ZH_BRJFJK GROUP BY JFCZY0,CZYXM0) A, 
 (SELECT JFCZY0,CZYXM0,SUM(JFJE00) AS SJJE00 FROM VW_ZH_BRJFJK WHERE JKBID0<>0 GROUP BY JFCZY0,CZYXM0) B 
 WHERE A.JFCZY0=B.JFCZY0(+) 

2       09:09:38  SQL Execute: ORACLE - Delete from BM_ZHTJ00_TEMP00 where trim(Flag00)=trim('SUMDATE0159')

3       09:09:38  SQL Data In: ORACLE - Rows affected = 0
4       09:09:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = SUMDATE0159
5       09:09:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110829
6       09:09:38  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110829
7       09:09:38  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
8       09:09:38  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
9       09:09:38  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
10      09:09:38  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
11      09:09:38  SQL Execute: ORACLE - Insert into BM_ZHTJ00_TEMP00(flag00,STARTD,STOPDA,STARTT,STOPTI,TEMP90,TEMP91) values(?,?,?,?,?,?,?)

12      09:09:38  SQL Data In: ORACLE - Rows affected = 1
13      09:09:38  SQL Execute: ORACLE - Commit

14      09:09:38  SQL Data In: ORACLE - Rows affected = 0
15      09:09:38  SQL Execute: ORACLE - select lbbh00,lbmc00 from BM_GHLBB0 where SFYX00='Y' and lbbh00>=0
 union all select -9999 lbbh00,'合计' from dual 
 union all select 9999 lbbh00,'其它' from dual order by lbbh00 

16      09:09:39  SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = S_MZZHCX0159
17      09:09:39  SQL Data In: ORACLE - Param = 2, Name = V_KSYSBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
18      09:09:39  SQL Execute: ORACLE - BEGIN "SP_ZH_MZXXCX" (V_FLAG00 => :V_FLAG00,V_KSYSBZ => :V_KSYSBZ); END;
19      09:19:37  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = S_MZZHCX0159
20      09:19:37  SQL Execute: ORACLE - SELECT GHHJ00,FYHJ00,trim(TEMP01) TEMP01,trim(TEMP02) TEMP02,trim(TEMP03) TEMP03,
trim(TEMP04) TEMP04,trim(TEMP05) TEMP05,trim(TEMP06) TEMP06,
trim(TEMP07) TEMP07,trim(TEMP08) TEMP08,trim(TEMP09) TEMP09,
trim(TEMP10) TEMP10,
trim(TEMP11) TEMP11,trim(TEMP12) TEMP12,
trim(TEMP13) TEMP13,trim(TEMP14) TEMP14,trim(temp15) TEMP15,TEMP16,TEMP17,TEMP18,TEMP19,TEMP20,TEMP21,TEMP22,TEMP23,TEMP24,
       TEMP25,TEMP26,TEMP27,TEMP28,TEMP29,TEMP30,TEMP31,TEMP32,TEMP33,TEMP34,TEMP35,TEMP36,TEMP37,
TEMP38,TEMP39,TEMP40,a.BMBH00,trim(a.BMMC00) BMMC00,a.FLAG00,TEMP99
FROM BM_ZHTJ00_TEMP00 a,BM_BMBM00 b
WHERE trim(a.FLAG00)=trim(?) and a.bmbh00 =b.bmbh00(+)
ORDER BY nvl(b.pxxh00,decode(a.bmbh00,-9999,-9999,9999,9999,8888)),a.BMBH00,TEMP98

 
 
 
 
 

21      09:19:37  SQL Execute: ORACLE - delete BM_ZHTJ00_TEMP00 where trim(FLAG00)=trim('S_MZZHCX0159') 

22      09:19:37  SQL Data In: ORACLE - Rows affected = 9
23      09:19:37  SQL Execute: ORACLE - Commit

24      09:19:37  SQL Data In: ORACLE - Rows affected = 0