Oracle Fusion Query for Projects, Subledger and Journals Tables

SELECT DISTINCT XTE.entity_id,
                XAL.gl_sl_link_id,
                XAL.gl_sl_link_table,
                xte.transaction_number,
                ppab.segment1,
                ppat.name ei_project_name
FROM
/*  AP_CHECKS_ALL AC
, */ xla_transaction_entities XTE,
     xla_ae_headers XAH,
     xla_ae_lines XAL,
     xla_distribution_links xda,
     pjc_cost_dist_lines_all pcdl,
     pjf_projects_all_b ppab,
     pjc_exp_items_all peia,
     pjf_projects_all_tl ppat,
     gl_import_references GLIR,
     gl_je_lines GJL,
     gl_je_headers GJH,
     gl_je_batches GJB
WHERE  1 = 1
       AND GJH.je_header_id = GJL.je_header_id
       --AND GJH.JE_SOURCE = 'Projects'
       AND GJB.je_batch_id = GLIR.je_batch_id
       AND GLIR.je_header_id = GJL.je_header_id
       AND GLIR.je_line_num = GJL.je_line_num
       AND GJB.je_batch_id = GJH.je_batch_id
       AND XAL.gl_sl_link_table = GLIR.gl_sl_link_table
       AND XAL.gl_sl_link_id = GLIR.gl_sl_link_id
       AND XAH.ae_header_id = XAL.ae_header_id
       AND XAH.entity_id = XTE.entity_id
       AND pcdl.acct_event_id = xda.event_id(+)
       AND pcdl.expenditure_item_id = xda.source_distribution_id_num_1(+)
       AND pcdl.line_num = xda.source_distribution_id_num_2(+)
       AND ( xda.rounding_class_code NOT LIKE '%CLEARING'
              OR xda.rounding_class_code IS NULL )
       AND xda.ae_header_id = xal.ae_header_id(+)
       AND xda.ae_line_num = xal.ae_line_num(+)
       AND peia.expenditure_item_id = pcdl.expenditure_item_id
       AND peia.project_id = ppab.project_id
       AND ppab.project_id = ppat.project_id