Oracle EBS has a huge and complex database schema with over 20k tables. It is quite hard to navigate it and find the data in tables and columns. What you need for this task is a data dictionary for Oracle EBS database. It comes in a few flavors and I will break it donw for you here.
To find the data you can use standard system catalog / data dictionary views built in every Oracle database. This is what you are probably already using while working with Oracle or other databases.
To browse schema you can use any database tool for this, like Oracle SQL Developer. Those tools however have limited capabilities to search schema.
To get more insight you can use SQL queries to the data dictionary views to analyze and extract information about schema.
Standard Oracle data dictionary gives you list of tables, columns, data types, views, trigges, stored procedures and all the schema elements. However, it doesn't have all you need.
What it is missing is:
There is a solution to this - second data dictionary - FND tables.
Oracle EBS is shipped with its own data dictionary on top of standard Oracle database system catalog. It is accessible through tables in FND schema.
Those tables hold additional information:
Data is available in following tables: