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%'))))
Subscribe to:
Posts (Atom)