I need to develop a query to list all the Salespersons created along with the Operating Unit details they were assigned to.
I came cross below tables
But no table gives sales persons details along with all the OU's they were assigned to.
Can anyone provide table name to list all the sales reps with OU details.?
Thanks in advance.
Table -- RA_SALESREPS_ALL -- itself contains the OU means field name with ORG_ID .
select SALESREP_ID, SALESREP_NUMBER, NAME, ORG_ID from RA_SALESREPS_ALL WHERE ORG_ID = 81;