Tuesday, 5 May 2015

Query To Find List Of All Concurrent Programs Assigned To Request Set

SELECT
USER_CONCURRENT_PROGRAM_NAME
FROM  FND_CONCURRENT_PROGRAMS_TL
WHERE CONCURRENT_PROGRAM_ID IN
  (SELECT CONCURRENT_PROGRAM_ID
  FROM FND_REQUEST_SET_PROGRAMS
  WHERE REQUEST_SET_ID =
    (SELECT REQUEST_SET_ID
    FROM FND_REQUEST_SETS_TL
    WHERE UPPER(USER_REQUEST_SET_NAME) = UPPER('<Request Set Name>')
    )
  )

No comments:

Post a Comment