select DISTINCT ac.customer_name
,ac.customer_number
from iby_pmt_instr_uses_all
instr_assign,iby_external_payers_all
payee,iby_ext_bank_accounts bankacct,hz_cust_accounts_all
hcal,ar_customers acwhere
instr_assign.instrument_id = bankacct.ext_bank_account_id
and instr_assign.ext_pmt_party_id = payee.ext_payer_id
and instr_assign.instrument_type = 'BANKACCOUNT'and
instr_assign.payment_flow =
'FUNDS_CAPTURE'and instr_assign.payment_function =
'CUSTOMER_PAYMENT'and
hcal.cust_account_id = payee.cust_account_id
and ac.customer_number = hcal.account_number
and bankacct.bank_account_num = '22090402' (Pass Banks
Account or leave blank)
No comments:
Post a Comment