How to get Page Name given Page ID in Oracle Application Express
Everything you want (and a lot more) is available in the view APEX_050000.APEX_APPLICATION_PAGES

SYS@mydb01&gt; describe apex_050000.APEX_APPLICATION_PAGES
Name                        Null?    Type
--------------------------- -------- -------------------------------------
WORKSPACE                   NOT NULL VARCHAR2(255)
WORKSPACE_DISPLAY_NAME               VARCHAR2(4000)
APPLICATION_ID              NOT NULL NUMBER
APPLICATION_NAME            NOT NULL VARCHAR2(255)
PAGE_ID                     NOT NULL NUMBER
PAGE_NAME                   NOT NULL VARCHAR2(255)
PAGE_TITLE                           VARCHAR2(255)
PAGE_MODE                            VARCHAR2(16)
...
PAGE_ALIAS                           VARCHAR2(255)


And a sample query would be 

select WORKSPACE, APPLICATION_NAME, 
   PAGE_ID, PAGE_NAME, PAGE_TITLE, PAGE_MODE 
from  APEX_050000.APEX_APPLICATION_PAGES
where workspace  = 'MY_WS' and page_id=210;


There is a built-in substitution string APP_PAGE_ID and APP_ID, so you could do this in your page to use the current page ID and application ID to get the page title:

select PAGE_TITLE from APEX_050000.APEX_APPLICATION_PAGES
where PAGE_ID = :APP_PAGE_ID and APPLICATION_ID = :APP_ID;


See https://docs.oracle.com/cd/E59726_01/doc.50/e39147/concept_sub.htm#BEIIBAJD for all the built-in substitution strings.