[Fusion] SQL query to get Bank Account Details of Supplier in Oracle Fusion

Objects used:

POZ_SUPPLIER_SITES_V view for supplier site

POZ_SUPPLIERS_V view for supplier

IBY_EXT_BANK_ACCOUNTS_V view for bank accounts

IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds disbursement payment process for external party payees. This table corresponds to the supplier attributes.

IBY_EXT_PARTY_PMT_MTHDS stores payment method applicability driven by the preferences of the external party. A payment method is applicable to a party and payment function combination and, optionally and additionally, to a party site and/or organization. This table is shared by funds capture and fund disbursement flows.

IBY_PMT_INSTR_USES_ALL Payment instruments assignments

 

Use the below SQL query to get Bank Account Details of Supplier in Oracle Fusion:

SELECT

     pv.vendor_name

    ,pv.vendor_site_code    

    ,pv.segment1

    ,ixpmt.payment_method_code

    ,ixpmt.primary_flag

    ,bankacct.bank_name

    ,bankacct.bank_number

    ,bankacct.bank_branch_name

    ,bankacct.branch_number

    ,bankacct.bank_account_number

FROM poz_supplier_sites_v pvsa

    ,poz_suppliers_v pv

    ,iby_external_payees_all ixpee

    ,iby_ext_party_pmt_mthds ixpmt

    ,iby_pmt_instr_uses_all pmtins

    ,iby_ext_bank_accounts_v bankacct

WHERE 1 = 1

    AND pv.vendor_id = pvsa.vendor_id

    AND pvsa.PARTY_SITE_ID = ixpee.PARTY_SITE_ID(+)

    AND pvsa.VENDOR_SITE_ID = ixpee.SUPPLIER_SITE_ID(+)

    AND ixpee.EXT_PAYEE_ID = ixpmt.EXT_PMT_PARTY_ID(+)

    AND ixpee.ext_payee_id = pmtins.ext_pmt_party_id (+)

    AND pmtins.instrument_id = bankacct.ext_bank_account_id (+)

 

 

 

 

Source: https://docs.oracle.com