Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table c_orderline(c_order_id int, qtyordered int, c_orderline_id int)
create table c_order(c_order_id int, totallines int, documentno int, c_bpartner_id int
,issotrx varchar(20), docstatus varchar(20), salesrep_id int, dateordered date)
create table c_bpartner (c_bpartner_id int, name varchar(40))
create table c_invoiceline(c_orderline_id int)
SELECT
    cor.c_order_id, cor.totallines,cor.documentno,cbp.name
FROM
    c_orderline   col
    LEFT JOIN c_order       cor ON cor.c_order_id = col.c_order_id
    LEFT join c_bpartner    cbp on cbp.c_bpartner_id = cor.c_bpartner_id
WHERE
    cor.issotrx = 'Y'
    and cor.docstatus not in ('DR','IP')
    AND cor.salesrep_id = 1037317
    and col.qtyordered <> 0
    and cor.dateordered between SYSDATE - 30  and SYSDATE + 30
    AND col.c_orderline_id NOT IN (
        SELECT
            cil.c_orderline_id
        FROM
            c_invoiceline cil
        WHERE
            cil.c_orderline_id IS NOT NULL
    )
     group by cor.c_order_id, cor.totallines,cor.documentno,cbp.name
    order by cor.c_order_id, cor.documentno