SELECT apsa.amount_due_original receipt_amount,
       apsa.amount_due_remaining unapplied_amount,
       apsa.due_date,
       DECODE (apsa.status,  'OP', 'OPEN',  'CL', 'CLOSED') receipt_status,
       apsa.invoice_currency_code,
       HP.PARTY_name,
       a5.party_site_number,
       a3.site_use_code,
       a6.receipt_number,
       a6.receipt_date,
       a6.comments,
       apsa.amount_applied,
       apsa.exchange_rate,
       apsa.exchange_date,
       apsa.exchange_rate_type
  FROM ar_payment_schedules_all apsa,
       HZ_PARTIES HP,
       HZ_CUST_ACCOUNTS HCA,
       hz_cust_site_uses_all a3,
       hz_cust_acct_sites_all a4,
       hz_party_sites a5,
       ar_cash_receipts_all a6
 WHERE     apsa.org_id = :p_org_id
       AND HP.PARTY_ID=HCA.PARTY_ID
       AND apsa.customer_id = HCA.CUST_ACCOUNT_ID
       AND apsa.cash_receipt_id = a6.cash_receipt_id
       AND apsa.class = 'PMT'
       --AND apsa.STATUS='OP'
       AND apsa.customer_site_use_id = a3.site_use_id
       AND a3.cust_acct_site_id = a4.cust_acct_site_id