Query To Get Internal Manager (ICM) Log File Location

This Query only retrieves the location of the Internal Manager Log file for review against issues.

SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM    fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE   fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND     fcp.queue_application_id = fcq.application_id
AND     fcq.manager_type = '0'
AND     fcp.process_status_code = 'A';