Friday, May 8, 2020

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

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...