Mrugesh test report

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

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