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

8 comments:

Anonymous said...

Good content in this post and site. We need more fresh and good content like this. Thanks for posting great stuff, it’s very useful to me. Please contact us for Oracle R12 Financials training details in our Erptree Training Institute

Anonymous said...

Good Blog Thanks For Sharing this informative airtrl/
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

shaik shah said...

Thanks for sharing this informative article ,It would be helpful to all
Oracle Fusion HCM Online Training

Anonymous said...

Thanks for Sharing This informative article. It would be helpful if you write a all.
Oracle Fusion HCM Online Training

yamuna said...

Good article, thanks for sharing this information.
Oracle Fusion HCM Training

raveena said...


Nice article

Oracle Fusion HCM Training

Lakshmi Satya said...
This comment has been removed by the author.
SunTec Business Solutions said...

dynamic pricing and billing
Personalize products, offers, pricing and loyalty programs; prevent revenue leakage and ensure regulatory compliance with a billing solution.

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *