improve the query performance by using the view
When the visibility flag is 'Y' then the view can be used. This time I joined the view with all tables just to be sure that I will not mess up everything.
When the visibility flag is 'Y' then the view can be used. This time I joined the view with all tables just to be sure that I will not mess up everything.