Wednesday 10 June 2015

Payment Batches Waiting to be Reviewed query in oeacle apps

select call_app_pay_service_req_code
     , (select 'Invoice Count = ' || count(1) ||
               ', Amount ='       || to_char(sum(payment_amount),'$999,999,990.00')
          from ap_selected_invoices_all asi
         where checkrun_name = call_app_pay_service_req_code
           and ok_to_pay_flag = 'Y'
       )
  from iby.iby_pay_service_requests psr
 WHERE calling_app_id                 = 200
   AND payment_service_request_status = 'PENDING_REVIEW'

No comments:

Post a Comment