Missing Views from the APEX_DICTIONARY
A long time ago I wrote about how you can list all the apex views by querying APEX_DICTIONARY. They're some views that are still public but are not listed in the Apex Dictionary. The following query lists these views
SELECT SYN.SYNONYM_NAME apex_view_name FROM all_synonyms syn, all_views av, apex_dictionary ad WHERE syn.synonym_name LIKE 'APEX\_%' ESCAPE '\' AND syn.owner = 'PUBLIC' AND SYN.TABLE_NAME = AV.VIEW_NAME AND SYN.SYNONYM_NAME = AD.APEX_VIEW_NAME(+) AND ad.column_id IS NULL ORDER BY syn.synonym_name