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;


71 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

sivanesan said...

Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
erp software in chennai

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

sunitha vishnu said...


Thanks for posting useful information.You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read..
please sharing like this information......
Android training in chennai
Ios training in chennai

Reena raj said...



Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
Web Design Company
Web Development Company

john stany said...


Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..
Android App Development Company
iOS App Development Company

louis philip said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
Fitness SMS
Fitness Text
Salon SMS
Salon Text
Investor Relation SMS
Investor Relation Text

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

Top beauty parlours in Bangalore said...

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

Top beauty parlours in Bangalore said...

Very Helpful Blog. Well thanks for sharing such a nice blog.!!
Best English Classes in Bangalore

Chaithra L said...

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

Chaithra L said...

Thank you for post.
Best Digital Marketing Courses in Bangalore

SSS Digital Marketing Services said...

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

Renith Harsan 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.

sobiga J said...

Thank you for such a knowledgeable post!

Php training in chennai
Big data Hadoop Training in chennai

Mohamed Umer Farook said...

Thank you !!
2018 - 2019 Latest IEEE Projects Free download
ieee projects free download
To get this project
Get the Project Source Code Link : http://gg-l.xyz/kFZzLmR

Top beauty parlours in Bangalore said...


helpful information, thanks for writing and share this information
freelance adwords specialist

المتوكل على الله said...


شركة رش مبيدات بالدمام
شركة مكافحة الحشرات بالدمام
شركة تنظيف بالدمام
شركة تسليك مجارى بالدمام
شركة تنظيف خزانات بالدمام
شركة تنظيف مساجد بالدمام
شركة تنظيف واجهات حجر بالدمام
شركة تنظيف مسابح بالدمام
شركة عزل خزانات -بالدمام

Bee Yes said...

Fantastic Article ! Thanks for sharing this Lovely Post !!

SEO LHR said...

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

shimaam hassan said...

نقدم شركة العربي للخدمات المنزلية خدماتها في مجال تنظيف السجاد والفرش والمجالس

شركة تنظيف سجاد

شركة تنظيف فرش

شركة تنظيف موكيت

شركة تنظيف كنب

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

shimaam hassan said...

تقدم شركة العربي للخدمات المنزلية خدماتها في مجال تنظيف المنازل والفلل و جلي البلاط

شركة تنظيف منازل وفلل بحائل

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

شركة جلي بلاط بحائل

شركة تنظيف مساجد بحائل

شركة تنسيق حدائق بحائل

shimaam hassan said...

تقدم شركة العربي للخدمات المنزلية خدماتها في مجال نقل الاثاث داخل المملكة

شركة نقل اثاث بحائل

شركة نقل عفش بحائل

دينا نقل اثاث بحائل

Arasu Groups said...

Very Nice Blog Updation Keep Updating !!

PLC Training Chennai said...

PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC SCADA Training in Chennai | PLC SCADA DCS Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai | PLC Training Centre in Chennai | PLC SCADA Training in Chennai | Automation Training Institute in Chennai | PLC Training in Kerala

UniversalTelecoms said...

Article is very informative nice to read it

kanchipuram silk sarees said...


After going over a handful of the articles on your web page, I truly appreciate your
technique of writing a blog. I added it to my bookmark site
list and will be checking back in the near future. Please visit my website too and tell
me your opinion.


kanchipuram sarees

Leto Sys said...

Amazing post.Thanks for your details and explanations..I want more information from your side.Thank you
manufacturing erp software in chennai

Ahmed Mary said...


السلام عليكم ورحمة الله وبركاته اما بعد ، اهالي المنطقبة الشرقيه بالمملكة العربية السعوديه يسر شركة شام للخدمات المنزليه ان تعلن لجميع اهالي المنطقه عن بدأ تقديم خدماتها الخاصه بالمسابح للموسم الصيفي الجديد وذلك من خلال فروعا في مدينة الدمام ومدينة الخبر ومدينة القطيف ومدينة الجبيل ، واما عن فرعنا في مدينة الدمام فسوف تجدونه علي المتصفح تحت اسم
شركة تنظيف مسابح بالدمام
وايضا تحت اسم
شركة صيانة مسابح بالدمام
مقترنا برقم هاتف مندوبنا بالدمام لذل فللفحصول علي اي خدمه تخص المسابح تنظيفها او تشغيلها او صيانتها فليس عليك الا التصال بنا وسوف نصلك فورا ، واما اذل كنت من اهل مدينة الخبر وتحتاج الي ان تستفيد من خدماتنا في مدينة الخبر فسوف تجدنا علي المتصفح تحت اسم
شركة صيانة وتنظيف مسابح بالخبر
وفي هذا الفرع نسعد بتقديم كل الخدمات التي تخص المسابح لاهالي الخبر من خدمات تنظيف او صيانة او تشغيل برك السباحه ،ولاننا قد عملنا في شركة شام علي تغطية المنطقة الشرقيه كافه فقد حرصنا علي ان يكون لنا فرع في مدينة القطيف يختص بتقديم خدمات المسابح لجميع اهالي مدينة القطيف والذي سوف تجدونه علي المتصفح تحت مسمى
شركة تنظيف وصيانة مسابح بالقطيف
وهنا سوف تجدون كل ما يخص المسابح من خدمات تنظيف المسابح بالقطيف وصيانتها وتشغيلها ‘واما عن مدينة الجبيل فلنا ايضا هناك فرع يختص بتقديم خدمات المسابح لجميع اهالي الجبيل من تنظيف وصيانه وتشغيل وهذا الفرع سوف تجدونه علي المتصفح تحت اسم
شركة صيانة وتنظيف مسابح بالجبيل
بهذا اعزائي نكون في شركة شام قد استطعنا ان نغطي كافة انحاء المنطقة الشرقيه وتقديم كافة خدمات المسابح التي يحتاجها اهالي المنطقه باحدث الاساليب والطرق العلميه وباستخدام افضل مواد التنظيف واحسن اجهزة ومعدات الصيانه والتعقيم ، فلا تقلق عزيزي العميل ولا تحتار فشركة شام هي افضل اختيار .

Ram priya 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

Nila shri 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

Mouni yoga 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

Unknown said...

myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

Rohini .R 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

Deepika Analy 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

Rigid Box said...

Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Luxury Watch Box | Shoe Box Manufacturer | Luxury Cosmetics Box

Bee Yes 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

mounika said...

Nice post..

salesforce training in btm

salesforce admin training in btm

salesforce developer training in btm

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

manisha 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

manisha said...

I read a lot of blog post and i have never hear the topics like this
apple service center chennai | apple iphone service center chennai | apple ipad service center chennai | apple mac service center chennai | ipad service center

jenifer irene said...

Very useful information, Keep posting more blog like this, Thank you.
Aviation Academy in Chennai
Aviation Courses in Chennai
best aviation academy in chennai
aviation training in chennai

lekha mathan said...

Very interesting post! Thanks for sharing your experience suggestions.
air hostess training in Bangalore
air hostess academy Bangalore
air hostess training
air hostess course

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

aditya said...

Thanks for sharing this unique information with us. Your post is really awesome. Your blog is really helpful for me..
hospital equipment
sarthak maditech
hospital equipment suppliers
hospital equipment manufacturers
medical equipment manufacturers in jaipur
operation theater lights
hospital suction machine
alcohol breath tester
hospital furniture manufacturer

Unknown said...

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


shriramproperties-brake free|Pre Launch Electronic City Bangalore

OLIVIA H 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

ajay prakash said...

This is really impressive post, I am inspired with your post, do post more blogs like this, I am waiting for your blogs.
Aviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
best aviation academy in Chennai
air hostess academy in Chennai
airline and airport management courses in Chennai
airport ground staff training in Chennai

Preeti Kumari said...

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

Tony Stark said...

PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC Training Centre in Chennai | SCADA Training in Chennai | DCS Training in Chennai | PLC Training in Anna Nagar | PLC Training Institute in Anna Nagar | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai

Tony Stark said...

PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC SCADA Training in Chennai | PLC SCADA DCS Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai | PLC Training Centre in Chennai | PLC SCADA Training in Chennai | DCS Training in Chennai | DCS Training Institute in Chennai | Automation Training Institute in Chennai | Inplant Training in Chennai

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

jenifer irene said...

This is really a valuable post... The info shared is helpful and valuable. Thank you for sharing.
aviation training in Chennai
air hostess academy in Chennai
Airline Courses in Chennai
Ground staff training in Chennai
Aviation Academy in Chennai
air hostess training in Chennai
airport management courses in Chennai
ground staff training in Chennai

venkatesh@CS said...

Thank you for excellent article. You made an article that is interesting.
hadoop interview questions
Hadoop interview questions for experienced
Hadoop interview questions for freshers
top 100 hadoop interview questions
frequently asked hadoop interview questions
hadoop interview questions and answers for freshers
hadoop interview questions and answers pdf
hadoop interview questions and answers
hadoop interview questions and answers for experienced
hadoop interview questions and answers for testers
hadoop interview questions and answers pdf download

Venkatesh CS said...

Thanks for sharing valuable information.
Digital Marketing training Course in chennai
digital marketing training institute in chennai
digital marketing training in Chennai
digital marketing course in Chennai
digital marketing course training in omr
digital marketing certification in omr
digital marketing course training in velachery
digital marketing training center in chennai
digital marketing courses with placement in chennai
digital marketing certification in chennai
digital marketing institute in Chennai
digital marketing certification course in Chennai
digital marketing course training in Chennai
Digital Marketing course in Chennai with placement
digital marketing courses in chennai

rajeev said...

Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com

Vijayakash said...

DevOps Training in Chennai
I am glad that I have visited this blog. Really helpful, eagerly waiting for more updates.