Required Tables =>
1) ap_bank_account_uses_all
2) ap_bank_accounts_all
3) ap_bank_branches
4) po_vendors
5) po_vendor_sites_all
-----------------------------------------------------------------SELECT
pv.vendor_name
,pvs.vendor_site_code
,abb.bank_name bank_name
FROM
ap_bank_account_uses_all abau
,ap_bank_accounts_all aba
,ap_bank_branches abb
,po_vendors pv
,po_vendor_sites_all pvs
WHERE
abau.external_bank_account_id = aba.bank_account_id
AND aba.bank_branch_id = abb.bank_branch_id
AND abau.vendor_id = pv.vendor_id
AND abau.vendor_id = pvs.vendor_id
AND abau.vendor_site_id = pvs.vendor_site_id
No comments:
Post a Comment