Tuesday, September 4, 2012

Query to see - One particular concurrent program is attached to which all responsibilities

SELECT * FROM Apps.Fnd_responsibility_tl WHERE Responsibility_id IN (SELECT Responsibility_id FROM Apps.Fnd_responsibility WHERE (Request_group_id, Application_id) IN (SELECT Request_group_id, Application_id FROM Apps.Fnd_request_groups Frg WHERE Request_group_id IN (SELECT Request_group_id FROM Apps. Fnd_request_group_units WHERE Request_unit_id IN (SELECT Concurrent_program_id FROM Apps. Fnd_concurrent_programs_vl WHERE Queue_control_flag = 'N' AND User_concurrent_program_name LIKE '%Bridge%Item%'))))