SELECT qrslt.*
  FROM (SELECT /*+ leading(ir,l,h) cardinality(ir,10) use_hash(lk5,lk7) */
              l.code_combination_id,
               h.ae_header_id,
               e.event_id,
               h.application_id,
               et.event_class_code,
               et.entity_code,
               l.ae_line_num,
               e.event_number,
               te.transaction_number,
               te.source_id_char_1,
               te.source_id_char_2,
               te.source_id_char_3,
               te.source_id_char_4,
               te.source_id_int_1,
               te.source_id_int_2,
               te.source_id_int_3,
               te.source_id_int_4,
               te.security_id_int_1
          FROM xla_ae_headers h,
               xla_ae_lines l,
               xla_events e,
               xla.xla_transaction_entities te,
               xla_gl_ledgers_v gl,
               gl_budget_versions bud,
               xle_entity_profiles le,
               fnd_user ue,
               fnd_application_vl app,
               xla_event_types_tl et,
               xla_event_classes_tl ec,
               xla_lookups lk5,
               xla_lookups lk7,
               gl_import_references ir
         WHERE     gl.ledger_id = h.ledger_id
               AND bud.budget_version_id(+) = h.budget_version_id
               AND le.legal_entity_id(+) = te.legal_entity_id
               AND ue.user_id = e.created_by
               AND ec.application_id = et.application_id
               AND ec.entity_code = et.entity_code
               AND ec.event_class_code = et.event_class_code
               AND ec.language = USERENV ('LANG')
               AND et.application_id = h.application_id
               AND et.entity_code = te.entity_code
               AND e.entity_id = te.entity_id
               AND e.application_id = te.application_id
               AND e.application_id = et.application_id
               AND e.event_type_code = et.event_type_code
               AND et.event_type_code = h.event_type_code
               AND et.language = USERENV ('LANG')
               AND app.application_id = h.application_id
               AND et.application_id = te.application_id
               AND te.application_id = h.application_id
               AND te.entity_id = h.entity_id
               AND e.event_id = h.event_id
               AND e.application_id = h.application_id
               AND h.ae_header_id = l.ae_header_id
               AND h.application_id = l.application_id
               AND lk5.lookup_code = NVL (h.funds_status_code, 'REQUIRED')
               AND lk5.lookup_type = 'XLA_FUNDS_STATUS'
               AND lk7.lookup_code(+) = l.accounting_class_code
               AND lk7.lookup_type(+) = 'XLA_ACCOUNTING_CLASS'
               AND l.gl_sl_link_id = ir.gl_sl_link_id
               AND l.gl_sl_link_table = ir.gl_sl_link_table
               AND ir.je_header_id = :je_header_id
               AND ir.je_line_num = :je_line_num) qrslt;