/* Formatted on 7/17/2014 5:37:50 PM (QP5 v5.115.810.9015) */
SELECT a.menu_id,
menu_name,
c.responsibility_name,
g.user_name,
g.description
FROM fnd_menu_entries a,
fnd_menus b,
fnd_responsibility_vl c,
fnd_form_functions d,
fnd_form_vl e,
fnd_user_resp_groups f,
fnd_user g
WHERE e.form_name LIKE '%'
AND e.form_id = d.form_id
AND d.function_id = a.function_id
AND a.menu_id = b.menu_id
AND a.menu_id = c.menu_id
AND c.responsibility_id = f.responsibility_id
AND f.user_id = g.user_id
ORDER BY 1, 2, 3, 4
SELECT a.menu_id,
menu_name,
c.responsibility_name,
g.user_name,
g.description
FROM fnd_menu_entries a,
fnd_menus b,
fnd_responsibility_vl c,
fnd_form_functions d,
fnd_form_vl e,
fnd_user_resp_groups f,
fnd_user g
WHERE e.form_name LIKE '%'
AND e.form_id = d.form_id
AND d.function_id = a.function_id
AND a.menu_id = b.menu_id
AND a.menu_id = c.menu_id
AND c.responsibility_id = f.responsibility_id
AND f.user_id = g.user_id
ORDER BY 1, 2, 3, 4
Thanks For sharing this Superb article.I use this Article to show my assignment in college.it is useful For me Great Work. buy biometric access control
ReplyDelete