Human Capital Management - EBS (MOSC)

MOSC Banner

query to get salesrep name of a customer

edited Jan 9, 2019 12:37PM in Human Capital Management - EBS (MOSC) 3 commentsAnswered ✓

Hello Gurus

(oracle ebs r 12) I am trying to write a query to get Sales rep (Bill To, Ship To) for customers, i got primary_salesrep_id in hz_cust_site_uses_all table. Now the challenge to get name. I look into jtf_rs_salesreps, but this table is not updated for all names.

then i connect it to PER_ALL_PEOPLE_F thru employee_number, still i cannot get all names. seems like tables are not updated. Name column shows null in it.

i get behind oracle java pages and get the query. it uses a table ra_salesreps. when i query this table, it didnt even exists. Can someone please help me get Sales rep Name thru Primary _salesrep_id.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center