SQL Query to findout Application Tops unix physical path

By | March 12, 2013
/*********************************************************
*PURPOSE: To list physical path of APPL_TOPs in unix     *
*          and its Parameters                            *
*AUTHOR: Shailender Thallam                              *
**********************************************************/
 SELECT variable_name,
  VALUE
   FROM fnd_env_context
  WHERE variable_name LIKE 'AP\_TOP' ESCAPE '\'
 AND concurrent_process_id =
  (SELECT MAX(concurrent_process_id) FROM fnd_env_context
  )
 ORDER BY 1;
WOW! Did you like this post? We'll send more interesting posts like SQL Query to findout Application Tops unix physical path to you!
Enter your Email Address: