Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement