The links between AP and IBY tables Ap vendor banks

The links between AP and IBY tables 

Ap vendor banks

select 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"

from AP.AP_SUPPLIERS APS,

  AP.AP_SUPPLIER_SITES_ALL APSS,

  APPS.IBY_EXT_BANK_ACCOUNTS IEBA,

  APPS.IBY_ACCOUNT_OWNERS IAO,

  APPS.IBY_EXT_BANKS_V IEB,

  APPS.IBY_EXT_BANK_BRANCHES_V IEBB

where APS.VENDOR_ID            = APSS.VENDOR_ID

and IAO.ACCOUNT_OWNER_PARTY_ID = APS.PARTY_ID

and IEBA.EXT_BANK_ACCOUNT_ID   = IAO.EXT_BANK_ACCOUNT_ID

and IEB.BANK_PARTY_ID          = IEBB.BANK_PARTY_ID

and IEBA.BRANCH_ID             = IEBB.BRANCH_PARTY_ID

and IEBA.BANK_ID               = IEB.BANK_PARTY_I