Tuesday, May 03, 2011

Manager logFiles

select concurrent_queue_name manager
, fcp.concurrent_process_id pid
,meaning, fcp.logfile_name
from fnd_concurrent_queues fcq
,fnd_concurrent_processes fcp
,fnd_lookups flkup
where fcq.concurrent_queue_id = fcp.concurrent_queue_id
and fcq.application_id = fcp.queue_application_id
and flkup.lookup_code=fcp.process_status_code
and lookup_type ='CP_PROCESS_STATUS_CODE'
and meaning='Active'
order by manager ;

Sukhwinder singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.