SQL Query to retrieve the name and location of the latest Notification Mailer log file in EBS

SQL Query  to retrieve the name and location of the latest Notification Mailer log file in EBS

Query:

SELECT logfile_name
 FROM fnd_concurrent_processes  
 WHERE process_status_code = 'A'
 AND concurrent_queue_id in
 (SELECT concurrent_queue_id from fnd_concurrent_queues
 WHERE concurrent_queue_name in ( 'WFMLRSVC'));

If you like please follow and comment