AR Payment Query

select rcta.trx_number, rcta.trx_date,ra.amount_applied, ra.gl_date

        --nvl(sum(ra.amount_applied), 0)

  from ar_receivable_applications_all ra,

       ra_customer_trx_all            rcta,

       ar_payment_schedules_all       apsa

      

 where ra.applied_customer_trx_id = rcta.customer_trx_id

   and ra.applied_payment_schedule_id = apsa.payment_schedule_id

   and ra.application_type = 'CASH'

   and ra.status = 'APP'

   AND rcta.customer_trx_id = apsa.customer_trx_id

   and rcta.org_id = apsa.org_id

   and rcta.org_id = &P_ORG_ID

      -- and    ra.apply_date between to_date(&sd) and to_date(&ed)) payment,

   and ra.gl_date between to_date(&sd) and to_date(&ed)