select a.USER_NAME, a.EMPLOYEE_ID, b.RESPONSIBILITY_ID, c.RESPONSIBILITY_NAME, b.START_DATE, b.END_DATE
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_TL c
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID
and lower(user_name) = 'iftikhar.hussain'
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_TL c
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID
and lower(user_name) = 'iftikhar.hussain'
No comments:
Post a Comment