The jtf_rs_salesreps table is used to store the Sales Order sales representative records. We get the information of the sales individual created in the Oracle application in this table that will be further allocated to the AR invoice at the time of development of the invoice. Basically, information about the sales person is used to determine the person’s commission. Here below, in oracle apps r12, I share the Sales Rep table.
Important Salesperson Table in Oracle Apps R12
Query to find Sales person details in Oracle Apps R12
SELECT jrd.resource_name as salesperson_name FROM oe_order_headers_all ooh ,jtf_rs_salesreps jrs ,jtf_rs_defresources_v jrd WHERE ooh.salesrep_id = jrs.salesrep_id AND jrs.resource_id = jrd.resource_id ORDER BY ooh.order_number