add

About Me

My photo
Oracle Apps - Techno Functional consultant

Tuesday, June 21

Menus Responsibilities Query

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: