Query to fetch the Payments data to send it to the bank
Hello Every one,
As we are migrating from 11i(11.5.10.2) to R12(12.1.3), i am having a one Requirement. In 11i, we are creating a payment file by using the below query.
select ------
from
ap_selected_invoice_checks asic
, ap_invoice_selection_criteria aisc
--, ap_bank_accounts aba
--, ap_bank_branches abb
, ap_check_stocks acs
, ap_check_formats acf
, po_vendor_sites pvs
, po_vendors pv
, AP_XML_BATCHLEVEL2_V apbv
WHERE ACS.CHECK_STOCK_ID = AISC.CHECK_STOCK_ID
and ACS.CHECK_FORMAT_ID = ACF.CHECK_FORMAT_ID
--and asic.external_bank_account_id = aba.bank_account_id