/* Formatted on 11/14/2016 2:31:06 PM (QP5 v5.114.809.3010) */
SELECT fu.USER_NAME,
r.responsibility_name,
f.user_menu_name,
me.prompt "Main_Prompt",
me.description "Main_Desc",
metl.prompt "sub_prompt",
metl.description "sub_desc"
FROM apps.fnd_user fu,
apps.fnd_user_resp_groups urg,
apps.fnd_menus_vl f,
apps.fnd_responsibility fr,
apps.fnd_responsibility_tl r,
apps.fnd_menus fm,
apps.fnd_menu_entries fme,
apps.fnd_menu_entries_tl me,
apps.fnd_menus fm2,
apps.fnd_menu_entries fme2,
apps.fnd_menu_entries_tl metl
WHERE 1 = 1 AND fr.menu_id = f.menu_id AND fu.user_id = urg.user_id
AND (urg.responsibility_id = fr.responsibility_id
AND urg.responsibility_application_id = fr.application_id)
AND (fr.responsibility_id = r.responsibility_id
AND fr.application_id = r.application_id)
AND (fme.menu_id = me.menu_id
AND fme.entry_sequence = me.entry_sequence)
AND fr.menu_id = fm.menu_id
AND fm.menu_id = fme.menu_id
AND fme.sub_menu_id = fm2.menu_id
AND fm2.menu_id = fme2.menu_id
AND (fme2.menu_id = metl.menu_id
AND fme2.entry_sequence = metl.entry_sequence)
and fr.RESPONSIBILITY_ID=51348
AND metl.language = 'US'
AND me.language = 'US'
ORDER BY urg.description
SELECT fu.USER_NAME,
r.responsibility_name,
f.user_menu_name,
me.prompt "Main_Prompt",
me.description "Main_Desc",
metl.prompt "sub_prompt",
metl.description "sub_desc"
FROM apps.fnd_user fu,
apps.fnd_user_resp_groups urg,
apps.fnd_menus_vl f,
apps.fnd_responsibility fr,
apps.fnd_responsibility_tl r,
apps.fnd_menus fm,
apps.fnd_menu_entries fme,
apps.fnd_menu_entries_tl me,
apps.fnd_menus fm2,
apps.fnd_menu_entries fme2,
apps.fnd_menu_entries_tl metl
WHERE 1 = 1 AND fr.menu_id = f.menu_id AND fu.user_id = urg.user_id
AND (urg.responsibility_id = fr.responsibility_id
AND urg.responsibility_application_id = fr.application_id)
AND (fr.responsibility_id = r.responsibility_id
AND fr.application_id = r.application_id)
AND (fme.menu_id = me.menu_id
AND fme.entry_sequence = me.entry_sequence)
AND fr.menu_id = fm.menu_id
AND fm.menu_id = fme.menu_id
AND fme.sub_menu_id = fm2.menu_id
AND fm2.menu_id = fme2.menu_id
AND (fme2.menu_id = metl.menu_id
AND fme2.entry_sequence = metl.entry_sequence)
and fr.RESPONSIBILITY_ID=51348
AND metl.language = 'US'
AND me.language = 'US'
ORDER BY urg.description
No comments:
Post a Comment