select hr.name,

       a.autoapply_flag,

       a.AUTOMATCH_SET_ID,

       a.LEGAL_ENTITY_ID,

       a.RECEIPT_NUMBER,

       a.type,

       a.receipt_date,

       b.gl_date,

       c.name,

       a.remit_bank_account,

       ce.bank_account_name,

       a.attribute3

  from AR_CASH_RECEIPTS_V        a,

       hr_operating_units          hr,

       AR_CASH_RECEIPT_HISTORY_ALL b,

       AR_RECEIPT_METHODS          c,

       ce_bank_accounts ce

 where a.org_id = hr.organization_id

   AND b.CASH_RECEIPT_ID(+) = a.CASH_RECEIPT_ID

   AND b.ORG_ID(+) = a.ORG_ID

   AND b.FIRST_POSTED_RECORD_FLAG(+) = 'Y'

   and hr.organization_id = 89

   AND a.RECEIPT_METHOD_ID = c.RECEIPT_METHOD_ID

   and a.remit_bank_account = ce.bank_account_num

   and a.attribute3 < ''