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>')
)
)
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