select distinct tbrd_rate_serial, tbk_date,tbk_booking_number, tbrd_system, tbt_doc_number from
(select TBRD_SYSTEM, tbk_booking_number, TBT_DOC_NUMBER,tbrd_rate_serial,tbk_date
from
id_tb_booking_header, id_tb_trans,id_tb_booking_rate_details,id_tb_service_voucher_header, id_tb_service_voucher_details
where
tbk_booking_number=tbsvd_booking_number
and tbsvd_serial=tbsvh_serial
and tbrd_reference=tbk_reference   -- Including Provider and one more condition
and tbt_book_number=tbk_booking_number
and tbrd_rate_serial=tbsvd_rate_serial
and tbt_book_number=tbsvd_booking_number
and tbrd_sys_type='SV'
and tbrd_status<>'V'
and TBT_BASE_DOC_TYPE='INV')
where tbk_date>'01-JUN-2017'
order by tbk_booking_number 
