How to List Responsibility And Request Group in Oracle Applications 11i

   Use following SQL Report to list responsibilities and attached request groups. In oracle apps Users submit concurrent request based on the Request group assigned to thier responsibility.

COLUMN responsibility_name format a40 heading "Responsibility Name"
COLUMN request_group_name format a40 heading "Request Group Name"
COLUMN description format a60 heading "Request Group Detail"
BREAK on responsibility_name SKIP 1 ON request_group_name SKIP 1
SET feedback off
SET linesize 1000
SELECT 'Report Date: ' SYSDATE FROM DUAL;
SELECT frv.responsibility_name,
frg.request_group_name,
frg.description
FROM fnd_request_groups frg, fnd_responsibility_vl frv
WHERE frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name;


Use Following SQL report to list Responsibilities, Request Group and Concurrent requests for each Request Group.


COLUMN responsibility_name format a40 heading "Responsibility Name"
COLUMN request_group_name format a40 heading "Request Group Name"
COLUMN DESCR format a60 heading "Request Group Detail"
COLUMN user_concurrent_program_name format a60 heading "Concurrent Program"
COLUMN Description format a60 heading "Concurrent Program Detail"
BREAK on responsibility_name SKIP 1 ON request_group_name SKIP 1 on DESCR
SET feedback off
SET linesize 1000
SELECT 'Report Date: ' SYSDATE FROM DUAL;
SELECT frv.responsibility_name, frg.request_group_name,
frg.description descr, fcpv.user_concurrent_program_name,
fcpv.description
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv
WHERE frgu.request_unit_type = 'P'
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpv.concurrent_program_id
AND frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name, frg.request_group_name, frg.description