single group issue
Ok... I give up. I just want the first value of this list of 4. I have
tried 100 different combination's of group by but I still get
ORA-00937: not a single-group group function.
select min(inv.invoice_id)
,sum (DECODE (inv.invoice_currency_code,'USD', inv.amount_paid,
(inv.amount_paid * inv.exchange_rate))) OVER (PARTITION BY apd2.attribute1) paid_to_supplier
from ap_invoices_all inv,ap_invoice_distributions_all apd2
where inv.invoice_id = apd2.invoice_id
and inv.payment_status_flag = 'Y'
and apd2.attribute1 = '44063'
Currently:
Invoice_id Paid to supplier
1 100
2 100
3 100
4 100
Wanted:
Invoice_id Paid to supplier
select min(inv.invoice_id)
,sum (DECODE (inv.invoice_currency_code,'USD', inv.amount_paid,
(inv.amount_paid * inv.exchange_rate))) OVER (PARTITION BY apd2.attribute1) paid_to_supplier
from ap_invoices_all inv,ap_invoice_distributions_all apd2
where inv.invoice_id = apd2.invoice_id
and inv.payment_status_flag = 'Y'
and apd2.attribute1 = '44063'
Currently:
Invoice_id Paid to supplier
1 100
2 100
3 100
4 100
Wanted:
Invoice_id Paid to supplier
0