query to display tax for each line item in payables.

Hi,

Is there any queries that will display the taxes for the lines grouped by different tax rates. E.g if i have tax rate as 2,3,6,9% and in an invoice i have 4 lines having each one of the tax associated with the the line item, hot to achieve that?

I tried with sum (case ( if zx_rates_b.percentage_rate = 2 and ap_invoice_lines_all.line_type = 'TAX' then

                                   sum(aila.amount)

                                   partition by ap_invoice_lines_all.)

and it didn't work (this is just a sample code).

Regards,

BS.