add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, August 26

Query to get Request group of a program

Using this query we can get the list of request groups to which our concurrent program has been assigned.

select * from fnd_request_groups where request_group_id IN
(
                             SELECT request_group_id
                               FROM fnd_request_group_units
                              WHERE request_unit_id =
                                       (SELECT DISTINCT concurrent_program_id
                                                   FROM fnd_concurrent_programs_tl
                                                  WHERE user_concurrent_program_name =
                                                           '<Concurrent Program Name>'))

No comments: