/*********************************************************
*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; |
/*********************************************************
*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;