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'
, (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