Pending normal jobs running (oracle 11i) in oracle applications

Monday, November 10th, 2008 at 1:28 pm by Jiltin
Filed under: 11i Scripts 

/*
Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications
Backend query is always faster than front end query
Author:      Jay Gopalakrishnan / Jiltin
Input:       none
*/

Download the Code

SELECT
fcr.REQUEST_ID,
fu.user_name,
fcr.PHASE_CODE,
fcr.STATUS_CODE,
(fcr.ACTUAL_COMPLETION_DATE -   fcr.ACTUAL_START_DATE) * 24 * 60 TIME_MINS,
fcpt.USER_CONCURRENT_PROGRAM_NAME,
fcp.CONCURRENT_PROGRAM_NAME,
fcr.ACTUAL_START_DATE,
fcr.ACTUAL_COMPLETION_DATE,
fcp.CONCURRENT_PROGRAM_NAME
FROM
apps.FND_CONCURRENT_REQUESTS FCR,
apps.FND_CONCURRENT_PROGRAMS FCP,
apps.FND_CONCURRENT_PROGRAMS_TL FCPT,
apps.FND_USER FU
WHERE  1=1
AND    fcr.PHASE_CODE = ‘P’  — Pending
AND    fcr.STATUS_CODE = ‘I’ — Normal
AND    fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID
AND    fcpt.CONCURRENT_PROGRAM_ID=fcp.CONCURRENT_PROGRAM_ID
AND    FCR.REQUESTED_BY = FU.USER_ID
ORDER BY fcr.request_id DESC;

Comments