Sales Representatives

select
org.name organization_name,
r.resource_name,
s.salesrep_id,
s.salesrep_number,
s.name salesrep_name,
s.status,
s.end_date_active

from
jtf_rs_salesreps s,
jtf_rs_resource_extns_tl r,
hr_all_organization_units org

where
s.resource_id=r.resource_id and
s.org_id=org.organization_id and
r.language='US'