select attachment_number,delete_flag,filename,fi.ifs_filepath,
file_size,f.CREATED from attachment a,files f, version_file_map vfm,version v, FILE_INFO fi

where (f.id=vfm.file_id) and f.id=fi.file_id
and (vfm.version_id=v.id)
and (v.attach_id=a.id)
and
f.CREATED > to_date(’05-Mar-2019′,’DD-MON-YYYY’)
and v.checkin_user in (‘110246201’)
order by f.CREATED desc;