Oracle Applications – Find responsibilities associated with the users – using sql

Posted by Jiltin     17 February, 2009    5,514 views   

Following sql will help you find the responsibilities associated with the users in oracle applications.

SELECT frt.RESPONSIBILITY_NAME, furg.end_date
FROM
         fnd_user_resp_groups furg,
         FND_RESPONSIBILITY fr,
         fnd_responsibility_tl frt,
         fnd_user fu
WHERE fu.user_name = ‘&&username’
AND   fu.user_id = furg.user_id
AND   furg.responsibility_id = fr.RESPONSIBILITY_ID
AND   frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1

Following Google Searches Lead To This Post: users who have specific responsibility r12
oracle sql user responsibility
script to attach responsibilities in fnd_user
script in oracle + all users login on application
oracle sql to find who has responsibility
oracle applications how to find user responsibility
find function attached to responsibility in Oracle Apps
query users assigned to role oracle
tables for users and responsibity in oracle apps
R12 query to find all functions
oracle apps: users attached to a responsibility
query to find out the oracle user id’s
query for finding assigned responsibility today
Script to get the function,menus of a responsibility in oracle apps
oracle apps how to find user with role
oracle fnd_responsibility
query to find role of a particular user in oracle database
oracle fnd_responsibility tables
oracle AOL responsibilities
apps 11i user and resposibilities tables
find roles for responsibility + oracle
oracle sql to get responsibilities with menus
how to find an Oracle function available under which menu of Oracle apps
what are the oracle tables to get responsibility and menus
HOW TO FIND THE USER WITH A SPECIFIC RESPONSIBILITY IN ORACLCE
how to find name of users in oracle
how to get last login user in oracle apps
oracle table to find responsibility key
check what roles assigned to user in oracle
sql query to find the APPs for particular module
oracle user responsibility sql
oracle user responsibilities sql
script to find out user logged in oracle applications
“responsabilities applications 11i”
oracle 11i list of responsibilities by user
oracle apps list of users and there responsibility query in sql
apps+find responsibility name to which report is attached
finding the user profile for the user logged in Oracle
SQL Query FIND users that have had specific responsibility
11i responsibilities query
in oracle apps how many users in each responsibility
Responsibilities and menus for Oracle R12
oracle financials user with no responsibility +sql
Responsibilities and Menus in Oracle
query to check roles assigned to a user in oracle
check the responsibility of the users
how i will know which Responsibility assigned to user in oracle apps
how to find users assigned to a profile in oracle 11i
oracle fnd user responsibility table
How to check reponsibilities attached for user
sql query to list all the menus, submenus and user-function-names for all responsibilities
fnd_responsibility users
get oracle application id
HOW TO GET RESPONSIBILITY APPLICATION ID IN ORACLE APPS
query for getting all assigned responsibilities in apps
query to check if any user has access to the responsibility in oracle apps
oracle+which users are attached to which profiles
how to find a menu in oracle apps
Query for Responsibilty attached to user in application
Oracle find responsibilities using menu
find menu used by responsibility oracle
find function by responsibility oracle
find responsibilities with a function oracle
report to find the users currently logged in R12
find menu attached to responsibilities
find menu attached to responsiblities
how to find all user with a specific responsiblites
oracle query functions linked to menu
oracle sql script to extract responsibility roles
script for geeting responsibility attached to user in oracle apps
script to find responsibilities in oracle apps
how to find the responsibility associated with user in r12
How to find out responsibiltiy for the particular user in oracle apps
menu responsibility function sql
find the function name in oracle apps
how to find responsibilities of an user
function and responsibility query
fnd responsibilities
query + submenus + oracle applications
check oracle responsibilities
fnd user responsibility query
FND assigned Responsibility
oracle functions list responsibility
query to find responsibilities to a user in 11i
query to find out the report name from fnd table in apps
Responsibilities + menus + oracle applications
query to find application id+oracle
query to find out the legder id,profile name for the given responsibility name
responsibilities tables in oracle
find responsibility from backend in oracle
fnd_user fnd_responsibility
Oracle + responsibilities attached to users
Which table used to find responsibilities assign to application user + Oracle
sql to find a role
oracle find responsibility having a particular function
find the responsibilities associated with the user in oracle
oracle how to find role id
FND_RESPONSIBILITY_TL fnd_user oracle 11i
finding last submenu attached+oracle 11i
query to get all the users under a responsibility oracle
sql context oracle responsibility
query to know the users of oracle apps
get responsability oracle application pl/sql
query to find all users of responsibilities in oracle
oracle fnd table user responsibilities
oracle users responsibilities view
oracle applications r12 responsibilies
how to find attached function to oracle table?
oracle query to find responsibilites
all oracle responsibilities that have the function
attaching function to the menu in oracle apps
how to find the username using lastlogin id in apps
apps find responsibility select fnd_responsibility
Script to find the module name in oracle Apps
oracle apps queries for finding menus
Query to find out the responsibility name which are attached with function in oracle apps
to find the responsibilities in which a particular function is attached
script to find users of a responsibility oracle R12
How to check no of responsibility to specific function in Oracle Apps
Query To Check responsibility assigned to a specific Function in Oracle Apps
how to set the responsibility_id from back end in oracle applications 12i
oracle applications list of menu functions by responsibility
find responsibilities assigned to a user
find responsibilities attached to users oracle
sql query to get assigned resonsibilities in Apps
query to find the responsibilities associated with the users
Oracle apps Find responsibilities assigned
query to find all oracle application users;
how to find responsibility id in oracle apps
oracle apps find all users with particular responsibility
oracle table responsibilites
Sql query to find the USer id from fnd user table in oracle apps
list of responsibilities by menu
oracle ebs discover tables responsibility has
oracle applications responsibilities and menus
oracle applications Script for Responsibilities and Menus
R12 sql script list of logged on users
oracle find all users
query to find responsibilities assigned to users
Responsibility – Menu – Function Query
sql to know the responsibilities assigned to the user
oracle apps 11i vs r12 responsibilities name
FIND ALL ACTIVE USERS ORACLE APPS
how to find the responsibiliti name in oracle apps
sql query to find out function assigned to responisibilities
Oracle Apps + functions associated with respo
link between responsibility and menu in oracle apps
check responsibility oracle
script to find users under a specific responsibility in R12
LAST RESPONSIBILITY USED IN ORACLE APPLICATIONS
user associated to a role in oracle
oracle user responsibilities tables
oracle find out access for responsibilities
apps 11i responsibilities
how to link user and responsibility in oracle apps 11i
how to find current login user in oracle
how to find out user list in oracle
get responsibility from fnd
sql responsibilities functions submenu
oracle applications find select
query to find logged in users and responsibilities
oracle apps sql user responsibilities
oracle apps ,get the current login user id or name
find the list of responsibilities assigned to a user in oracle
responsibility attached with function+oracle
functions attached with responsibility+oracle
oracle query to find functions attached with responsibility
how to add responsibility in oracle apps using sql
query to get the submenus attached to a particualr menu oracle apps
oracle responsibilities apps sql
query for functions under responsibility oracle
oracle r12 get all users with responsibility
query to find responsibility id oracle apps
oracle applications: how to find users who logged in
oracle Query to find the users logged in last 24 hours
how to find modules in oracle applications
linking fnd_user to responsibility
SQL query to find out roles in oracle
Get User name and related assigned responsibilities
how to find a function in responsibility oracle
oracle fnd_user last name
HOW TO FIND RESPONSIBILITIES ATTACHED TO USER ORACLE APPS
How to find user in Oracle through SQL
find function attched with responsibility+oracle apps
find function attached with responsibility+oracle apps
how to get menu name assigned to responsibility in oracle
oracle apps find responsibility
find the responsabilities of functions
oracle apps find all users having responsibility
get application id in R12
find oracle user with associated role
Active Responsibilities query sql
query find responsibilities assigned to oracle users
query to find resposibilities to associated with oracle user
query to find responsibilities to associated with the application user
query to get responsibilities and menus from oracle table
query to get list menus from oracle
query to find responsibility attached to any user in oracle
to find the roles associated for a user in oracle apps
oracle apps table fnd_responsibility
oracle responsibility query
query to find responsibilities in oracle 11i
how to find out resposibility in oracle apps
query to find the roles assigned for a user in oracle
how to find particular user in oracle
query to find oracle submenu attached to menu
adding function in responsibility in oracle applications
how to get oracle roles for a id
Oracle Apps+list of users which are assigned a specific responsibility
query to find role in oracle
user and responsibility table in oracle apps
query responsibility and menu

Post to Twitter  Post to Delicious  Post to Digg    Post to StumbleUpon

Categories : 11i Scripts Tags : ,

Comments

No comments yet.


Leave a comment

(required)

(required)