AR Invoice details with Item and Tax -- Oracle Apps

SELECT
HCA.ACCOUNT_NUMBER CUSTOMER_CODE,
HP.PARTY_NAME CUSTOMER_NAME,
HCSUA.LOCATION,
--RCT.CUSTOMER_TRX_ID,
RCT.TRX_NUMBER INV_NO,RCT.TRX_DATE INV_DATE,
--RCG.GL_DATE,RCT.PURCHASE_ORDER,OOD.ORGANIZATION_ID,OOD.ORGANIZATION_NAME,
--HCSUA.SITE_USE_ID,
IGCC.SEG6_DESC PRODUCT,
MSIB.SEGMENT1 ITEM_CODE,RCL.DESCRIPTION,MSIB.PRIMARY_UOM_CODE UOM,
RCL.QUANTITY_ORDERED QUANTITY,RCL.UNIT_SELLING_PRICE RATE,
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))) INV_AMOUNT
,JCT.TAX_NAME
--,JAT.TAX_ID
,SUM(JAT.TAX_AMOUNT)TAX_AMOUNT,JAT.TAX_RATE  
--,FU.USER_ID,FU.USER_NAME
FROM
RA_CUSTOMER_TRX_ALL RCT
,RA_CUSTOMER_TRX_LINES_ALL RCL
,MTL_SYSTEM_ITEMS_B MSIB
,GL_CODE_COMBINATIONS IGCC
,APPS.JAI_AR_TRX_LINES JAL
,APPS.JAI_AR_TRX_TAX_LINES JAT
,APPS.JAI_CMN_TAXES_ALL JCT
,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_SITE_USES_ALL HCSUA
WHERE
RCT.TRX_DATE BETWEEN :PFROM AND :PTO
AND RCT.CUSTOMER_TRX_ID = RCL.CUSTOMER_TRX_ID
AND RCL.CUSTOMER_TRX_LINE_ID = RCG.CUSTOMER_TRX_LINE_ID
AND RCL.INVENTORY_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND RCL.INTERFACE_LINE_ATTRIBUTE10 = MSIB.ORGANIZATION_ID
AND MSIB.SALES_ACCOUNT = IGCC.CODE_COMBINATION_ID
---AND RCL.CUSTOMER_TRX_ID = JAL.CUSTOMER_TRX_ID (+)
AND RCL.CUSTOMER_TRX_ID = JAL.CUSTOMER_TRX_ID(+)
AND JAL.CUSTOMER_TRX_LINE_ID = JAT.LINK_TO_CUST_TRX_LINE_ID (+)
AND JAT.TAX_ID = JCT.TAX_ID (+)
AND RCT.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HCA.ACCOUNT_NUMBER = 'TEST123'
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 RCT.TRX_NUMBER = 'Test02884'
--AND FU.USER_NAME IN ('TEST')
--AND HCASA.CUST_ACCOUNT_ID=HCA.CUST_ACCOUNT_ID
--AND HCASA.CUST_ACCT_SITE_ID=HCSUA.CUST_ACCT_SITE_ID
AND IGCC.SEG6_DESC = 'XXXX'
AND RCT.BILL_TO_SITE_USE_ID=HCSUA.SITE_USE_ID
GROUP BY
HCA.ACCOUNT_NUMBER,
HP.PARTY_NAME, HCSUA.LOCATION,
--RCT.CUSTOMER_TRX_ID,
RCT.TRX_NUMBER,RCT.TRX_DATE,
--RCT.CUST_TRX_TYPE_ID,RCG.GL_DATE,
IGCC.SEG6_DESC,MSIB.SEGMENT1,RCL.DESCRIPTION,MSIB.PRIMARY_UOM_CODE,
RCL.QUANTITY_ORDERED ,RCL.UNIT_SELLING_PRICE ,
JCT.TAX_NAME,--JAT.TAX_AMOUNT,
JAT.TAX_RATE,
--RCT.CUSTOMER_TRX_ID,RCT.PURCHASE_ORDER,OOD.ORGANIZATION_NAME,OOD.ORGANIZATION_ID,HCSUA.SITE_USE_ID,FU.USER_ID,FU.USER_NAME,
RTT.NAME,RTT.TYPE
--RCL.LINE_TYPE
ORDER BY RCT.TRX_DATE DESC