Tuesday, 5 July 2011

How to find Suppliers/vendors Bank name(and other bank related info). ..in PAYABLE MANGER responsibility



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