SELECT t.responsibility_id,
t.responsibility_key,
t.responsibility_name,
t.description,
t.menu_id,
frg.request_group_name, ---- 请求组名称
frg.description requestdsc, ---- 请求组描述
fcp.user_concurrent_program_name, ---请求并发程序名
fcp.CONCURRENT_PROGRAM_NAME,
decode(fcp.EXECUTION_METHOD_CODE,
'H',
'主机',
'S',
'立即',
'J',
'Java 存储过程',
'K',
'Java 并发程序',
'M',
'多语言功能',
'P',
'Oracle Reports',
'I',
'PL/SQL 存储过程',
'B',
'请求集阶段函数',
'A',
'派生',
'L',
'SQL*Loader 程序',
'Q',
'SQL*Plus',
'E',
'Perl 并发程序'),
f.EXECUTION_FILE_NAME
FROM fnd_responsibility_vl t,
fnd_request_groups frg,
FND_REQUEST_GROUP_UNITS frgu,
FND_CONCURRENT_PROGRAMS_VL fcp,
FND_EXECUTABLES_FORM_V f
WHERE SYSDATE BETWEEN nvl(t.start_date, SYSDATE - 1) AND
nvl(t.end_date, SYSDATE + 1)
and t.request_group_id = frg.request_group_id(+)
and t.group_application_id = frg.application_ID(+)
and frgu.application_id(+) = frg.application_ID
and frg.request_group_id = frgu.request_group_id(+)
and fcp.CONCURRENT_PROGRAM_ID = frgu.REQUEST_UNIT_ID
and frgu.UNIT_application_id = fcp.application_id
and fcp.ENABLED_FLAG = 'Y'
and f.EXECUTABLE_ID = fcp.EXECUTABLE_ID