Hi All, I need a query to display Ap invoice distribution amount with tax. I have 1 distribution Item line and 3 miscellaneous tax lines on that. So I need total amount in one line. Like that I have 2 Item lines and 3 miscellaneous tax lines belongs to first item line. So I need first dist amount with tax and second dist amount with out tax. Any help appreciated....

Thanks Krishna, I got it now. For PO related invoices I used your table. For non PO Related tax I used JAI_AP_INVOICE_LINES table. So in both tables I joined with parent_invoice_line_number