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')
AND LANGUAGE = 'US'))
AND LANGUAGE = 'US'
Query to fetch concurrent programs in a request set
Posted by
Hareesh Pothuguntla
| Published on 22 February, 2016
| Categories:
SQL Quries for Apps
| Follow us on Facebook | Twitter | Youtube

No comments:
Post a Comment