WWV_FLOWS TABLE

If you want to see all workspaces with its applications and parsing schemas, then you can select the WWV_FLOWS table in the Apex owner schema, like apex_040200 (for apex 4.2.x).

Select * from apex_040200.wwv_flows;

You need:
grant select on apex_040200.wwv_flows to parsing_schema;
if you want to see a result set.

An alternative way is to select the Apex view APEX_APPLICATIONS.
To see all workspaces you need thereby the role APEX_ADMINISTRATOR_ROLE .