SELECT frt.responsibility_name ,
fm.menu_id ,
fm.menu_name
FROM fnd_menus fm ,
fnd_responsibility fr ,
fnd_responsibility_tl frt
WHERE fm.menu_id = fr.menu_id
AND fr.responsibility_id = frt.responsibility_id
AND fr.responsibility_id = frt.responsibility_id
AND frt.responsibility_name = 'Receivables Manager'
Saturday, January 29, 2022
Query to get all menu names in oracle apps
Subscribe to:
Post Comments (Atom)
-
Approval Management Engine FAQ 1. AME – What is it? i. AME is a simple to use Rules Engine for Defining Approval Policy ii. AME is ...
-
Register Custom Tables in Oracle Apps Say you have a custom table called “ERPS_EMPL...
-
OU & ORG ID & ORG CODE & ORG NAME ================================== select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE...
No comments:
Post a Comment