EP-Bank Detail
Description
SELECT asp.segment1 vendor_num, asp.vendor_name, hou.name, asa.vendor_site_code, ieb.country_code, cbbv.bank_name, cbbv.bank_number, cbbv.bank_branch_name, cbbv.branch_number, cbbv.bank_branch_type, cbbv.eft_swift_code, ieb.bank_account_num, ieb.currency_code, ieb.iban, ieb.foreign_payment_use_flag, ieb.bank_account_name_alt FROM apps.iby_pmt_instr_uses_all instrument, apps.iby_account_owners owners, apps.iby_external_payees_all payees, apps.hr_operating_units hou, apps.iby_ext_bank_accounts ieb, apps.ap_supplier_sites_all asa, apps.ap_suppliers asp, apps.ce_bank_branches_v cbbv WHERE owners.primary_flag = 'Y' AND owners.ext_bank_account_id = ieb.ext_bank_account_id AND owners.ext_bank_account_id = instrument.instrument_id AND payees.ext_payee_id = instrument.ext_pmt_party_id AND payees.payee_party_id = owners.account_owner_party_id AND payees.supplier_site_id = asa.vendor_site_id AND asa.vendor_id = asp.vendor_id AND hou.organization_id = asa.org_id AND cbbv.branch_party_id(+) = ieb.branch_id and asa.org_id = fnd_profile.value('ORG_ID') ORDER BY hou.name, asp.segment1 |