You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable To Find The Unique Table Value For Joining 3 Tables To Fetch Bank Account Information

in Supplier Management 2 comments

Summary:

Hi Team,

We are unable to find the unique value for joining these 3 tables ("IBY_EXT_BANK_ACCOUNTS" & "POZ_APPROVAL_HISTORY" & "poz_supplier_registrations psr").

Business requirement is to fetch the "Bank Account" information based on vendor registration.

However, oracle support provided the table called "IBY_EXT_BANK_ACCOUNTS".

We are able to fetch (BANK_ID , BRANCH_ID) table in "IBY_EXT_BANK_ACCOUNTS" but we are unable to fetch same table in other 2 tables.

Could you please help us how to find the joint in tables so that we get the Bank account information based on vendor registration details?.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!