SELECT s.str_value title,
       osr.module_id,
       osr.gui_user_id,
       m.graphical_symbol,
       osr.oc_scheduled_report_id,
       osr.ac_named_schedule_id,
       ans.hours,
       ans.minutes,
       ans.days,
       ans.months,
       ans.weekdays,
       osr.email_to,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'period'
       ) periode,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'report_format'
       ) report_format,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'gen_gu_message'
       ) buildixxMessenger,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'vehicle_owner_id'
       ) vehicleOwner,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'vo_vehicle_category_id'
       ) vehicleCategory,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'vehicle_id'
       ) vehicle,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'oc_poi_category_id'
       ) poiCategory,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'poi_id'
       ) poi,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'vo_person_category_id'
       ) personCategory,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'person_id'
       ) person,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'oc_aggreg_admin_status_id'
       ) status,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'poi_tin'
       ) poiTin,
         (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'so_transaction_status_id'
       ) soTransactionStatus,
       (SELECT osrp.param_value
       FROM oc_sched_report_param osrp
       WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
       AND osrp.param_name = 'showAllPpl') showAllPpl,
       (SELECT osrp.param_value
        FROM oc_sched_report_param osrp
        WHERE osrp.oc_scheduled_report_id = osr.oc_scheduled_report_id
        AND osrp.param_name = 'voGroup'
       ) vo_groups
FROM oc_scheduled_report osr, module m, ac_named_schedule ans, gui_users gu, str s
WHERE osr.module_id = m.module_id
AND osr.gui_user_id = gu.gui_user_id
AND gu.gui_user_id = 101263
AND m.title_str_id = s.str_id
AND s.language = gu.language
AND osr.ac_named_schedule_id = ans.ac_named_schedule_id
ORDER BY OC_SCHEDULED_REPORT_ID;