VIEW: IBY.IBY_TEMP_EXT_BANK_ACCTS#

Source

View Text - Preformatted

select TEMP_EXT_BANK_ACCT_ID TEMP_EXT_BANK_ACCT_ID, EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID, COUNTRY_CODE COUNTRY_CODE, BRANCH_ID BRANCH_ID, BANK_ID BANK_ID, BANK_NAME BANK_NAME, BANK_NUMBER BANK_NUMBER, BANK_NAME_ALT BANK_NAME_ALT, BANK_INSTITUTION_TYPE BANK_INSTITUTION_TYPE, BANK_ADDRESS_ID BANK_ADDRESS_ID, BRANCH_NUMBER BRANCH_NUMBER, BRANCH_TYPE BRANCH_TYPE, BRANCH_NAME BRANCH_NAME, BRANCH_NAME_ALT BRANCH_NAME_ALT, BIC BIC, RFC_IDENTIFIER RFC_IDENTIFIER, BANK_CODE BANK_CODE, BRANCH_ADDRESS_ID BRANCH_ADDRESS_ID, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID, OWNER_PRIMARY_FLAG OWNER_PRIMARY_FLAG, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, CURRENCY_CODE CURRENCY_CODE, IBAN IBAN, CHECK_DIGITS CHECK_DIGITS, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, ACCOUNT_SUFFIX ACCOUNT_SUFFIX, DESCRIPTION DESCRIPTION, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE, EXCHANGE_RATE EXCHANGE_RATE, START_DATE START_DATE, END_DATE END_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, NOTE NOTE, NOTE_ALT NOTE_ALT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, STATUS STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CALLING_APP_UNIQUE_REF1 CALLING_APP_UNIQUE_REF1, CALLING_APP_UNIQUE_REF2 CALLING_APP_UNIQUE_REF2, EXT_PAYEE_ID EXT_PAYEE_ID, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE CONTACT_PHONE, CONTACT_FAX CONTACT_FAX, CONTACT_EMAIL CONTACT_EMAIL from "IBY"."IBY_TEMP_EXT_BANK_ACCTS"

View Text - HTML Formatted

SELECT TEMP_EXT_BANK_ACCT_ID TEMP_EXT_BANK_ACCT_ID
, EXT_BANK_ACCOUNT_ID EXT_BANK_ACCOUNT_ID
, COUNTRY_CODE COUNTRY_CODE
, BRANCH_ID BRANCH_ID
, BANK_ID BANK_ID
, BANK_NAME BANK_NAME
, BANK_NUMBER BANK_NUMBER
, BANK_NAME_ALT BANK_NAME_ALT
, BANK_INSTITUTION_TYPE BANK_INSTITUTION_TYPE
, BANK_ADDRESS_ID BANK_ADDRESS_ID
, BRANCH_NUMBER BRANCH_NUMBER
, BRANCH_TYPE BRANCH_TYPE
, BRANCH_NAME BRANCH_NAME
, BRANCH_NAME_ALT BRANCH_NAME_ALT
, BIC BIC
, RFC_IDENTIFIER RFC_IDENTIFIER
, BANK_CODE BANK_CODE
, BRANCH_ADDRESS_ID BRANCH_ADDRESS_ID
, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID
, OWNER_PRIMARY_FLAG OWNER_PRIMARY_FLAG
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, CURRENCY_CODE CURRENCY_CODE
, IBAN IBAN
, CHECK_DIGITS CHECK_DIGITS
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, DESCRIPTION DESCRIPTION
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, PAYMENT_FACTOR_FLAG PAYMENT_FACTOR_FLAG
, FOREIGN_PAYMENT_USE_FLAG FOREIGN_PAYMENT_USE_FLAG
, EXCHANGE_RATE_AGREEMENT_NUM EXCHANGE_RATE_AGREEMENT_NUM
, EXCHANGE_RATE_AGREEMENT_TYPE EXCHANGE_RATE_AGREEMENT_TYPE
, EXCHANGE_RATE EXCHANGE_RATE
, START_DATE START_DATE
, END_DATE END_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, NOTE NOTE
, NOTE_ALT NOTE_ALT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, STATUS STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CALLING_APP_UNIQUE_REF1 CALLING_APP_UNIQUE_REF1
, CALLING_APP_UNIQUE_REF2 CALLING_APP_UNIQUE_REF2
, EXT_PAYEE_ID EXT_PAYEE_ID
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE CONTACT_PHONE
, CONTACT_FAX CONTACT_FAX
, CONTACT_EMAIL CONTACT_EMAIL
FROM "IBY"."IBY_TEMP_EXT_BANK_ACCTS"