this code is low performing while run in huge data ? try to better joins any one?
SELECT VEN.VENDOR_NAME SUPPLIER_NAME, INV.INVOICE_NUM INVOICE_NUMBER,
INV.INVOICE_DATE INVOICE_DATE,
INV.INVOICE_CURRENCY_CODE INVOICE_CURRENCY,
SUM(DIS.AMOUNT) INVOICE_AMOUNT,
DESCR.DESCRIPTION
FROM AP_INVOICE_DISTRIBUTIONS DIS,
Ap_Invoice_Lines Line,
AP_INVOICES INV,
AP_SUPPLIERS VEN,
(SELECT AID.DESCRIPTION DESCRIPTION,
AID.INVOICE_ID INVOICE_ID
From Ap_Invoice_Distributions Aid
where AID.DISTRIBUTION_LINE_NUMBER=1 and invoice_line_number=1) DESCR
WHERE INV.INVOICE_ID = LINE.INVOICE_ID
And Line.Invoice_Id = Dis.Invoice_Id
And Line.Line_Number=Dis.Invoice_Line_Number
AND DESCR.INVOICE_ID = INV.INVOICE_ID
And Inv.Vendor_Id = Ven.Vendor_Id
INV.INVOICE_DATE INVOICE_DATE,
INV.INVOICE_CURRENCY_CODE INVOICE_CURRENCY,
SUM(DIS.AMOUNT) INVOICE_AMOUNT,
DESCR.DESCRIPTION
FROM AP_INVOICE_DISTRIBUTIONS DIS,
Ap_Invoice_Lines Line,
AP_INVOICES INV,
AP_SUPPLIERS VEN,
(SELECT AID.DESCRIPTION DESCRIPTION,
AID.INVOICE_ID INVOICE_ID
From Ap_Invoice_Distributions Aid
where AID.DISTRIBUTION_LINE_NUMBER=1 and invoice_line_number=1) DESCR
WHERE INV.INVOICE_ID = LINE.INVOICE_ID
And Line.Invoice_Id = Dis.Invoice_Id
And Line.Line_Number=Dis.Invoice_Line_Number
AND DESCR.INVOICE_ID = INV.INVOICE_ID
And Inv.Vendor_Id = Ven.Vendor_Id
0