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,
       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;

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











Free Hit Counters