How can we create sales person hierarchy in oracle.
I am having below business scenario for which i need to create sales person hierarchy.
Would like to know in which Oracle module how can we create sales person hierarchy.
Business Case:
There are different levels of sales person in the organization. Each sales person reports to his immediate superior as part of sales hierarchy.
Example: Sales hierarchy is as below:
Sales person
ASM
DSM
NSM
etc.
Actual sales is done by the ground level sales person. 10 sales person reports to ASM. 3 ASM's reports to DSM. 2 DSM's report to ASM.
Depending upon the sales of the ground level person, the sales of the person higher in the hierarchy will be calculated.