How to find the tables which are registered with Oracle Apps

select * from APPLSYS.FND_TABLES

oracle application module short name and description using back end table

select * from APPLSYS.FND_ORACLE_USERID