Wednesday, 11 September 2013

Script to find Scheduled concurrent programs and request sets

/* Formatted on 9/11/2013 9:26:01 AM (QP5 v5.114.809.3010) */
  SELECT   A.REQUEST_ID,
           B.USER_NAME,
           C.USER_CONCURRENT_PROGRAM_NAME,
           C.ARGUMENT_TEXT
    FROM   FND_CONCURRENT_REQUESTS A, FND_USER B, FND_CONC_REQ_SUMMARY_V C
   WHERE       B.USER_ID = A.REQUESTED_BY
           AND A.REQUEST_ID = C.REQUEST_ID
           AND A.REQUESTED_START_DATE > SYSDATE
           AND A.HOLD_FLAG = 'N'
           AND A.STATUS_CODE IN ('Q', 'I')
           AND B.USER_NAME LIKE '%'
           AND A.DESCRIPTION LIKE '%'
ORDER BY   A.REQUEST_ID

No comments:

Post a Comment