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