Thursday, December 16, 2010
In this post, I tried to show the relationship between Important Supplier tables, TCA Tables, Payment Tables with the help of a query. I hope it will be useful.
Ø IBY_EXTERNAL_PAYEES_ALL : supplier information and customer information
Ø IBY_EXT_BANK_ACCOUNTS : external bank account information
Ø IBY_PMT_INSTR_USES_ALL : Payment instruments assignments
Ø AP_SUPPLIERS : Stores Supplier Information
Ø AP_SUPPLIERS_SITES_ALL : Stores Supplier site Information
/* Supplier Site Information */
/* Bank Information*/
/* Bank Address */
/* Bank Branch Address */
FROM ap_supplier_sites_all assa
WHERE assa.vendor_site_id = iepa.supplier_site_id
AND hp.party_id = ieba.bank_id
AND ipiua.instrument_id = ieba.ext_bank_account_id
AND ipiua.ext_pmt_party_id = iepa.ext_payee_id
AND assa.vendor_id = aps.vendor_id
AND ieba.branch_id = hp1.party_id
AND ipiua.instrument_type = 'BANKACCOUNT'
AND ipiua.payment_flow = 'DISBURSEMENTS'
AND ipiua.order_of_preference = 1;
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.