This forum is for Sql Developer questions only.
Please mark the thread ANSWERED and repost it in the SQL forum
You do NOT need to provide the schema name if you are connected to the schema you query from.
Either create public synonyms to use for those objects or simply create a reporting view that handles the schema for you.
You can NOT dynamically change the schema using SQL. That requires PL/SQL.