Wednesday 2 June 2021

assigned suppIier BANK data

 select /*3-22887520491*/ P.PARTY_NAME AS ACCOUNT_OWNER_PARTY_NAME,ACCT.BANK_ACCOUNT_NAME

from fusion.IBY_ACCOUNT_OWNERS OWN,

fusion.IBY_EXT_BANK_ACCOUNTS ACCT,

fusion.hz_parties P

where OWN.ACCOUNT_OWNER_PARTY_ID <> -99

and OWN.EXT_BANK_ACCOUNT_ID=ACCT.EXT_BANK_ACCOUNT_ID

and ACCT.BANK_ACCOUNT_NUM=

and OWN.ACCOUNT_OWNER_PARTY_ID=P.PARTY_ID