Missing Right Parenthesis Error

We are porting some queries out of our Access front end into a web front end. For some reason the following query works fine in Access but gives me an "ORA-00907:Missing Right Parenthesis" error in my web front end.

I can't find where there is a missing parenthesis.


Here is the query:



SELECT DISTINCT assembly_build.ASSEMBLY_NO, assembly_build.DESTINATION, assembly_build.ASSEMBLY_DATE, assembly_build.REQUESTOR, assembly_build.PURPOSE, assembly_build.RACK_SERIAL_NO, assembly_build.SHIP_DATE, assembly_build_items.ASSY_ITEM_NO, assembly_build_items_1.ASSY_ITEM, assembly_build_items_1.QTY, Contract_Info.ACTUAL_CONTRACT_NO, assembly_build_items.ASSY_ITEM AS subassy_no, Master_Parts.DESCRIPTION, Master_Parts.UOI, Master_Parts.PRICE, '' AS index_code, '' AS serial_no, stock_items.PART_NO, configurations.CONFIG_PART_NO, assembly_build_items.REF_DESIG, assembly_build_1.REV, locations.LOCATION, assembly_build_items.REF1, assembly_build_items.REF2, assembly_build_items.REF3, assembly_build_items.REF4, assembly_build_items.REF5, configurations.DWG_NO, stock_items.QTY AS inv_qty, assembly_report_stock_alloc.SumOfQTY AS ISSUE_QTY
FROM (ref_desig RIGHT JOIN (Master_Parts INNER JOIN (locations INNER JOIN ((assembly_build LEFT JOIN Contract_Info ON assembly_build.CONTRACT_ID = Contract_Info.CONTRACT_ID) INNER JOIN (((assembly_build_items INNER JOIN (assembly_build_items AS assembly_build_items_1 INNER JOIN assembly_build AS assembly_build_1 ON assembly_build_items_1.ASSEMBLY_NO = assembly_build_1.ASSEMBLY_NO) ON assembly_build_items.ASSY_ITEM = assembly_build_1.ASSEMBLY_NO) INNER JOIN configurations ON assembly_build_1.CONFIG_ID = configurations.CONFIG_ID) INNER JOIN stock_items ON assembly_build_items_1.ASSY_ITEM = stock_items.STOCK_NO) ON assembly_build.ASSEMBLY_NO = assembly_build_items.ASSEMBLY_NO) ON locations.LOCATION_ID = stock_items.LOCATION_ID) ON Master_Parts.PART_NO = stock_items.PART_NO) ON ref_desig.REF_DESIG = assembly_build_items.REF_DESIG) LEFT JOIN assembly_report_stock_alloc ON (assembly_build_items_1.ASSEMBLY_NO = assembly_report_stock_alloc.ASSEMBLY_NO) AND (assembly_build_items_1.ASSY_ITEM = assembly_report_stock_alloc.STOCK_NO) WHERE (((assembly_build.ASSEMBLY_NO)='JO-0570') AND ((stock_items.CONTRACT_ID)='14'))




Can anyone help?