Friday, October 28, 2011
Query to Find Responsibilities based on Concurrent Request set name
-- Query to find the Responsibilities based on Concurrent
Request set Name
SELECT UNIQUE frt.responsibility_name, frg.request_group_name,
frsv.user_request_set_name
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups
frg,
fnd_request_group_units frgu,
fnd_request_sets_vl
frsv
WHERE fr.request_group_id = frg.request_group_id
AND fr.responsibility_id = frt.responsibility_id
AND frg.request_group_id = frgu.request_group_id
AND frgu.request_unit_id = frsv.request_set_id
AND frsv.user_request_set_name LIKE 'give user request set name'
AND frsv.request_set_name LIKE 'request set name';
-- Query to find the Responsibilities based on Concurrent
Program Name
SELECT UNIQUE frt.responsibility_name, frg.request_group_name,
fcpt.user_concurrent_program_name
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups
frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt
WHERE fr.responsibility_id = frt.responsibility_id
AND fr.request_group_id = frg.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND frt.LANGUAGE = 'US'
AND fcpt.user_concurrent_program_name LIKE
'Your Concurrent Program Name'
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “Query to Find Responsibilities based on Concurrent Request set name”
Post a Comment