AR Transaction details with receipt details custom OTBI report

Summary

Need to link Receipt Application subject area to transaction details subject area

Content

Hi,

I have created a custom OTBI report with all standard AR receipt details along with it's application details however i am unable to get the transaction amount in the report. Please help.

Below is the query i have prepared for the same.

SELECT distinct ACR.RECEIPT_NUMBER,
to_char(ACR.RECEIPT_DATE,'DD-MON-YYYY') REC_DATE,
ACR.CURRENCY_CODE CURRENCY, 
ROUND (ACR.AMOUNT,2) REC_AMOUNT, 
ACR.COMMENTS REC_EMPL_ID,
RM.NAME RECEIPT_METHOD, 
RCT.TRX_NUMBER INV_NUMBER,
ACR.STATUS,
to_char(RCT.TRX_DATE,'DD-MON-YYYY') INV_DATE,