AR Transactions from SLA
Hi,
I am trying to derive the list of AR Transactions accounted by either "Create Accounting" or "Submit Accounting"Process.
From the Workflow Business Events, I am able to derive the Accounting Batch ID.
Is there a way to derive the list of AR Transactions using this Accounting batch id?
I see that it is a column in the XLA_AE_HEADERS_ALL table..
How do I drill down to get the customer trx id?
I wrote a query as below...
SELECT *
FROM XLA.XLA_TRANSACTION_ENTITIES xte
WHERE 1=1
AND xte.application_id =222
--AND xte.entity_code = 'TRANSACTIONS'
AND xte.entity_id IN ( SELECT entity_id