Link between ra_cust_trx_line_ table to xla_ae_lines table
Hi ,
I'm not able to figure direct mapping between ra_customer_trx_all/ra_customer_trx_lines/ra_cust_trx_line_gl_dist_all to xla_ae_lines,
which is resulting in causing cartesian join (multiplied value), can anybody advice please,
Many Thanks,
Code:
SELECT DISTINCT
xah.ae_header_id AS "AE_HEADER_ID",
xah.application_id AS "APPLICATION_ID",
xah.ledger_id AS "LEDGER_ID",
xah.entity_id AS "ENTITY_ID",
xah.event_id AS "EVENT_ID",
xah.event_type_code AS "EVENT_TYPE_CODE",
xah.accounting_date AS "ACCOUNTING_DATE",
xah.gl_transfer_status_code AS "GL_TRANSFER_STATUS_CODE",