Trace Credit Memo Request created in Lease Center to Invoice against which it has been created.

Hi All,

I created a credit Memo in Lease Center using the Credit Memo functionality.After entering the amount to be credited request is submitted and the request detail is populated in OKL_TRX_REQUEST.

What I am looking for is a table link between the OKL_TRX_REQUEST table and other invoice tables for a validation that invoice # XXXXX has already been requested a Credit Memo. I am Creating the Credit Memo in R12.1.3 and delta 35 patch applied.

Process :

1)  Created a credit Memo for Invoice # 10000 which has only stream as Rent.

2) Request submitted and OKL_TRX_REQUEST table populated with Request # 1234.