AR to GL Data flow
I am trying to track the data from AR (Invoices) to GL, however, not able to find the table linking AR to SLA. I have the following tables but interestingly I don't see any data in
XLA_TRANSACTION_ENTITIES for application ID 222
select *
from RA_CUSTOMER_TRX_ALL
where to_char(creation_date,'yyyy') = '2016'
and customer_trx_id = '771630'
and bill_to_customer_id = '7669'
select *
from RA_CUST_TRX_LINE_GL_DIST_ALL
where customer_trx_id = '771630'
and event_id = '4323335'
select *
from xla_events
where application_id = '222'
and to_char(event_date,'yyyy') = '2016'