1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Where is CRM user-customer Account relationship stored in database

Discussion in 'Oracle CRM' started by M_Anas_O, Jan 29, 2010.

  1. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    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
     
  2. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    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