WITH due_invoice AS (
        SELECT SUM(A.amount - A.payment_amount) AS due_outstanding_amount
        FROM fi_invoice_ar_balance A
        LEFT OUTER JOIN  sl_so B ON A.ref_doc_type_id = B.doc_type_id AND A.ref_id = B.so_id
        WHERE A.tenant_id = 10  AND A.ou_id = 11  AND A.due_date < '20170403'
        AND A.flg_payment = 'N'
        AND A.partner_id = 217
    ), outstanding_invoice AS (
        SELECT SUM(A.amount - A.payment_amount) AS outstanding_amount
        FROM fi_invoice_ar_balance A
        LEFT OUTER JOIN  sl_so B ON A.ref_doc_type_id = B.doc_type_id AND A.ref_id = B.so_id
        WHERE A.tenant_id = 10  AND A.ou_id = 11
        AND A.flg_payment = 'N'
        AND A.partner_id = 217
    )
    SELECT (A.amount_limit - B.outstanding_amount), C.due_outstanding_amount
    FROM m_partner_type A, outstanding_invoice B, due_invoice C
    WHERE A.partner_id = 217
        AND A.group_partner = 'C'