AR Open Invoices Transaction sql query for the migration

select
'EXTERNAL' INTERFACE_LINE_CONTEXT,
racta.ct_reference INTERFACE_LINE_ATTRIBUTE1,
'BASIC AMOUNT' INTERFACE_LINE_ATTRIBUTE2,
'1' INTERFACE_LINE_ATTRIBUTE3,
'EXTERNAL' BATCH_SOURCE_NAME,
'LINE' LINE_TYPE,
'' DESCRIPTION,
APS.INVOICE_CURRENCY_CODE CURRENCY_CODE,
decode(APS.INVOICE_CURRENCY_CODE,
       'INR',sum(aps.ACCTD_AMOUNT_DUE_REMAINING),
       'USD',SUM(AMOUNT_DUE_REMAINING)
       )  AMOUNT,
RACT.NAME UST_TRX_TYPE_NAME,
'' TERM_NAME,
rac.CUSTOMER_NUMBER ORIG_SYSTEM_BILL_CUSTOMER_REF,
(
SELECT DISTINCT
ps.party_site_number site_number
FROM ra_customers a,
ra_addresses_all b,
hz_party_sites ps,
hz_cust_accounts_all c,
hz_cust_site_uses_all d,
hz_cust_acct_sites_all e,
hr_operating_units hou
WHERE a.party_id=b.party_id
AND b.party_id=c.PARTY_ID
AND e.PARTY_SITE_ID=b.PARTY_SITE_ID
AND e.party_site_id=ps.party_site_id
AND d.org_id = hou.organization_id
AND e.cust_account_id = c.cust_account_id
AND e.cust_acct_site_id = d.cust_acct_site_id
AND b.org_id=hou.ORGANIZATION_ID
and b.org_id= 947 ---ICL BIHAR
and d.SITE_USE_CODE = 'BILL_TO'
and a.customer_number= rac.customer_number
and rownum = 1
) ORIG_SYSTEM_BILL_ADDRESS_REF,
aps.EXCHANGE_RATE_TYPE CONVERSION_TYPE,
aps.EXCHANGE_DATE CONVERSION_DATE,
aps.EXCHANGE_RATE CONVERSION_RATE,
aps.TRX_DATE TRX_DATE,
'1' LINE_NUMBER,
'1' QUANTITY,
decode(APS.INVOICE_CURRENCY_CODE,
       'INR',sum(aps.ACCTD_AMOUNT_DUE_REMAINING),
       'USD',SUM(AMOUNT_DUE_REMAINING)
       )  QUANTITY_ORDERED,
decode(APS.INVOICE_CURRENCY_CODE,
       'INR',sum(aps.ACCTD_AMOUNT_DUE_REMAINING),
       'USD',SUM(AMOUNT_DUE_REMAINING)
       )  UNIT_SELLING_PRICE,
'' MEMO_LINE_NAME,
'Each' UOM_NAME,
'ICL BIHAR' ORG_CODE,
aps.TRX_NUMBER TAX_CODE,
NULL PROGRESS_FLAG,
NULL ERROR_DESCRIPTION,
'IBMSIVA' USER_LOGIN
--sum(aps.ACCTD_AMOUNT_DUE_REMAINING),
--SUM(AMOUNT_DUE_REMAINING),
--sum(AMOUNT_DUE_ORIGINAL)
from ar_payment_schedules_all aps,
     RA_CUST_TRX_TYPES_ALL RACT,
     ra_customers rac,
     ra_customer_trx_all racta
where
       aps.amount_due_remaining <> 0
   AND aps.status = 'OP'
   and aps.org_id = 169
   --and aps.gl_date <= '28-FEB-2010'
   AND APS.CUST_TRX_TYPE_ID = RACT.CUST_TRX_TYPE_ID
   AND APS.CUSTOMER_ID = rac.CUSTOMER_ID
 --  and racta.trx_number = '689'
   and aps.CUSTOMER_TRX_ID = racta.CUSTOMER_TRX_ID
   and aps.ORG_ID = racta.org_id
GROUP BY
aps.TRX_NUMBER ,
racta.ct_reference,
APS.INVOICE_CURRENCY_CODE ,
RACT.NAME ,
rac.CUSTOMER_NUMBER ,
aps.EXCHANGE_RATE_TYPE ,
aps.EXCHANGE_DATE ,
aps.EXCHANGE_RATE ,
aps.TRX_DATE