Below query will return the Oracle apps all application’s Top.
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;
Recent Comments