SELECT *
FROM fnd_menus_tl
WHERE menu_id IN
(
SELECT DISTINCT menu_id
FROM fnd_responsibility_vl frv
,fnd_responsibility_tl ftr
WHERE frv.responsibility_id = frt.responsibility_id
AND frt.responsibility_name LIKE 'NUAN%Order%'
AND frt.responsibility_name NOT LIKE '%Setup Only'
AND frt.responsibility_name NOT LIKE '%Inquiry'
)
No comments:
Post a Comment