this very simple and useful query will give you the list of all product tops and their corresponding directories :
select variable_name, value
from apps.fnd_env_context
where variable_name like '%_TOP' escape ''
and concurrent_process_id = (select max (concurrent_process_id)
from apps.fnd_env_context)
order by 1;
