Sales

Get Involved. Join the Conversation.

Topic

    Reghu
    Whats the name of the table in which Account hierarchy is...Answered
    Topic posted May 29, 2019 by ReghuBronze Crown: 15,000+ Points, tagged Core SFA, Customer Data Mgmt 
    63 Views, 2 Comments
    Title:
    Whats the name of the table in which Account hierarchy is stored?
    Summary:
    Whats the name of the table in which Account hierarchy is stored?
    Content:

    Whats the name of the table in which Account hierarchy is stored?

    Best Comment

    vinda desai

    Hi Reghu,

     

    If you are looking to query the data of the hierarchy you can check for FND_TREE_NODE and see if this helps.

    You can use the clause TREE_STRUCTURE_CODE = 'HZ_CUSTOMER_HIERARCHY' 

    more details available at-

    https://docs.oracle.com/en/cloud/saas/applications-common/18c/oedma/FND_TREE_NODE-tbl.html

    Comment