You can do this in the application. You can create a column with a status to indicate that the line is off and not show anywhere. Or you can use an existing column that indicates this. Obviously if you do not have any data that can be used as a criterion for deciding what to show or not, there is no way.
You can also make a view , but the hits would have to be accessed by view , if you access outside it, access the data you do not want.
In thesis could use a conditional index (partial / filtered), but again, would have to access by it to consider the filter.
Usually this should be planned in the solution as a whole. That is, does not have an automatic way to resolve this .
I imagine you need to keep this data to ensure referential integrity, so any solution to move the data elsewhere does not resolve it.