Query for AR Sales Representative Name in Oracle Fusion

 Hi,

This post is for fetching Sales person name in AR Transactions.

Query:

Select hp.Party_name

from

RA_CUSTOMER_TRX_ALL rcta,

JTF_RS_SALESREPS JRS,

HZ_PARTIES hp

where

rcta.PRIMARY_RESOURCE_SALESREP_ID=JRS.RESOURCE_SALESREP_ID 

and JRS.RESOURCE_ID=hp.PARTY_ID