Employers Query

SELECT hr.hr_locations_all_tl.location_code "Location",

       hr.hr_all_organization_units.NAME "Department",

       hr.per_all_people_f.employee_number "Employee Number",

       hr.per_all_people_f.person_id "Person Id",

       hr.per_all_people_f.person_type_id "Person Type Id",

       hr.per_all_people_f.business_group_id "Business Group Id",

          hr.per_all_people_f.title

       || hr.per_all_people_f.first_name

       || ' '

       || hr.per_all_people_f.middle_names

       || ' '

       || hr.per_all_people_f.last_name

          "Employee Name",

       hr.per_jobs.NAME "Job",

       hr.per_all_people_f.email_address,

       hr.per_all_people_f.start_date

  FROM hr.per_all_people_f,

       hr.per_all_assignments_f,

       hr.hr_all_organization_units,

       hr.per_jobs,

       hr.hr_locations_all_tl

 WHERE ( (hr.per_all_assignments_f.organization_id =

             hr.hr_all_organization_units.organization_id)

        AND (hr.per_all_assignments_f.job_id = hr.per_jobs.job_id)

        AND (hr.per_all_people_f.person_id =

                hr.per_all_assignments_f.person_id)

        AND (hr.per_all_assignments_f.location_id =

                hr.hr_locations_all_tl.location_id))

Output