APEX

Hi,

Apex version 3.1.0.00.32
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit

I have a new APEX application and I want to create a drop down list of applications within the new application's workspace using the APEX_APPLICATIONS view to use in the app. The data dictionary comment on the APEX_APPLICATIONS view is "Applications defined in the current workspace or database user." The applications in the workspace have a mixture of parsing schemas / database users.

I want to see all the apps in workspace irrespective of database user, not only apps where the database user is the same as my new application's database user because this is too restricted. However, the view only seems to give apps in the database user.

Other than creating a view of my own in the FLOWS_030100 user and granting access on it, which I'm not keen on, is there a way around this or another view I can use?

Thanks for any suggestions,

Andrew