title: Query to retrieve all Oracle APEX application IDs and workspaces
body: <p>Is there a means of querying a database environment to retrieve all Oracle APEX application IDs, together with the workspace name they belong to?</p>
  
  <p>I basically want to create an LOV within an Oracle APEX app that can see all APEX application IDs and Workspaces.</p>
  
  <p>I tried the APEX_APPLICATIONS view but that only displays info within the workspace you are in. I want to see all workspaces and application ids.</p>