Oracle Applications

Query to check history of a particular Concurrent Program

col progname for a50
set lines 400 pages 400

SELECT fcp.user_concurrent_program_name progName, fcr.phase_code,fcr.status_code,
TO_CHAR (actual_Start_date, 'DD-MON-YYYY HH24:MI:SS') StartDate,
TO_CHAR (actual_completion_date, 'DD-MON-YYYY HH24:MI:SS') EndDate,
request_id RequestId,
(SYSDATE - actual_start_date) * 24 * 60 * 60 ETime
FROM apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_tl fcp,
apps.fnd_user fusr,
gv$session sess
WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcp.language = 'US'
AND fcr.requested_by = fusr.user_id
AND fcr.oracle_session_id = sess.audsid(+)
AND fcp.user_concurrent_program_name like '%&program_name%'
ORDER BY 6 DESC;

========================================================================