Combine 2 Queries (from SAME table) into a SINGLE query

In SQL Server, you can move the MONO condition from WHERE clause to inline CASE expression block. I hope you can work out a solution in your Oracle along with this line.