Query to get the Registered Tables details in Oracle Apps

select T.APPLICATION_ID,A.APPLICATION_NAME,T.TABLE_ID,T.TABLE_NAME,T.USER_TABLE_NAMEfrom FND_TABLES T, FND_APPLICATION_TL A
where T.APPLICATION_ID=A.APPLICATION_IDand T.CREATED_BY<>1
and T.TABLE_NAME like '&name%';
_____________________________________________________________________

desc FND_TABLES;
desc FND_USER; --User table


desc FND_APPLICATION_TL --Application table
Getting Related FND_ table nams with details from database

select object_name,object_type from all_objects where object_name like 'FND_%' and object_type like 'TABLE'; 

-- Query to getting registered table's details in Oracle apps