select * from apex_applications where workspace = 'MY_WORKSPACE';
-- 0 rows
When logged into APEX as a user with a workspace assigned (MY_WORKSPACE) that contains an application (and an application alias), no rows are returned when given the application alias in the query above (see the above SQL).
But log in as SYS and the application alias is there -- i.e. a row is returned.