Query to fetch concurrent programs in a request set

Query to fetch concurrent programs in a request set, www.askhareesh.com

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'


*/

No comments:

Post a Comment