E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sales Person Tables

San The ExplorerJun 27 2019 — edited Feb 8 2021

Hi,

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

1. jtf_rs_salesreps

2. ra_salesreps_all

3. jtf_rs_defresources_v

4.RA_SALESREPS

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.

Added on Jun 27 2019

#general-scm-discussion, #supply-chain-management-scm

1 comment

1,310 views