Query to find Sales Person name in Order Management

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