Thursday, 22 May 2014

Customer Bank detail query in Oracle Apps r12

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