This content has been marked as final. Show 5 replies
Please use the query below for Username and email for IStore Users. Please note this is not my query i found that on the this site(forums.oracle.com).
SELECT distinct a.user_name
FROM apps.FND_USER a
and b.responsibility_name like 'IBE_CUSTOMER'
AND a.end_date IS NULL
AND c.end_date IS NULL
ORDER BY a.user_name