Query to get the AR Invoice Amount, transaction type and location -- Oracle Apps

SELECT
RCT.CUSTOMER_TRX_ID,
RCT.TRX_NUMBER,
RCT.TRX_DATE,
RCG.GL_DATE,
RCT.PURCHASE_ORDER,
OOD.ORGANIZATION_ID,
OOD.ORGANIZATION_NAME,
HCSUA.SITE_USE_ID,
HCSUA.LOCATION,
RCL.DESCRIPTION,
HCA.ACCOUNT_NUMBER,
HP.PARTY_NAME,
RTT.NAME TRANSACTION_NAME,
DECODE(RTT.TYPE,'INV','INVOICE','CM','Credit Memo','DM','Debit Memo') TRANSACTION_TYPE,
DECODE(RCL.LINE_TYPE,'LINE','LINE_TOTAL','TAX','TOTAL_TAX') LINE_TYPE,
sum((DECODE(RCT.INVOICE_CURRENCY_CODE,'INR',RCG.AMOUNT*1,RCG.AMOUNT*RCT.EXCHANGE_RATE))) TOTAL_INV_AMOUNT,  
FU.USER_ID,FU.USER_NAME
FROM
RA_CUSTOMER_TRX_ALL RCT,
RA_CUSTOMER_TRX_LINES_ALL RCL,
RA_CUST_TRX_LINE_GL_DIST_ALL RCG,
ORG_ORGANIZATION_DEFINITIONS OOD,
HZ_CUST_ACCOUNTS HCA,
HZ_PARTIES HP,
RA_CUST_TRX_TYPES_ALL RTT,
FND_USER FU
--,HZ_CUST_ACCT_SITES_ALL HCASA,
,HZ_CUST_SITE_USES_ALL HCSUA
WHERE
RCT.CUSTOMER_TRX_ID = RCL.CUSTOMER_TRX_ID
AND RCL.CUSTOMER_TRX_LINE_ID = RCG.CUSTOMER_TRX_LINE_ID
AND RCT.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HCA.ACCOUNT_NUMBER = 'XXRAM001'
AND HCA.PARTY_ID = HP.PARTY_ID
AND RCT.LAST_UPDATED_BY = FU.USER_ID
AND RCT.CUST_TRX_TYPE_ID = RTT.CUST_TRX_TYPE_ID
AND TO_NUMBER(RCT.INTERFACE_HEADER_ATTRIBUTE10) = OOD.ORGANIZATION_ID (+)
--AND HCASA.CUST_ACCOUNT_ID=HCA.CUST_ACCOUNT_ID
--AND HCASA.CUST_ACCT_SITE_ID=HCSUA.CUST_ACCT_SITE_ID
AND RCT.BILL_TO_SITE_USE_ID=HCSUA.SITE_USE_ID
AND RCT.TRX_DATE BETWEEN :PFROM AND :PTO
GROUP BY
RCT.CUSTOMER_TRX_ID,RCT.TRX_NUMBER,
RCT.CUST_TRX_TYPE_ID,RCT.TRX_DATE,RCG.GL_DATE,
RCT.CUSTOMER_TRX_ID,RCT.PURCHASE_ORDER,OOD.ORGANIZATION_NAME,
RCL.DESCRIPTION,
HCA.ACCOUNT_NUMBER,OOD.ORGANIZATION_ID,
HP.PARTY_NAME,
HCSUA.SITE_USE_ID,HCSUA.LOCATION,
FU.USER_ID,FU.USER_NAME,
RTT.NAME,RTT.TYPE,RCL.LINE_TYPE
ORDER BY RCT.TRX_DATE DESC