Oracle e-business How to Obtain Environment Variable value using sql query

Technical‎ > ‎Scripts‎ > ‎

There is a very simple query to find the environment variable being used by a concurrent program:

SELECT variable_name,

VALUE

FROM apps.fnd_env_context

WHERE variable_name in ('AF_CLASSPATH','CLASSPATH','JAVA_TOP')

AND concurrent_process_id =

(SELECT MAX(concurrent_process_id)

FROM apps.fnd_env_context)

ORDER BY 1;