How a supplier bank branch id is associated with location id ?

How to identify an active record when one single record of iby_ext_bank_branches_v.branch_party_id is attached to multiple records in hz_locations.location_id ?

Thanks,

Soumya

Reference :

SELECT 

hl.address1,

hl.address2,

hl.address3,

hl.address4,

hl.city,

hl.state,

hl.postal_code,

hl.location_id,

iebb.branch_party_id,

iebb.object_version_number,

aps.vendor_name "VERDOR NAME",

apss.vendor_site_code "VENDOR SITE CODE",

ieb.bank_name "BANK NAME",

iebb.bank_branch_name "BANK BRANCH NAME",

iebb.branch_number "BRANCH NUMBER",

ieba.bank_account_num "BANK ACCOUNT NUMBER",

ieba.bank_account_name "BANK ACCOUNT NAME",