Exception when running a query in Oracle 9i ( ORA-00936: missing expression )

Dear all,
I get an exception like below when i run a query on Oracle 9i.

Oracle.DataAccess.Client.OracleException: ORA-00936: missing expression

The query is :

SELECT DISTINCT
 C.STMSITE,H.SOCLMAG AS "NM SITE", F.KATEGORI,F.SUBKATEGORI, F.FUNCTIONS,F.SUBFUNCTION, F.MSBRAND,F.BRAND, E.ARVCEXR AS "ARTICLE CODE",E.ARVCEXV AS "LV", G.TSOBDESC AS "NM ITEM",A.ARTDCRE AS "CREATE DATE", C.SALESQTY,C.SALESVALUE,D.STOCKQTY AS "STOCK QTY",
(D.STOCKQTY*I.STOPURC) AS "STOCK VALUE"

FROM (SELECT ARTCINR, ARTDCRE FROM PRODMITRA.ARTRAC WHERE ARTDCRE <= TO_DATE('12-03-2006','DD-MM-YYYY') AND PRODMITRA.ARTRAC.ARTTYPP <> 10 AND ARTETAT = 1 ) A LEFT JOIN PRODMITRA.ARTUL B ON A.ARTCINR = B.ARUCINR INNER JOIN (SELECT STMSITE,STMCINL,-SUM(STMREA) AS SALESQTY,  -SUM(NVL(STMVPV,0))+SUM(NVL(STMTVA,0)) AS SALESVALUE FROM PRODMITRA.STOMVT WHERE STMSITE = 1000 AND STMTMVT >= 150 AND STMTMVT <=174 AND TRUNC(STMDMVT) >= TO_DATE('01-01-2006','DD-MM-YYYY') AND TRUNC(STMDMVT) <= TO_DATE('30-06-2006','DD-MM-YYYY') GROUP BY STMSITE,STMCINL ) C ON B.ARUCINL = C.STMCINL INNER JOIN (SELECT STMCINL,SUM(STMREA) AS STOCKQTY FROM PRODMITRA.STOMVT WHERE TRUNC(STMDMVT) <= TO_DATE('30-06-2006','DD-MM-YYYY') GROUP BY STMCINL ) D ON C.STMCINL = D.STMCINL INNER JOIN (SELECT ARVCINV, ARVCEXR, ARVCEXV FROM PRODMITRA.ARTUV ) E ON B.ARUCINL = E.ARVCINV INNER JOIN
(SELECT CINR,KATEGORI,SUBKATEGORI, FUNCTIONS,SUBFUNCTION, MSBRAND(,
BRAND) FROM PRODMITRA.TBL_MERCHANDISE WHERE KATEGORI = 'FLOORING AND WALL' ) F ON B.ARUCINR = F.CINR INNER JOIN (SELECT TSOBCINT, TSOBDESC FROM PRODMITRA.TRA_STRUCOBJ WHERE LANGUE = 'GB') G ON B.ARUCLIBL = G.TSOBCINT INNER JOIN (SELECT SOCSITE, SOCLMAG FROM PRODMITRA.SITDGENE ) H ON C.STMSITE = H.SOCSITE INNER JOIN (SELECT A1.STOCINL, B1.STOPURC FROM PRODMITRA.STOCOUCH A1 INNER JOIN ( SELECT  B21.STOCINL, B11.STOPURC FROM PRODMITRA.STOCOUCH B11 INNER JOIN ( SELECT STOCINL,MAX(STOSEQ) AS STQ FROM PRODMITRA.STOCOUCH WHERE STOPURC <> 0 GROUP BY STOCINL ) B21 ON B11.STOCINL = B21.STOCINL AND B11.STOSEQ = B21.STQ ) B1 ON A1.STOCINL = B1.STOCINL ) I ON B.ARUCINL = I.STOCINL What should I do? Received on Tue Sep 19 2006 - 22:35:03 CDT