SQL Query to get all the tables in Oracle Fusion.

 Here is the sample query to get all the tables in Oracle fusion.

SELECT table_name

FROM all_tables

WHERE owner = 'FUSION';