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
