Create Accounting Draft Mode: mtl_material_transactions -> xla_ae_headers

Hello,

We are trying to run a report to help with validating the Create Accounting program when run in "Draft" mode.  I am trying to link the material transactions (mtl_material_transactions) to the accounting lines (xla_ae_headers).

This can be done with Create Accounting data after the Final flag has been set through the following query:

select * FROM mtl_material_transactions mmt 
        --------------------------------------------
       inner join gmf_xla_extract_headers gxeh on
         mmt.transaction_id = gxeh.transaction_id 
       inner join gmf_xla_extract_lines gxel on 
         gxeh.header_id = gxel.header_id 
       ---------------------------------------------
       inner join xla_distribution_links xdl on
         gxeh.entity_code = xdl.source_distribution_type and
         gxel.line_id = xdl.source_distribution_id_num_1
       ---------------------------------------------
       left join xla_ae_headers xah on
         xdl.ae_header_id = xah.ae_header_id