This following query written for R12 migration. Hope it will be useful.
SELECT cpd.payment_document_name
FROM ap_checks_all ac,
iby_docs_payable_all idpa,
iby_payments_all ip,
iby_used_payment_docs iupd,
ce_payment_documents cpd
WHERE idpa.payment_id = ip.payment_id
AND ip.paper_document_number = iupd.used_document_number
AND iupd.payment_document_id = cpd.payment_document_id
AND ac.checkrun_name = ip.payment_process_request_name
AND ac.check_number = :p_check_number
great!!!!
ReplyDelete