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

 SELECT

            c.conversion_rate,

            c.conversion_date,

            b.user_conversion_type,

            c.to_currency,

            c.from_currency

            --gl.conversion_date

          FROM

            GL_DAILY_CONVERSION_TYPES b,

            GL_DAILY_RATES c

          WHERE

            b.conversion_type = c.conversion_type

            AND b.user_conversion_type = 'MOR'