Can't add second acp to Query Database node

I have a SQL query that's relatively complicated. It runs directly in Oracle, and the node validates when the values I'm trying to replace with ACPs are hard coded.  I can add one ACP before it tells me "SQL command not properly ended".  This is what I'm trying to run:

SELECT FC.FACILITY_ID FROM CHEMS_FACILITY_CURRENT FC LEFT JOIN ((SELECT A.FACILITY_ID FROM CHEMS_FACILITY_CURRENT A INNER JOIN (SELECT FACILITY_ID FROM CHEMS_FACILITY_DOCUMENTS WHERE DOCUMENT_TYPE IN (130030,130205,130207,130206,130215,130214,130204,130203,130208,130217,130361,130401) AND MAILED_ON > ac!oneAOrderMailedOn GROUP BY FACILITY_ID HAVING COUNT(FACILITY_ID) =1) B ON A.FACILITY_ID = B.FACILITY_ID WHERE A.FACILITY_STATUS_ID = 6 OR A.FACILITY_STATUS_ID = 8)
UNION
(SELECT A.FACILITY_ID FROM CHEMS_FACILITY_CURRENT A INNER JOIN (SELECT FACILITY_ID FROM CHEMS_FACILITY_DOCUMENTS WHERE DOCUMENT_TYPE IN (130030,130205,130207,130206,130215,130214,130204,130203,130208,130217,130361,130401) AND MAILED_ON > ac!manyAOrderMailedOn GROUP BY FACILITY_ID HAVING COUNT(FACILITY_ID) >1) B ON A.FACILITY_ID = B.FACILITY_ID WHERE A.FACILITY_STATUS_ID = 6 OR A.FACILITY_STATUS_ID = 8)
UNION
(SELECT A.FACILITY_ID FROM CHEMS_FACILITY_CURRENT A INNER JOIN (SELECT FACILITY_ID FROM CHEMS_FACILITY_DOCUMENTS WHERE DOCUMENT_TYPE IN (130209,130216,130213,130202,130212) AND MAILED_ON > ac!oneBOrderMailedOn GROUP BY FACILITY_ID HAVING COUNT(FACILITY_ID) =1) B ON A.FACILITY_ID = B.FACILITY_ID WHERE A.FACILITY_STATUS_ID = 6 OR A.FACILITY_STATUS_ID = 8)
UNION
(SELECT A.FACILITY_ID FROM CHEMS_FACILITY_CURRENT A INNER JOIN (SELECT FACILITY_ID FROM CHEMS_FACILITY_DOCUMENTS WHERE DOCUMENT_TYPE IN (130209,130216,130213,130202,130212) AND MAILED_ON > ac!manyBOrderMailedOn GROUP BY FACILITY_ID HAVING COUNT(FACILITY_ID) >1) B ON A.FACILITY_ID = B.FACILITY_ID WHERE A.FACILITY_STATUS_ID = 6 OR A.FACILITY_STATUS_ID = 8)) ORDERS ON ORDERS.FACILITY_ID = FC.FACILITY_ID WHERE ORDERS.FACILITY_ID IS NULL AND FC.FACILITY_STATUS_ID IN (6,8)