Receivables - EBS (MOSC)

MOSC Banner

Query to Find Unaccounted AR Receipts

edited May 26, 2010 2:58AM in Receivables - EBS (MOSC) 2 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center