Journal Related to AP Invoice

SELECT DISTINCT
       aia.invoice_num,
       --eve_line.ENTERED_DR "Entered DR in SLA",
       --    eve_line.ENTERED_CR "Entered CR in SLA",
       --    eve_line.ACCOUNTED_DR "Accounted DR in SLA",
       --    eve_line.ACCOUNTED_CR "Accounted CR in SLA",
       --    je_lin.ENTERED_DR "Entered DR in GL",
       --    je_lin.ACCOUNTED_DR "Accounted DR in GL",
       --    eve_line.ACCOUNTING_CLASS_CODE "Accounting Class",
       eve_hed.JE_CATEGORY_NAME "JE Category Name",
       je_bat.NAME "Journal Batch Name",
       je_hed.NAME "Journal Header Name",
       je_lin.JE_LINE_NUM "Journal Line Number",
       je_lin.Description "Journal Line Desc",
          gcc.SEGMENT1
       || '.'
       || gcc.SEGMENT2
       || '.'
       || gcc.SEGMENT3
       || '.'
       || gcc.SEGMENT4
       || '.'
       || gcc.SEGMENT5
          "Code Combination"
  FROM apps.ap_invoices_all aia,
       apps.ap_invoice_distributions_all aida,
       apps.xla_events eve,
       apps.xla_ae_headers eve_hed,
       apps.xla_ae_lines eve_line,
       apps.GL_IMPORT_REFERENCES imp_ref,
       apps.gl_code_combinations gcc,
       apps.gl_je_batches je_bat,
       apps.gl_je_headers je_hed,
       apps.gl_je_lines je_lin
 WHERE     1 = 1
       AND aia.invoice_Id = aida.invoice_id
       AND aida.accounting_event_id = eve.event_id
       AND eve.event_Id = eve_hed.event_id
       AND aida.accounting_event_id = eve_hed.event_id
       AND eve_hed.ae_header_id = eve_line.ae_header_id
       AND imp_ref.GL_SL_LINK_ID = eve_line.GL_SL_LINK_ID
       AND imp_ref.GL_SL_LINK_TABLE = eve_line.GL_SL_LINK_TABLE
       AND imp_ref.je_header_id = je_hed.je_header_Id
       AND imp_ref.je_header_id = je_lin.je_header_Id
       AND imp_ref.je_batch_Id = je_bat.je_batch_Id
       AND je_bat.je_batch_Id = je_hed.je_batch_id
       AND je_hed.je_header_id = je_lin.je_header_Id
       AND eve_line.DESCRIPTION = je_lin.DESCRIPTION
       AND gcc.CODE_COMBINATION_ID = eve_line.CODE_COMBINATION_ID
       AND gcc.CODE_COMBINATION_ID = je_lin.CODE_COMBINATION_ID
       AND aia.invoice_Id = XXXXXX