You can refer the table “AR_CASH_RECEIPTS” which probably has both the values.
Thank you for your response but I couldn't find the receipt number for the corresponding transaction number.
I can see 'receivables_trx_id' but not transaction number. As I am new to the oracle apps,I dnt knw much about the tables and relationships.
1 person found this helpful
You can use the following simple query:
WHERE trx_number = :TRX_NUMBER AND applied_flag = 'Y';
In case I have answered your question, please mark it helpful/correct.
Did my query work for you? Did I answer your question or you still need any help?
Also Refer the Below Links,Can you get idea Abount Receivable Tables and Table Relation Ship,
Thanks & Regards,