EBS Request Group find a responsibility for a program
SELECT user_concurrent_program_name, frt.*
FROM FND_REQUEST_GROUP_UNITS frgu,
FND_REQUEST_GROUPS frg,
fnd_concurrent_programs_tl fcp,
FND_RESPONSIBILITY fr,
FND_RESPONSIBILITY_tl frt
WHERE frgu.REQUEST_GROUP_ID = frg.REQUEST_GROUP_ID
AND frgu.REQUEST_UNIT_ID = fcp.CONCURRENT_PROGRAM_ID
AND upper(user_concurrent_program_name) LIKE upper(‘XXXXXX Organization Report%’)
AND RESPONSIBILITY_NAME like ‘XYZ%’
AND fr.REQUEST_GROUP_ID = frg.REQUEST_GROUP_ID
AND frt.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID;
Read Next