Query to find the responsibilities which can run the concurrent program
-- input: Concurrent Program name
SELECT frv.responsibility_name
FROM apps.fnd_request_group_units frgu,
apps.fnd_responsibility_vl frv,
apps.fnd_concurrent_programs_vl fcpv
WHERE frv.REQUEST_GROUP_ID = frgu.REQUEST_GROUP_ID
AND fcpv.concurrent_program_id = frgu.REQUEST_UNIT_ID
AND NVL (frv.end_date, SYSDATE + 1) > SYSDATE
AND EXISTS
(SELECT 'Y'
FROM apps.fnd_user_resp_groups grps
WHERE grps.responsibility_id = frv.responsibility_id
AND NVL (grps.end_date, SYSDATE + 1) > SYSDATE)
AND fcpv.user_concurrent_program_name like '%'||:Program_Name||'%'
Order By 1
-- input: Concurrent Program name
SELECT frv.responsibility_name
FROM apps.fnd_request_group_units frgu,
apps.fnd_responsibility_vl frv,
apps.fnd_concurrent_programs_vl fcpv
WHERE frv.REQUEST_GROUP_ID = frgu.REQUEST_GROUP_ID
AND fcpv.concurrent_program_id = frgu.REQUEST_UNIT_ID
AND NVL (frv.end_date, SYSDATE + 1) > SYSDATE
AND EXISTS
(SELECT 'Y'
FROM apps.fnd_user_resp_groups grps
WHERE grps.responsibility_id = frv.responsibility_id
AND NVL (grps.end_date, SYSDATE + 1) > SYSDATE)
AND fcpv.user_concurrent_program_name like '%'||:Program_Name||'%'
Order By 1
No comments:
Post a Comment