Query to get AR Open Transactions in Oracle Apps

SELECT rcta.trx_number,
       (SELECT a.account_number
          FROM hz_cust_accounts_all a, hz_parties b
         WHERE     a.party_id = b.party_id
               AND a.cust_account_id = rcta.bill_to_customer_id)
          customer_number,
       (SELECT b.party_name
          FROM hz_cust_accounts_all a, hz_parties b
         WHERE     a.party_id = b.party_id
               AND a.cust_account_id = rcta.bill_to_customer_id)
          customer_name,
       (SELECT location
          FROM hz_cust_site_uses_all
         WHERE site_use_id = apsa.customer_site_use_id)
          location,
       rcta.ct_reference,
       apsa.class,
       apsa.customer_id,
       apsa.customer_site_use_id,
       apsa.payment_schedule_id,
       apsa.amount_due_original,
       apsa.amount_due_remaining,
       apsa.amount_applied
  FROM ra_customer_trx_all rcta
      ,ar_payment_schedules_all apsa
 WHERE rcta.customer_trx_id = apsa.customer_trx_id
       AND apsa.status = 'OP'
       AND apsa.class IN ('INV', 'CM', 'DM')
       AND rcta.org_id = :p_org_id