Query for salesperson_name in Order Management

Query for salesperson_name in Order Management 

The following query can be used to display the saleperson name as shown in Order Form.


select resource_name as salesperson_name from
jtf_rs_defresources_v j, jtf_rs_salesreps s
where j.resource_id = s.resource_id
AND s.salesrep_id = oe_order_header_all.salesrep_id;