[Home] [Help]
2308: SELECT ASI.invoice_id,
2309: ASI.payment_num,
2310: p_check_date payment_date
2311: FROM ap_selected_invoices_all ASI,
2312: iby_fd_docs_payable_v ibydocs
2313: WHERE ASI.checkrun_name = p_checkrun_name
2314: AND ASI.original_invoice_id IS NULL
2315: and asi.checkrun_id = p_checkrun_id
2316: and ibydocs.calling_app_doc_unique_ref1 = asi.checkrun_id
2428: , ASI.payment_num
2429: , AI.vendor_id
2430: FROM ap_SELECTed_invoices_all ASI
2431: , ap_invoices_all AI
2432: , iby_fd_docs_payable_v ibydocs
2433: WHERE ASI.checkrun_name = p_checkrun_name
2434: AND AI.invoice_id = ASI.invoice_id
2435: and asi.checkrun_id = p_checkrun_id
2436: and ibydocs.completed_pmts_group_id = p_completed_pmts_group_id