Wednesday, March 27, 2013

Menu attached to Responsibilities



SELECT DISTINCT a.responsibility_name, c.user_menu_name
FROM apps.fnd_responsibility_tl a,
apps.fnd_responsibility b,
apps.fnd_menus_tl c,
apps.fnd_menus d,
apps.fnd_application_tl e,
apps.fnd_application f
WHERE a.responsibility_id(+) = b.responsibility_id
AND a.responsibility_id = ‘20538’
AND b.menu_id = c.menu_id
AND b.menu_id = d.menu_id
AND e.application_id = f.application_id
AND f.application_id = b.application_id
AND a.LANGUAGE = 'US';

1 comment:

  1. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.

    oracle training in bangalore

    ReplyDelete

Note: Only a member of this blog may post a comment.