OracleAppsDNA

SQL Query to findout Application Tops unix physical path

/*********************************************************
*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;
Exit mobile version