Category: System Administrator

Oracle SQL Query to list all the responsibilities attached to a user in oracle apps

Please find below the Query to  list all the responsibilities attached to a user SELECT FND_USER.USER_NAME,        FND_USER.EMAIL_ADDRESS,        FND_RESP_TL.RESPONSIBILITY_NAME,        FND_USER_RESP_GRP.START_DATE,        FND_USER_RESP_GRP.END_DATE        FROM         FND_USER FND_USER,         FND_USER_RESP_GROUPS_DIRECT FND_USER_RESP_GRP,         FND_RESPONSIBILITY_TL FND_RESP_TL WHERE FND_USER.USER_NAME = :USER_NAME AND

Continue reading
Copy Protected by Chetan's WP-Copyprotect.