1       16:35:45  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=534 and BMBH00=11
 and DLXTMC='药库管理系统' and CTMC00='frmYK_CGJHCX'

2       16:35:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=534 and BMBH00=11
 and DLXTMC='药库管理系统' and CTMC00='frmYK_CGJHCX'

3       16:35:46  SQL Prepare: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH,
(SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000 
FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W 
WHERE R.YKBMBH=:1 
AND R.JHBZRQ>=:2 AND R.JHBZRQ<=:3 
AND R.SFQR00 IN ('N','Y','2') 
AND R.CZYBH0=Y.YGBH00(+)  
AND R.GHDWNM=W.GHDWNM(+)  
ORDER BY  R.CGJHDH DESC

4       16:35:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000
5       16:35:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090601
6       16:35:46  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090601
7       16:35:46  SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH,
(SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000 
FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W 
WHERE R.YKBMBH=? 
AND R.JHBZRQ>=? AND R.JHBZRQ<=? 
AND R.SFQR00 IN ('N','Y','2') 
AND R.CZYBH0=Y.YGBH00(+)  
AND R.GHDWNM=W.GHDWNM(+)  
ORDER BY  R.CGJHDH DESC

8       16:35:47  SQL Prepare: ORACLE - select * from(
select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL,
to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
(SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0,
to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, 
 (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, 
(SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 
 from YK_CGJHMX C,VW_YK_YPZKC0 D 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND C.CGJHDH=:1 
 union all 
select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,
 ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM, 
 (SELECT SUM(ROUND(NVL(SJKCSL,0)/F.K2J000,3)) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=:2) YFZSL0,
 ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 
 from YK_CGJHMX C,VW_YK_YPKCXX D
 WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND C.CGJHDH=:3 GROUP BY 1
 )ORDER BY GHDWNM,CGMXXH

9       16:35:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 002167
10      16:35:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 002167
11      16:35:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 002167
12      16:35:47  SQL Execute: ORACLE - select * from(
select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL,
to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL,
to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,
(SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0,
to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0, 
 (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, 
(SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 
 from YK_CGJHMX C,VW_YK_YPZKC0 D 
 WHERE  C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND C.CGJHDH=? 
 union all 
select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL,
 ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM, 
 (SELECT SUM(ROUND(NVL(SJKCSL,0)/F.K2J000,3)) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=?) YFZSL0,
 ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 
 from YK_CGJHMX C,VW_YK_YPKCXX D
 WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=11
 AND C.CGJHDH=? GROUP BY 1
 )ORDER BY GHDWNM,CGMXXH

13      16:35:49  SQL Error: ORACLE - ORA-00979: 不是 GROUP BY 表达式

14      16:35:49  SQL Error: ORACLE - Unmapped SQL Error Code: 979
15      16:35:49  SQL Data In: ORACLE - Rows affected = 0