Query to Find Unaccounted AR Receipts
Hi all
Please help me fetching the Unaccounted AR Receipts.
I had framed a query as per my understanding :
SELECT XTE.TRANSACTION_NUMBER
FROM
XLA_AE_HEADERS XLAAE,XLA_TRANSACTION_ENTITIES XTE
WHERE XLAAE.ENTITY_ID = XTE.ENTITY_ID AND
XTE.ENTITY_CODE = 'RECEIPTS'
AND XLAAE.JE_CATEGORY_NAME = 'Receipts'
AND XTE.TRANSACTION_NUMBER = '10264'
Whenever i do a Create Accounting for a particular AR Receipt it has to go and hit the following Table
XLA_TRANSACTION_ENTITIES XTE
Please Help me out in this.
Regards
Nakul Venkatraman
Please help me fetching the Unaccounted AR Receipts.
I had framed a query as per my understanding :
SELECT XTE.TRANSACTION_NUMBER
FROM
XLA_AE_HEADERS XLAAE,XLA_TRANSACTION_ENTITIES XTE
WHERE XLAAE.ENTITY_ID = XTE.ENTITY_ID AND
XTE.ENTITY_CODE = 'RECEIPTS'
AND XLAAE.JE_CATEGORY_NAME = 'Receipts'
AND XTE.TRANSACTION_NUMBER = '10264'
Whenever i do a Create Accounting for a particular AR Receipt it has to go and hit the following Table
XLA_TRANSACTION_ENTITIES XTE
Please Help me out in this.
Regards
Nakul Venkatraman
0