VIEW: CE.CE_UPG_BANK_ACCOUNTS#

Source

View Text - Preformatted

select CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, CE_UPGRADE_ID CE_UPGRADE_ID, PARENT_UPGRADE_ID PARENT_UPGRADE_ID, SOURCE_PK_ID SOURCE_PK_ID, PARTY_CODE PARTY_CODE, ACCOUNT_NUMBER ACCOUNT_NUMBER, UPGRADE_STATUS UPGRADE_STATUS, PRIMARY_ACCT_FLAG PRIMARY_ACCT_FLAG, SECONDARY_ACCT_FLAG SECONDARY_ACCT_FLAG, GROUP_ID GROUP_ID, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, CREATED_BY_MODULE CREATED_BY_MODULE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BRANCH_PARTY_ID BRANCH_PARTY_ID, BANK_PARTY_ID BANK_PARTY_ID, CURRENCY_CODE CURRENCY_CODE, DESCRIPTION DESCRIPTION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CHECK_DIGITS CHECK_DIGITS, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT, EFT_REQUESTER_IDENTIFIER EFT_REQUESTER_IDENTIFIER, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE, ACCOUNT_SUFFIX ACCOUNT_SUFFIX, DESCRIPTION_CODE1 DESCRIPTION_CODE1, DESCRIPTION_CODE2 DESCRIPTION_CODE2, IBAN_NUM IBAN_NUM, SHORT_ACCOUNT_NAME SHORT_ACCOUNT_NAME, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID, ACCOUNT_OWNER_ORG_ID ACCOUNT_OWNER_ORG_ID, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION, AP_USE_ALLOWED_FLAG AP_USE_ALLOWED_FLAG, AR_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG, XTR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG, PAY_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG, MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_ALLOWED_FLAG, PAYMENT_MULTI_CURRENCY_FLAG PAYMENT_MULTI_CURRENCY_FLAG, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG, ZERO_AMOUNT_ALLOWED_FLAG ZERO_AMOUNT_ALLOWED_FLAG, MAX_OUTLAY MAX_OUTLAY, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT, AP_AMOUNT_TOLERANCE AP_AMOUNT_TOLERANCE, AP_PERCENT_TOLERANCE AP_PERCENT_TOLERANCE, AR_AMOUNT_TOLERANCE AR_AMOUNT_TOLERANCE, AR_PERCENT_TOLERANCE AR_PERCENT_TOLERANCE, XTR_AMOUNT_TOLERANCE XTR_AMOUNT_TOLERANCE, XTR_PERCENT_TOLERANCE XTR_PERCENT_TOLERANCE, PAY_AMOUNT_TOLERANCE PAY_AMOUNT_TOLERANCE, PAY_PERCENT_TOLERANCE PAY_PERCENT_TOLERANCE, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE, START_DATE START_DATE, END_DATE END_DATE, YEAR_CALC_TYPE YEAR_CALC_TYPE, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS, DAY_COUNT_TYPE_FLAG DAY_COUNT_TYPE_FLAG, ROUNDING_TYPE_FLAG ROUNDING_TYPE_FLAG, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER, TARGET_BALANCE TARGET_BALANCE, EFT_USER_NUM EFT_USER_NUM, BANK_CODE BANK_CODE, COMM_AGREEMENT_IDENTIFIER COMM_AGREEMENT_IDENTIFIER, LEGAL_ACCOUNT_NAME LEGAL_ACCOUNT_NAME, XTR_BANK_ACCOUNT_NUM XTR_BANK_ACCOUNT_NUM, AUTHORIZED_FLAG AUTHORIZED_FLAG, SUBSIDIARY_ACCOUNT_FLAG SUBSIDIARY_ACCOUNT_FLAG, CE_USE_ALLOWED_FLAG CE_USE_ALLOWED_FLAG from "CE"."CE_UPG_BANK_ACCOUNTS"

View Text - HTML Formatted

SELECT CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, CE_UPGRADE_ID CE_UPGRADE_ID
, PARENT_UPGRADE_ID PARENT_UPGRADE_ID
, SOURCE_PK_ID SOURCE_PK_ID
, PARTY_CODE PARTY_CODE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, UPGRADE_STATUS UPGRADE_STATUS
, PRIMARY_ACCT_FLAG PRIMARY_ACCT_FLAG
, SECONDARY_ACCT_FLAG SECONDARY_ACCT_FLAG
, GROUP_ID GROUP_ID
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, CREATED_BY_MODULE CREATED_BY_MODULE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BRANCH_PARTY_ID BRANCH_PARTY_ID
, BANK_PARTY_ID BANK_PARTY_ID
, CURRENCY_CODE CURRENCY_CODE
, DESCRIPTION DESCRIPTION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CHECK_DIGITS CHECK_DIGITS
, BANK_ACCOUNT_NAME_ALT BANK_ACCOUNT_NAME_ALT
, ACCOUNT_HOLDER_NAME ACCOUNT_HOLDER_NAME
, ACCOUNT_HOLDER_NAME_ALT ACCOUNT_HOLDER_NAME_ALT
, EFT_REQUESTER_IDENTIFIER EFT_REQUESTER_IDENTIFIER
, SECONDARY_ACCOUNT_REFERENCE SECONDARY_ACCOUNT_REFERENCE
, ACCOUNT_SUFFIX ACCOUNT_SUFFIX
, DESCRIPTION_CODE1 DESCRIPTION_CODE1
, DESCRIPTION_CODE2 DESCRIPTION_CODE2
, IBAN_NUM IBAN_NUM
, SHORT_ACCOUNT_NAME SHORT_ACCOUNT_NAME
, ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_PARTY_ID
, ACCOUNT_OWNER_ORG_ID ACCOUNT_OWNER_ORG_ID
, ACCOUNT_CLASSIFICATION ACCOUNT_CLASSIFICATION
, AP_USE_ALLOWED_FLAG AP_USE_ALLOWED_FLAG
, AR_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG
, XTR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG
, PAY_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG
, MULTI_CURRENCY_ALLOWED_FLAG MULTI_CURRENCY_ALLOWED_FLAG
, PAYMENT_MULTI_CURRENCY_FLAG PAYMENT_MULTI_CURRENCY_FLAG
, RECEIPT_MULTI_CURRENCY_FLAG RECEIPT_MULTI_CURRENCY_FLAG
, ZERO_AMOUNT_ALLOWED_FLAG ZERO_AMOUNT_ALLOWED_FLAG
, MAX_OUTLAY MAX_OUTLAY
, MAX_CHECK_AMOUNT MAX_CHECK_AMOUNT
, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT
, AP_AMOUNT_TOLERANCE AP_AMOUNT_TOLERANCE
, AP_PERCENT_TOLERANCE AP_PERCENT_TOLERANCE
, AR_AMOUNT_TOLERANCE AR_AMOUNT_TOLERANCE
, AR_PERCENT_TOLERANCE AR_PERCENT_TOLERANCE
, XTR_AMOUNT_TOLERANCE XTR_AMOUNT_TOLERANCE
, XTR_PERCENT_TOLERANCE XTR_PERCENT_TOLERANCE
, PAY_AMOUNT_TOLERANCE PAY_AMOUNT_TOLERANCE
, PAY_PERCENT_TOLERANCE PAY_PERCENT_TOLERANCE
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, AGENCY_LOCATION_CODE AGENCY_LOCATION_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, INTEREST_CALCULATION_BASIS INTEREST_CALCULATION_BASIS
, DAY_COUNT_TYPE_FLAG DAY_COUNT_TYPE_FLAG
, ROUNDING_TYPE_FLAG ROUNDING_TYPE_FLAG
, CASHFLOW_DISPLAY_ORDER CASHFLOW_DISPLAY_ORDER
, TARGET_BALANCE TARGET_BALANCE
, EFT_USER_NUM EFT_USER_NUM
, BANK_CODE BANK_CODE
, COMM_AGREEMENT_IDENTIFIER COMM_AGREEMENT_IDENTIFIER
, LEGAL_ACCOUNT_NAME LEGAL_ACCOUNT_NAME
, XTR_BANK_ACCOUNT_NUM XTR_BANK_ACCOUNT_NUM
, AUTHORIZED_FLAG AUTHORIZED_FLAG
, SUBSIDIARY_ACCOUNT_FLAG SUBSIDIARY_ACCOUNT_FLAG
, CE_USE_ALLOWED_FLAG CE_USE_ALLOWED_FLAG
FROM "CE"."CE_UPG_BANK_ACCOUNTS"