Saturday, July 11, 2015

Query to get request set concurrent programs

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

Best Blogger TipsGet Flower Effect