SELECT a.invoice_temp_id, a.doc_no, a.doc_date,
        a.inv_doc_no, a.inv_doc_date, a.partner_id,
        b.partner_code, b.partner_name, a.ext_doc_no, a.remark, a.version,
        a.gross_amount, a.advance_amount, a.tax_amount, a.add_amount, a.total_amount, a.curr_code
    FROM sl_so_balance_invoice z
    INNER JOIN sl_invoice_temp a ON a.invoice_temp_id = z.invoice_id
    INNER JOIN m_partner b  ON a.partner_id = b.partner_id
    WHERE z.tenant_id = :tenantId
        AND z.ou_id = :ouId
        AND z.flg_invoice = :NO
        AND z.flg_invoice_temp = :YES
        AND  UPPER(a.inv_doc_no) like '% %'
    GROUP BY a.invoice_temp_id, a.doc_no, a.doc_date,
        a.inv_doc_no, a.inv_doc_date, a.partner_id,
        b.partner_code, b.partner_name, a.ext_doc_no, a.remark, a.version
    ORDER BY a.doc_no, a.doc_date