Where is CRM user-customer Account relationship stored in database

[M_Anas_O]

Hi,

When creating and approving a CRM user using CRM HTML admin responsibility, we assign accounts of customer for which user is being created.
For e.g., When creating a user for Customer A having 5 accounts, i can assign account # 1,2 and 3 to the user.

Does anybody know where this mapping is stored in database?

Regards,
Mohammed

[M_Anas_O]

We can use below query to find the accounts assigned to a customer user :

SELECT hca.account_number
FROM hz_cust_accounts hca,
fnd_user fu,
hz_cust_account_roles hcar
WHERE hcar.party_id = fu.customer_id
AND hcar.cust_account_id = hca.cust_account_id
AND fu.user_id = <your user id>
;

Regards,
Mohammed