Saturday, July 11, 2015

To find from which responsibility a concurrent program can be run

select distinct
   a.user_concurrent_program_name,
   a.description,
   request_group_name,
   e.responsibility_name
from
   fnd_concurrent_programs_tl a,
   fnd_request_groups b,
   fnd_request_group_units c,
   fnd_responsibility d,
   fnd_responsibility_tl e
where
   a.concurrent_program_id = c.request_unit_id   
and b.request_group_id = c.request_group_id
and b.request_group_id = d.request_group_id
and d.responsibility_id = e.responsibility_id
and a.application_id = b.application_id
and b.application_id = c.application_id
and d.application_id = e.application_id
and a.concurrent_program_id = :p_conc_program_id

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect