Tuesday 9 May 2017

Oracle WINSCP path finding Query for all modules

select * from fnd_env_context


/* Formatted on 5/9/2017 2:55:28 PM (QP5 v5.114.809.3010) */
  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

 

No comments:

Post a Comment