Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Retail Training Forum
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

0
Hi,
Please help me with the below queries:
I created a Supplier in AP and created the bank details for the supplier. The Supplier details got inserted into AP_SUPPLIERS and HZ_PARTIES tables.
1. The bank and branch I created on the Supplier page got inserted into HZ_PARTIES table. Does this data get inserted into any other table apart from this for the Supplier bank and Supplier branch?
2. The supplier bank account that I created got inserted into IBY_EXT_BANK_ACCOUNTS Table. But I am not able to know how to get the Bank account details if only supplier name is given from backend because I am not able to figure out how to link these tables together. 
Please help me with this
.
Thank you,

Yamini H Ravindra
Responses (1)
  • Accepted Answer

    Friday, May 06 2016, 10:36 AM - #Permalink
    0
    Following tables are used to store the supplier and bank information -
    1. IBY_EXTERNAL_PAYEES_ALL : supplier information and customer information
    2. IBY_EXT_BANK_ACCOUNTS : external bank account information
    3. IBY_PMT_INSTR_USES_ALL : Payment instruments assignments
    4. AP_SUPPLIERS : Stores Supplier Information
    5. AP_SUPPLIERS_SITES_ALL : Stores Supplier site Information
    6. Hz_Parties : Party Information

    In, IBY_external_payee_all field name - ext_payee_id is same as ext_bank_account_id in table IBY_EXT_BANK_ACCOUNTS,
    and
    column party_id in table HZ_PARTIES and Payee_party_id in IBY_EXTERNAL_PAYEES_ALL are same.

    Please execute the following query to find out the supplier bank Information -
    select IE.EXT_Payee_id,IE.Payee_party_id,ID.BRANCH_ID,ID.BANK_ID,ID.BANK_ACCOUNT_NUM,PR.PARTY_NUMBER,PR.PARTY_NAME,PR.PARTY_TYPE FROM IBY_EXTERNAL_PAYEES_ALL IE, IBY_EXT_BANK_ACCOUNTS ID, HZ_PArties PR WHERE IE.EXT_PAYEE_ID = ID.EXT_BANK_ACCOUNT_ID AND IE.PAYEE_PARTY_ID = PR.PARTY_ID;

    Thanks & Regards
    Ashish
    Attachments:
    The reply is currently minimized Show
Your Reply

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
2728293031  

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner