View with WITH | How to access data Select within a Select | How to define common Select and Use it in main Select statement

WITH cust_info AS (SELECT co.order_no
                   FROM   customer_order_tab co)
SELECT t1.*
FROM   cust_info t1
UNION
SELECT t2.*
FROM   cust_info t2;