学步园

Get APPL_TOP
select name,
       node_id,
       path,
       shared,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       FILE_SYSTEM_GUID,
       appl_top_guid
FROM APPLSYS.FND_APPL_TOPS;

Get <PROD>_TOP
select variable_name,
       value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;