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:
Post Comments (Atom)
2 comments:
I like the helpful information you provide in your articles.
I'll bookmark your blog and check again here frequently. I am quite certain I will learn many new stuff right here! Good luck for the next!
my web page ... healthy diet plans
Amazing things here. I'm very glad to see your article. Thanks so much and I am taking a look ahead to contact you. Will you please drop me a e-mail?
Feel free to visit my weblog :: win roulette
Post a Comment