Technical‎ > ‎Scripts‎ > ‎

Oracle Apps Product Top Directories SQL

There is a very simple and useful query that can help you get the name of the product top and the corresponding directory to which it belongs.

SELECT variable_name,
  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)

This will give you the list of all product tops and their corresponding directories

Free Hit Counters