Query for Concurrent program run details

Query for Concurrent program run details


SELECT DISTINCT R.REQUEST_DATE,
  R.REQUEST_ID REQUEST,
  R.STATUS_CODE,
  R.PHASE_CODE,
  F.USER_NAME USERNAME,
  (R.ACTUAL_COMPLETION_DATE - R.ACTUAL_START_DATE) * 1440 ELAPSED,
  R.ARGUMENT_TEXT PROGRAM_PARAMETERS,
  C.USER_CONCURRENT_PROGRAM_NAME,
  RR.RESPONSIBILITY_NAME,
  R.CONTROLLING_MANAGER
FROM apps.FND_CONCURRENT_REQUESTS R,
  apps. FND_USER F,
  apps.FND_CONCURRENT_PROGRAMS_TL C,
  apps.FND_RESPONSIBILITY_TL RR
WHERE --R.REQUEST_ID = '&&' AND /* Enter request id */
  C.USER_CONCURRENT_PROGRAM_NAME = '&&' AND /* Enter Request Name */
  R.STATUS_CODE IN ('F', 'I') AND
  R.PHASE_CODE = 'P' AND
  C.CONCURRENT_PROGRAM_ID           = R.CONCURRENT_PROGRAM_ID
AND R.REQUESTED_BY                  = F.USER_ID
AND R.RESPONSIBILITY_ID             = RR.RESPONSIBILITY_ID
AND TRUNC(R.REQUEST_DATE)           = TRUNC(SYSDATE)
AND R.RESPONSIBILITY_APPLICATION_ID = RR.APPLICATION_ID
ORDER BY R.REQUEST_ID DESC;