SELECT 
    PARTNERS_BANKACCOUNTS.ID, 
    PARTNERS_BANKACCOUNTS.ID_PARTNERS, 
    PARTNERS_BANKACCOUNTS.PREFIX, 
    PARTNERS_BANKACCOUNTS.ACCOUNT_NO, 
    PARTNERS_BANKACCOUNTS.NAME, 
    PARTNERS_BANKACCOUNTS.DESCRIPTION, 
    PARTNERS_BANKACCOUNTS.ID_CURR, 
    PARTNERS_BANKACCOUNTS.IBAN, 
    PARTNERS_BANKACCOUNTS.VARIABLE_SYMBOL, 
    PARTNERS_BANKACCOUNTS.SPECIFIC_SYMBOL, 
    PARTNERS_BANKACCOUNTS.CLIENT_DATA, 
    PARTNERS_BANKACCOUNTS.IS_DEFAULT, 
    PARTNERS_BANKACCOUNTS.FOREIGN_BANK, 
    PARTNERS_BANKACCOUNTS.FB_NAME, 
    PARTNERS_BANKACCOUNTS.FB_STREET, 
    PARTNERS_BANKACCOUNTS.FB_POSTCODE, 
    PARTNERS_BANKACCOUNTS.ID_CITIES_FB, 
    PARTNERS_BANKACCOUNTS.FB_CITY, 
    PARTNERS_BANKACCOUNTS.ID_STATES_FB, 
    PARTNERS_BANKACCOUNTS.FB_STATE_CODE, 
    PARTNERS_BANKACCOUNTS.FB_STREET_NO, 
    PARTNERS_BANKACCOUNTS.CONST_SYMBOL, 
    PARTNERS_BANKACCOUNTS.SWIFT, 
    PARTNERS_BANKACCOUNTS.BANK_CODE
FROM
     PARTNERS_BANKACCOUNTS
WHERE
    PARTNERS_BANKACCOUNTS.ID_PARTNERS IN (1000060)


