ra_cust_trx_line_gl_dist_all link to xla_ae_lines

Hi,

I have a script as below to link ra_cust_trx_line_gl_dist_all to xla_ae_lines for getting the xla accounting line detail.

When one transaction associated to 2 lines and the 2 lines associated to 2 different code combination, there are 4 lines return with my script.

I do not know how to link the dist line the the xla lines. Could you please advice what is missing for my script? thanks.

select rctl.previous_customer_trx_id,

               rctla.set_of_books_id,

               xal.code_combination_id,

               rctl.interface_line_attribute3,

               rctl.uom_code,

               rctl.customer_trx_id,

               rctl.interface_line_attribute6,