Monday, 29 January 2018

SQL Query to Fetch Oracle Customer Banking Details in Oracle apps R12




SQL Query to Fetch Oracle Customer Banking Details in Oracle apps R12


select DISTINCT ac.customer_name
,ac.customer_number, bankacct.*
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 = '4456677777' (Pass Banks Account or leave blank)

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

If you want to see Other OAF Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2013/03/oaf_10.html

If you want to see  Oracle Fusion Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html
If you want to Learn Oracle Workflow Builder, Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html

0 comments:

Post a Comment