Wednesday 3 February 2016

How to know about user id,responsibility id, application id in oracle

HOW TO KNOW ABOUT USER_ID:

select user_id from fnd_user
where user_name='abc';


HOW TO KNOW ABOUT RESPONSIBILITY_ID:

select responsibility_id from fnd_responsibility_vl
where responsibility_name like 'Order Management Super User%Vision Operations%USA%';


HOW TO ABOUT APPLICATION_ID:

select * from fnd_responsibility_vl
where responsibility_id=223;



No comments:

Post a Comment