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;


47 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