Performance - EBS (MOSC)

MOSC Banner

this code is low performing while run in huge data ? try to better joins any one?

edited Dec 23, 2013 4:57PM in Performance - EBS (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center