ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 17DFF0B3BC5B0714E06362FB0905CDDB select x.id,x.value,x.description from ( select 'Default' id, 'Default' value, 'Default' description, 1 sort_no from dual union all select frv.responsibility_key id, frv.responsibility_name value, fav.application_short_name description, 2 sort_no from fnd_form_functions_vl fffv, fnd_application_vl fav, fnd_responsibility_vl frv, fnd_compiled_menu_functions fcmf where 1=1 and fffv.function_name='XLA_LINESINQ_GL_DRILLDOWN' and fffv.function_id=fcmf.function_id and frv.menu_id=fcmf.menu_id and nvl(fcmf.grant_flag,'Y')='Y' and frv.application_id=fav.application_id(+) and (frv.application_id,frv.responsibility_id) in ( select furg.responsibility_application_id, furg.responsibility_id from fnd_user fu, fnd_user_resp_groups furg where fu.user_name='SESA479319' and fu.user_id=furg.user_id ) ) x order by x.sort_no, x.id Y US Mrugesh test report 1=1