Column OsId Format A7
Column Oracle_Process_ID Format 99999
Column Concurrent_Queue_Name Format A20
Column Log Format A25
Column Started_At Format A20Set Head Off
Set Verify Off
Set Echo OffSelect
'The ' || Concurrent_Queue_Name ||
' concurrent manager ran your request from',
to_char(Actual_Start_date, ' MON-DD-YY HH:MI:SS AM') || ' – to – ' ||
to_char(Actual_COMPLETION_date, 'MON-DD-YY HH:MI:SS AM'),
'The ' || Concurrent_Queue_Name ||
' concurrent manager log file is ' || P.Logfile_Name,
'Request log file is ' || R.Logfile_Name
From Fnd_Concurrent_Queues Q,
Fnd_Concurrent_requests R,
Fnd_Concurrent_Processes P
Where
(P.Concurrent_Queue_ID = Q.Concurrent_Queue_ID And
Queue_Application_ID = Q.Application_ID )
And R.Controlling_Manager = P.Concurrent_Process_ID
And R.Phase_Code = 'C'
And Request_ID = &Request_ID
;
set head on