Table "ALL_TABLES" - does not include all tables?

Content

Hi,

When I run a query in BI Publisher Enterprise, I can for example, get results from this query:

SELECT DISTINCT UPPER(table_name), num_rows
FROM all_tables
WHERE num_rows > 0
AND UPPER(table_name) like 'PJC%'
ORDER BY num_rows DESC

However, some tables are not in ALL_TABLES yet I can still run searches against them - e.g.

• FND_GRANTS
• FND_OBJECTS_VL
• ASE_ROLE_B
• ASE_ROLE_ROLE_MBR

If I can't search for those tables in ALL_TABLES, how can I know they are there, other than e.g. checking Oracle Docs - examples: