Supplier and Supplier Site Level External Bank Queries in R12

— Supplier Level External Bank SELECT hzp.party_name “VENDOR NAME”, aps.segment1 “VENDOR NUMBER”, ieb.bank_account_num “ACCOUNT NUMBER”, ieb.bank_account_name “ACCOUNT NAME”, ieb.bank_account_type “Bank Account Type”, ieb.ext_bank_account_id, ieb.bank_account_num, ieb.iban ext_bank_account_iban_number, ieb.bank_account_name, ieb.bank_account_name_alt, ieb.bank_account_num_electronic, ieb.end_date bank_account_end_date, aps.party_id, aps.vendor_name, NULL, NULL, […]