query to get salesrep name of a customer
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.