responsibilities attached to a user

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 FND_USER_RESP_GRP.USER_ID = FND_USER.USER_ID AND FND_USER_RESP_GRP.RESPONSIBILITY_ID = FND_RESP_TL.RESPONSIBILITY_ID AND FND_RESP_TL.LANGUAGE = ‘US’ SQL to get the […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.