Thursday, 25 April 2013

Query for link between ap_checks_all and ce_payment_documents

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

1 comment: