SELECT CASE WHEN GROUPING(col.catalog_no) = 1
            THEN 'Customer ' || co.customer_no || ', ' || ci.name
            ELSE 'Part ' || col.catalog_no || ', ' || col.catalog_desc || ', qty ' || col.buy_qty_due
        END AS data_row
  FROM customer_order co
 INNER JOIN customer_info ci
    ON ci.customer_id = co.customer_no
 INNER JOIN customer_order_line col
    ON col.order_no = co.order_no
GROUP BY GROUPING SETS ((co.customer_no, ci.name),
                        (co.customer_no, ci.name, col.catalog_no, col.catalog_desc, col.buy_qty_due))
 ORDER BY co.customer_no ASC, GROUPING(col.catalog_no) DESC;