Getting Oracle APEX Data Dictionary Views

To list all the data dictionary views available you can run the following query,

select *
from apex_dictionary
where column_id = 0;

The query will return you

APEX_VIEW_NAME - Name of the APEX view
COLUMN_ID              - Column ID, where column id 0 provides the value name
COLUMN_NAME      - This will be null for column id 0, for others it will show the                                               columns available under the view
COMMENTS              - A brief description of the APEX view/column
COMMENT_TYPE    - Indicated whether comment is for the view or column
PARENT_VIEW         - Shows parent view name if there is one

if you omit the filter condition "column_id = 0" then you can view even columns under each view.

If you are only interested with view name not addtional details then following query will be useful

select distinct apex_view_name
from apex_dictionary;

If you wish to get more details about all the privilages granted to public you can visit the "Understanding Privileges Granted to PUBLIC" section of App Builder User's Guide from APEX home page easily https://apex.oracle.com/en/learn/documentation/