SELECT t.*
FROM apps.FND_REQUEST_SETS_TL t
WHERE request_set_id IN
(SELECT request_set_id
FROM apps.FND_REQUEST_SET_PROGRAMS
WHERE concurrent_program_id =
(SELECT CONCURRENT_PROGRAM_ID
FROM apps.fnd_concurrent_programs_tl
WHERE language = 'US'
AND upper(USER_CONCURRENT_PROGRAM_NAME) = UPPER('ENTER_YOUR_CP_NAME') ) )
No comments:
Post a Comment