Sunday, August 31, 2014

Backend View : AP Invoices To Payments - Oracle EBS R12

SELECT * FROM ap_invoices_all WHERE invoice_num='54235243';   -- invoice_id : 10160

SELECT * FROM ap_invoice_payments_all WHERE invoice_id=10160; --check_id : 63272

SELECT * FROM ap_checks_all WHERE check_id=63272;             --payment_id=33191

SELECT * FROM iby_payments_all WHERE payment_id=33191; --payment_process_request_name='Quick Payment: ID=63272' payment_instruction_id='10763' payment_service_request_id='971'

SELECT *
FROM iby_pay_service_requests
WHERE call_app_pay_service_req_code='Quick Payment: ID=63272'
AND payment_service_request_id     ='971';

SELECT * FROM iby_pay_instructions_all WHERE payment_instruction_id='10763';

SELECT *
FROM ap_inv_selection_criteria_all
WHERE checkrun_name= <<call_app_pay_service_req_code>>; --No Entries for Quick Payments

1 comments: