SQL & PL/SQL

Friends

When I run below query, it works and returns records.
===>>
SELECT
R1.TRANSACTION_ID,
R1.CREATION_DATE,
R1.TRANSACTION_TYPE,
R1.QUANTITY,
R1.PRIMARY_UNIT_OF_MEASURE UOM,
R1.CURRENCY_CODE,
R1.PO_UNIT_PRICE,
R1.PO_HEADER_ID,
R1.PO_LINE_ID,
P1.CATEGORY_ID,
CAT.SEGMENT1, CAT.SEGMENT2, CAT.SEGMENT3
FROM
RCV_TRANSACTIONS@APPS_TST R1,
PO_LINES_ALL@APPS_TST P1,
MTL_CATEGORIES_4_ATS@APPS_TST CAT
WHERE
R1.PO_LINE_ID = P1.PO_LINE_ID AND
P1.CATEGORY_ID = CAT.CATEGORY_ID AND
R1.TRANSACTION_TYPE = 'ACCEPT' AND
TO_DATE(TO_CHAR(R1.CREATION_DATE,'DD/MM/YYYY'),'DD/MM/YYYY') = TO_DATE(TO_CHAR(SYSDATE-92,'DD/MM/YYYY'),'DD/MM/YYYY') AND
EXISTS (SELECT * FROM MTL_CATEGORIES_4_ATS@APPS_TST WHERE P1.CATEGORY_ID = CAT.CATEGORY_ID)
ORDER BY
R1.LAST_UPDATE_DATE DESC;
<<===

I have created a view based on this query.
===>>
CREATE OR REPLACE VIEW PO_RECEIVINGS_V
AS
SELECT ...
<<===

View was created successfully. When I perform a select on the view, it returns this message.

===>>
SQL> SELECT * FROM PO_RECEIVINGS_V;
SELECT * FROM PO_RECEIVINGS_V
*
ERROR at line 1:
ORA-00907: missing right parenthesis
ORA-02063: preceding line from APPS_TST
<<===

I have created this view on a 10G database. The tables what I'm using in the view, are from a 9i database.