Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF): Query for AR Sales Representative Name in Oracle Fusion

Thursday, January 18, 2024

Query for AR Sales Representative Name in Oracle Fusion

SELECT hp.party_name sales_representative

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)