Performance issue with xla_inv_ael_gl_v

 Hello Friends,

I am having performance issue with this query, it keeps running forever, i have done sqltplain and implemented the recommended solution of creating indexes but still not giving anyoutput.

SELECT 'Inventory' as "Source",

a.trx_class_name Trans_Class,

a.trx_type_name Trans_Type,

a.trx_number_displayed "Invoice Number",

a.trx_date Trans_Date,

a.comments,

a.acct_line_type_name Accounts_Type,

GLCC.SEGMENT1 || '-' || GLCC.SEGMENT2 || '-' || GLCC.SEGMENT3 || '-' ||

GLCC.SEGMENT4 || '-' || GLCC.SEGMENT5 || '-' || GLCC.SEGMENT6 AS Account,

FFVL5.DESCRIPTION AS Product,

FFVL6.DESCRIPTION AS Account_Description,

a.currency_code,

nvl(a.entered_dr, 0) Debit,