Background:
Some times you know the concurrent program but you do not know how to access (do not to which responsibility it is attached). In this case, the following query can be helpful
Input:
Concurrent program name
SELECT frv.responsibility_name,fcp.user_concurrent_program_name, frg.*
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcp,
fnd_responsibility_vl frv
WHERE frg.request_group_id = frgu.request_group_id
AND frg.application_id = frgu.application_id
AND frgu.request_unit_id = fcp.concurrent_program_id
AND frgu.unit_application_id = fcp.application_id
AND fcp.user_concurrent_program_name like '<conc program name>'||'%'
and frv.request_group_id=frg.request_group_id
No comments:
Post a Comment