How to know user_id, Responsibility_id,application _id in oracle

--HOW TO KNOW ABOUT USER_ID:

select user_id from fnd_user
where user_name='XYZ';
/

--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=21623;
/

No comments:

Post a Comment

WIP Tables with description

  Table Name Description     WIP_ACCOUNTING_CLASSES stores accounting flexfield information for standard discrete jobs, non-standard asset j...