This content has been marked as final. Show 5 replies
Do you mean u want to know what are the tables the users of iStore gets stored?
What do you mean by "Custom table" ?
Do you have any idea regarding the user registration table, not the custom table.
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
Even one of our BA provided me the query.