select form_file_id from bp.form_meta_description where start_date >= to_date('01/06/2017', 'dd/mm/yyyy'))
or id in
(
select form_file_id from bp.form_data where object_edit_date > (sysdate - 180)
and alternative_id in (select alternative_id from bp.api_bp_formdata_date
where form_date in ( to_date('01/06/2018', 'dd/mm/yyyy'), to_date('01/08/2018', 'dd/mm/yyyy'), to_date('01/09/2018', 'dd/mm/yyyy'), to_date('01/01/2018', 'dd/mm/yyyy'), to_date('05/03/2018', 'dd/mm/yyyy'), to_date('30/05/2018', 'dd/mm/yyyy'), to_date('07/03/2017', 'dd/mm/yyyy'), to_date('13/08/2017', 'dd/mm/yyyy'), to_date('17/11/2017', 'dd/mm/yyyy'), to_date('13/03/2018', 'dd/mm/yyyy'), to_date('06/09/2018', 'dd/mm/yyyy'), to_date('07/05/2018', 'dd/mm/yyyy'), to_date('27/07/2018', 'dd/mm/yyyy')))
or alternative_id not in (select fdate.alternative_id from bp.api_bp_formdata_date fdate) )
or id in (select da.form_file_id from bp.form_data_addition da)
or id in (select dar.form_file_id from bp.form_data_archive dar