Saturday, December 31, 2016

R12 Supplier Bank Account details Oracle Apps

 The supplier (or External) bank account information are stored in the table called IBY_EXT_BANK_ACCOUNTS. The bank and bank branches information are stored in the table HZ_PARTIES. They are linked together through Relationships (in HZ_RELATIONSHIP). There is a separate link for both Bank to Branch and also from Branch to Bank. Bank sites and Location information are stored in tables: HZ_PARTY_SITES and HZ_LOCATIONS. The bank_id and branch_id fields of IBY_EXT_BANK_ACCOUNTS table link the Bank Account to the relevant Bank and Branch Parties in the HZ_PARTIES table (IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id).
When the Bank is assigned to Vendors then it will be updated in a table called HZ_CODE_ASSIGNMENTS. Payment related details of supplier are also inserted in iby_external_payees_all as well as iby_ext_party_pmt_mthds.


SELECT party_supp.party_name supplier_name
,      aps.segment1          supplier_number
,      ass.vendor_site_code  supplier_site
,      branch_prof.bank_or_branch_number bank_number
,      party_branch.party_name branch_name
,      branch_prof.bank_or_branch_number branch_number
,      ieb.bank_account_num
,      ieb.bank_account_name
,      party_bank.party_name bank_name
FROM   hz_parties party_supp
,      ap_suppliers aps
,      hz_party_sites site_supp
,      ap_supplier_sites_all ass
,      iby_external_payees_all iep
,      iby_pmt_instr_uses_all ipi
,      iby_ext_bank_accounts ieb
,      hz_parties party_bank
,      hz_parties party_branch
,      hz_organization_profiles bank_prof
,      hz_organization_profiles branch_prof
WHERE  party_supp.party_id = aps.party_id
AND    party_supp.party_id = site_supp.party_id
AND    site_supp.party_site_id = ass.party_site_id
AND    ass.vendor_id = aps.vendor_id
AND    iep.payee_party_id = party_supp.party_id
AND    iep.party_site_id = site_supp.party_site_id
AND    iep.supplier_site_id = ass.vendor_site_id
AND    iep.ext_payee_id = ipi.ext_pmt_party_id
AND    ipi.instrument_id = ieb.ext_bank_account_id
AND    ieb.bank_id = party_bank.party_id
AND    ieb.bank_id = party_branch.party_id
AND    party_branch.party_id = branch_prof.party_id
AND    party_bank.party_id = bank_prof.party_id
ORDER BY party_supp.party_name
,        ass.vendor_site_code;

SELECT  aps.vendor_name "VERDOR NAME",
        apss.vendor_site_code "VENDOR SITE CODE",
        ieb.bank_name "BANK NAME",
        iebb.bank_branch_name "BANK BRANCH NAME",
        iebb.branch_number "BRANCH NUMBER",
        ieba.BANK_ACCOUNT_NUM "BANK ACCOUNT NUMBER",
        ieba.BANK_ACCOUNT_NAME "BANK ACCOUNT NAME"
FROM    ap.ap_suppliers aps,
        ap.ap_supplier_sites_all apss,
        apps.iby_ext_bank_accounts ieba,
        apps.iby_account_owners iao,
        apps.iby_ext_banks_v ieb,
        apps.iby_ext_bank_branches_v iebb
WHERE   aps.vendor_id = apss.vendor_id
        and iao.account_owner_party_id = aps.party_id
        and ieba.ext_bank_account_id = iao.ext_bank_account_id
        and ieb.bank_party_id = iebb.bank_party_id
        and ieba.branch_id = iebb.branch_party_id
        and ieba.bank_id = ieb.bank_party_id;


52 comments:

ERP said...


We are ERPTREE Leading oracle fusion HCM Online Training institute. We are providing online training services since 1999. still we are adding more oracle related courses as the technology changes. 2000+ online courses are available. we all ways achieve our goal in satisfying students in result we have global recognition to our site. we have best faculty for all of our online courses.

Oracle Fusion HCM Training

oraclefusion said...

Thanks for sharing the useful information and good points were mentioned in this article which is very informative and for the further information about the oracle apps visit our site
Oracle Fusion Financials Training

I Digital Academy said...

Superb Post.Thank You For Sharing useful information.
Spoken english Training in Bangalore

Fuzzy International said...

The best thing is that your blog really informative thanks for your great information!
cashew nuts suppliers and exporters in dubai
A4 paper suppliers and exporters in dubai

హాట్‌గర్ల్స్ said...

It's Really A Great Post.
Best IT Servicesin Bangalore

Unknown said...

It's A Nice Post.
Best Oracle Training in Bangalore

Unknown said...

Thank you for post.
Best Digital Marketing Courses in Bangalore

Unknown said...

1. Best Digital Marketing Agency
Great Information, Thanks for sharing

Unknown said...

Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website.oracle training in bangalore.

sheikh said...

Is there any one teaching oracle
mobile games development toronto
c/c++ development company
java development company
- Amna

Unknown said...

Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
Devops training in velachry
Devops training in OMR
Deops training in annanagar
Devops training in chennai
Devops training in marathahalli
Devops training in rajajinagar
Devops training in BTM Layout

nilashri said...

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
Data science training in velachery
Data science training in kalyan nagar
Data Science training in OMR
Data Science training in anna nagar
Data Science training in chennai
Data Science training in marathahalli
Data Science training in BTM layout
Data Science training in rajaji nagar


Anbarasan14 said...

Nice blog!!I really enjoyed reading your blog.Thank you so much for a detailed information! It is very helpful for me. Kindly continue the work.

Spoken English Class in Porur | Spoken English Training in Iyyappanthangal | Spoken English Classes in St.Thomas Mount

simbu said...

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

java training in chennai | java training in bangalore

java online training | java training in pune

selenium training in chennai

selenium training in bangalore

ganga said...

Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

angularjs Training in bangalore

angularjs Training in btm

angularjs Training in electronic-city

angularjs Training in online

sathya shri said...


Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

angularjs Training in bangalore

angularjs Training in btm

angularjs Training in electronic-city

angularjs Training in online

angularjs Training in marathahalli

Mounika said...

Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates...
Python training in pune
AWS Training in chennai
Python course in chennai

shethal said...

Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
Best Devops Training institute in Chennai

rohini said...

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
Selenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune | Selenium online Training

DeepikaOrange said...

Thanks for sharing such a great information.Its really nice and informative great content of different kinds of the valuable information's.The style of writing is excellent and also the content is top-notch. Thanks for that shrewdness you provide the readers!

Oracle PLSQL Training in Chennai
Oracle PLSQL Training

Anonymous said...

It was worth visiting your blog and I have bookmarked your blog. Hope to visit again

angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

angularjs Training in chennai

Unknown said...

Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi | Coimbatore taxi

asha said...

Nice post
devops course in bangalore

best devops training in bangalore

Devops certification training in bangalore

devops training in bangalore

devops training institute in bangalore

rohini said...

Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.
apple mac service center | apple ipad service center | apple service center | imac service center

sathyaramesh said...

Good job! Fruitful article. I like this very much. It is very useful for my research. It shows your interest in this topic very well. I hope you will post some more information about the software. Please keep sharing!!
ccna course in Chennai
ccna Training in Chennai
ccna Training institute in Chennai
ccna institute in Chennai
German Classes in Chennai
German Language Classes in Chennai

Aravind said...

Very interesting content which helps me to get the indepth knowledge about the technology. To know more detils about the course visit this website.
Qtp training in Chennai
Big Data Training in Chennai
Hadoop Training in Chennai
Android Training in Chennai
Selenium Training in Chennai
Digital Marketing Training in Chennai
JAVA Training in Chennai
Java classes in chennai

Aruna Ram said...

It is an excellent post! Truly very worthy concept and really thanks for this posting such a wonderful blog. Share more info like this.
Ethical Hacking Course
Ethical Hacking Certification
Hacking Course
Learn Ethical Hacking

dhivya said...


In the beginning, I would like to thank you much about this great post. Its very useful and helpful for anyone looking for tips. I like your writing style and I hope you will keep doing this good working.
Data Science Course in Chennai
Data Science Training in Chennai
Blue Prism Training Chennai
AWS Training in Chennai
Digital Marketing Course in Chennai
Data Science Training in Porur
Data Science Training in Adyar
Data Science Training in Velachery

vijaykumar said...

the article is awesome and verymuch helpful for my study.keep sharing more like this.
RPA Training in Chennai | Robotics Process Automation Training in Chennai | RPA course in Chennai
Blue Prism Training in Chennai | Blue Prism Training Institute in Chennai | RPA Training in Velachery | RPA Training in Tambaram

sheela rajesh said...

Thank you the wonderful ideas that you have shared with us.i enjoyed your ideas and the way of you gave the informations.
PHP Training in Chennai
DOT NET Training in Chennai
German Classes in Chennai
iOS Course in Chennai
ios training in Tnagar

Unknown said...

It's Really A Great Post. Looking For Some More Stuff.


shriramproperties-brake free|Pre Launch Electronic City Bangalore

rohini said...

Read all the information that i've given in above article. It'll give u the whole idea about it.
apple iphone service center in chennai | Mac book pro service center in chennai | ipod service center in chennai | apple ipad service center in chennai

chaitra691 said...

Thanks for sharing the good information and post more information. Talent flames company is one of the best training and placement companies in Hyderabad. Providing training on Technologies like Java,Sql,Oracle,..,etc with 100% Placement Assistance. Now Interviews going on if you want to attend just visit our website and drop your resume. for more information visit us http://talentflames.com/
training and placement companies in Hyderabad

Shriram Earth said...

The post was really good check this link too
shriram earth plots

priya rajesh said...

Excellent blog with unique content, thanks a lot for sharing this. I love to learn more about this topic.
Data Science Training in Chennai
Data Science Certification in Chennai
R Programming Training in Chennai
R analytics Training in Chennai
Machine Learning Training in Chennai
Machine Learning course
Data Science Training in Velachery
Data Science Course in Chennai

dhishageetha said...

The best thing is that your blog really informative thanks for your great information!

Unknown said...

Top Technologies to learn
The information given in this blog is very nice and i like it if you share more this kind of blog and i also have written this kind of blog you can also read for more knowledge.

Unknown said...

gmat training in chennai
Having a good score in GMAT is very important to get into your dream university. Choose the best GMAT coaching centres in Chennai from the list.


Unknown said...

angularjs interview questions for freshers
Important AngularJS Interview Questions and Answers for freshers and experienced to get your dream job in Angular! Basic & Advanced AngularJS Interview Questions for Freshers & Experienced.

Unknown said...

javascript technical interview questions
Important Javascript Interview Questions and Answers for freshers and experienced to get your dream job & Advanced Javascript Interview Questions for Freshers & Experienced.

mageshvary said...

This blog is really nice and informative blog, The explanation given is really comprehensive and informative.
android interview questions
android interview questions for experienced candidates
android interview preparation
blue prism interview questions
blue prism interview questions and answers
javascript interview questions
javascript interview questions and answers
salesforce interview questions

madhankumar said...

This blog is really nice and informative blog, The explanation given is really comprehensive and informative.
php interview questions and answers
php interview questions and answers for freshers
php programming interview questions
rpa interview questions and answers for experienced
nodejs interview questions
nodejs interview questions and answers
networking interview questions and answers
networking interview questions and answers pdf
ethical hacking interview questions

Vijayakash said...

This is good site and nice point of view.I learnt lots of useful information.
hadoop interview questions and answers pdf
hadoop testing interview questions and answers for experienced
hadoop developer interview questions and answers for experienced
java interview questions and answers for experienced
selenium interview questions and answers pdf
aws interview questions and answers for experienced pdf
devops interview questions and answers for experienced

karthikeyan said...

Nice blog was really feeling good to read it. Thanks for this information.
networking interview questions and answers
networking interview questions for freshers pdf
hardware and networking questions and answers pdf
php interview questions and answers
php interview questions for freshers
salesforce interview questions
salesforce developer interview questions

Amuthan said...

The information given in this blog is very nice and i like it if you share more this kind of blog and i also have written this kind of blog you can also read for more knowledge.
php interview questions for freshers
php interview questions for experienced
php basic interview questions
blue prism interview questions
blue prism interview questions and answers
javascript interview questions
javascript interview questions and answers
salesforce interview questions

ram said...


Thank you for posting informative insights, I think we have got some more information to share with! Do check out
oracle training in chennai and let us know your thoughts. Let’s have great learning

كنوز الشرق said...

شركة مكافحة حمام بجازان

شركة تعقيم بجازان

شركة تنظيف منازل بجازان

شركة تنظيف مجالس بالرياض

شركة تنظيف بيوت بالرياض

شركة تنظيف شقق بالرياض

شركة تنظيف فراشات بالرياض

شركة تنظيف فلل بالرياض

شركة تعقيم بالرياض

شركة نظافة بالرياض

شركة تنظيف بالاحساء

شركة كشف تسربات المياه بالرياض

Anonymous said...

اذا كنت من عشاق العاب الجريمة و المغامرات يمكنك تجربة تحميل لعبة جاتا 7 و الاستمتاع بي اللعبة و الدخول في جو المغامرات من خلال موقعنا تحميل العاب الكمبيوتر   يمكنك أيضا تحميل لعبة جاتا جميع الإصدارات .

dinesh said...

What a lovely article! Every word in this essay was crucial, ERP Software in Chennai and I implore you to keep writing articles with similar content.

Rupesh kumar said...

Nice blog! Thanks for sharing this valuable information. Discover the ultimate learning experience for your 7th standard student with Ziyyara Edutech's private online tuition classes.
Book A Free Demo Today visit Private tuition classes for class 7 student

pratikshaK said...

thanks for sharing this information, Full Stack Course In Amravati

Anonymous said...

Thanks for sharing the information. Keep the good work going. Dive into the world of language mastery with Ziyyara’s unparalleled online home tuition services in Bahrain.
Book a free demo today. online english grammar Class in bahrain