R12 uses TCA to manage banks and branches, and stores them in Hz_parties.
Bank account Number: If it is Payment or the receipt (the company's account number, internal account), are stored in the ce_bank_accounts,ce_bank_acct_uses
Ce_bank_acct_uses indicates that this account can be used in Ap,ar, or payroll, which OU can access
The remit_bank_acct_use_id in the ar_receipt_method_accounts associated ce_bank_acct_uses in the collection of the bank_acct_use_id
You can find the relevant bank, branch, bank account number
Payment when ap_checks_all in ce_bank_acct_use_id associated ce_bank_acct_uses bank_acct_use_id
You can find the relevant bank, branch, bank account number
Bank account (External account) information of customer or vendor is saved in table iby_ext_bank_accounts
ACCOUNT_OWNER_PARTY_ID Association hz_parties in Iby_account_owners
EXT_BANK_ACCOUNT_ID associated iby_ext_bank_accounts in Iby_account_owners can find the bank account number of the customer or supplier
Select SUM (aipa.amount)
From Ap_checks_all aca,
IBY_PAYMENT_METHODS_VL IPMV,
Ce_bank_accounts CBA,
Ce_bank_acct_uses_all Cbau,
GL_CODE_COMBINATIONS_KFV GCCK,
Ce_gl_accounts_ccid CGAC,
Hr_operating_units Hou,
Ap_invoice_payments_all Aipa
where 1 = 1
and ACA. Payment_method_code = ipmv. Payment_method_code
and aca.org_id = hou.organization_id
and aca.ce_bank_acct_use_id = cbau.bank_acct_use_id
and cbau.bank_account_id = cba.bank_account_id
and cbau.org_id = aca.org_id
and ACA. ce_bank_acct_use_id = Cgac. bank_acct_use_id
and cgac.ap_asset_ccid = gcck.code_combination_id
and substr (Gcck.segment3, 1, 4) in (' 1001 ', ' 1002 ')
and aipa.check_id = aca.check_id
and Hou.short_code =company.company_code
and To_char (aipa.accounting_date, ' yyyy-mm-dd ') between G_start_day and G_end_day
R12 uses TCA to manage banks and branches