Oracle APEX: getting invalid identifier error when using left outer join

When using left outer join with multiple tables, the order of table names listed in from clause matter.

The following SQL statement gives error of invalid identifier on A.A_ID
SELECT A.A_STUFF, B.B_STUFF
FROM A_TABLE A, B_TABLE B
LEFT OUTER JOIN C_TABLE C ON A.A_ID=C.C_ID
WHERE
C.FID = B.ID

Change the order of the table, putting A_TABLE on the outer side:
SELECT A.A_STUFF, B.B_STUFF
FROM B_TABLE B, A_TABLE A
LEFT OUTER JOIN C_TABLE C ON A.A_ID=C.C_ID
WHERE
C.FID = B.ID

It’s odd, but it seems like oracle sees the A_TABLE A as part of LEFT OUTER JOIN although you are using alias for table A_TABLE.