Skip to Main Content

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.

Comments

Sanjay Desai EBS

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;

1 - 1

Post Details

Added on Jun 27 2019
1 comment
1,302 views