CE_BANK_ACCOUNTS_V
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: VIEW
Columns
Name |
---|
BANK_ACCOUNT_ID BANK_ACCOUNT_NAME LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY BANK_ACCOUNT_NUM BANK_BRANCH_ID BANK_ID CURRENCY_CODE DESCRIPTION ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE CHECK_DIGITS BANK_ACCOUNT_NAME_ALT ACCOUNT_HOLDER_ID EFT_REQUESTER_IDENTIFIER SECONDARY_ACCOUNT_REFERENCE ACCOUNT_SUFFIX DESCRIPTION_CODE1 DESCRIPTION_CODE2 IBAN_NUMBER SHORT_ACCOUNT_NAME ACCOUNT_OWNER_PARTY_ID ACCOUNT_OWNER_ORG_ID ACCOUNT_CLASSIFICATION AP_USE_ALLOWED_FLAG AR_USE_ALLOWED_FLAG XTR_USE_ALLOWED_FLAG PAY_USE_ALLOWED_FLAG MULTI_CURRENCY_ALLOWED_FLAG ZERO_AMOUNT_ALLOWED MAX_OUTLAY MAX_CHECK_AMOUNT MIN_CHECK_AMOUNT BANK_ACCOUNT_TYPE AGENCY_LOCATION_CODE START_DATE END_DATE ACCOUNT_HOLDER_NAME_ALT CASHFLOW_DISPLAY_ORDER ACCOUNT_HOLDER_NAME MASKED_ACCOUNT_NUM MASKED_IBAN POOLED_FLAG MIN_TARGET_BALANCE MAX_TARGET_BALANCE EFT_USER_NUM INTEREST_SCHEDULE_ID ASSET_CODE_COMBINATION_ID RECON_RULESET_ID MANUAL_TOLERANCE_RULE_ID RECON_START_DATE BANK_EXCHANGE_RATE_TYPE RECON_DIFFERENCE_CCID PARSING_RULE_SET_ID DATA_SECURITY_FLAG XTR_BANK_ACCOUNT_REFERENCE GL_CUR_EXC_RATE_TYPE GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 |
Query
SQL_Statement |
---|
SELECT BA.BANK_ACCOUNT_ID , BA.BANK_ACCOUNT_NAME , BA.LAST_UPDATE_DATE , BA.LAST_UPDATED_BY , BA.LAST_UPDATE_LOGIN , BA.CREATION_DATE , BA.CREATED_BY , BA.BANK_ACCOUNT_NUM , BA.BANK_BRANCH_ID , BA.BANK_ID , BA.CURRENCY_CODE , BA.DESCRIPTION , BA.ATTRIBUTE_CATEGORY , BA.ATTRIBUTE1 , BA.ATTRIBUTE2 , BA.ATTRIBUTE3 , BA.ATTRIBUTE4 , BA.ATTRIBUTE5 , BA.ATTRIBUTE6 , BA.ATTRIBUTE7 , BA.ATTRIBUTE8 , BA.ATTRIBUTE9 , BA.ATTRIBUTE10 , BA.ATTRIBUTE11 , BA.ATTRIBUTE12 , BA.ATTRIBUTE13 , BA.ATTRIBUTE14 , BA.ATTRIBUTE15 , BA.REQUEST_ID , BA.PROGRAM_APPLICATION_ID , BA.PROGRAM_ID , BA.PROGRAM_UPDATE_DATE , BA.CHECK_DIGITS , BA.BANK_ACCOUNT_NAME_ALT , BA.ACCOUNT_HOLDER_ID , BA.EFT_REQUESTER_IDENTIFIER , BA.SECONDARY_ACCOUNT_REFERENCE , BA.ACCOUNT_SUFFIX , BA.DESCRIPTION_CODE1 , BA.DESCRIPTION_CODE2 , BA.IBAN_NUMBER , BA.SHORT_ACCOUNT_NAME , BA.ACCOUNT_OWNER_PARTY_ID , BA.ACCOUNT_OWNER_ORG_ID , BA.ACCOUNT_CLASSIFICATION , BA.AP_USE_ALLOWED_FLAG , BA.AR_USE_ALLOWED_FLAG , BA.XTR_USE_ALLOWED_FLAG , BA.PAY_USE_ALLOWED_FLAG , BA.MULTI_CURRENCY_ALLOWED_FLAG , BA.ZERO_AMOUNT_ALLOWED , BA.MAX_OUTLAY , BA.MAX_CHECK_AMOUNT , BA.MIN_CHECK_AMOUNT , BA.BANK_ACCOUNT_TYPE , BA.AGENCY_LOCATION_CODE , BA.START_DATE , BA.END_DATE , BA.ACCOUNT_HOLDER_NAME_ALT , BA.CASHFLOW_DISPLAY_ORDER , BA.ACCOUNT_HOLDER_NAME , CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_BANK_ACCT_NUM(BA.BANK_ACCOUNT_ID) AS MASKED_ACCOUNT_NUM , CE_BANK_AND_ACCOUNT_UTIL.GET_MASKED_IBAN(BA.BANK_ACCOUNT_ID) AS MASKED_IBAN , BA.POOLED_FLAG , BA.MIN_TARGET_BALANCE , BA.MAX_TARGET_BALANCE , BA.EFT_USER_NUM , BA.INTEREST_SCHEDULE_ID , BA.ASSET_CODE_COMBINATION_ID , BA.RECON_RULESET_ID , BA.MANUAL_TOLERANCE_RULE_ID , BA.RECON_START_DATE , BA.BANK_EXCHANGE_RATE_TYPE , BA.RECON_DIFFERENCE_CCID , BA.PARSING_RULE_SET_ID , BA.DATA_SECURITY_FLAG , BA.XTR_BANK_ACCOUNT_REFERENCE , BA.GL_CUR_EXC_RATE_TYPE , BA.GLOBAL_ATTRIBUTE_CATEGORY , BA.GLOBAL_ATTRIBUTE1 , BA.GLOBAL_ATTRIBUTE2 , BA.GLOBAL_ATTRIBUTE3 , BA.GLOBAL_ATTRIBUTE4 , BA.GLOBAL_ATTRIBUTE5 , BA.GLOBAL_ATTRIBUTE6 , BA.GLOBAL_ATTRIBUTE7 , BA.GLOBAL_ATTRIBUTE8 , BA.GLOBAL_ATTRIBUTE9 , BA.GLOBAL_ATTRIBUTE10 , BA.GLOBAL_ATTRIBUTE12 , BA.GLOBAL_ATTRIBUTE13 , BA.GLOBAL_ATTRIBUTE14 , BA.GLOBAL_ATTRIBUTE15 , BA.GLOBAL_ATTRIBUTE16 , BA.GLOBAL_ATTRIBUTE17 , BA.GLOBAL_ATTRIBUTE18 , BA.GLOBAL_ATTRIBUTE19 , BA.GLOBAL_ATTRIBUTE20 , BA.ATTRIBUTE_NUMBER1 , BA.ATTRIBUTE_NUMBER2 , BA.ATTRIBUTE_NUMBER3 , BA.ATTRIBUTE_NUMBER4 , BA.ATTRIBUTE_NUMBER5 , BA.ATTRIBUTE_DATE1 , BA.ATTRIBUTE_DATE2 , BA.ATTRIBUTE_DATE3 , BA.ATTRIBUTE_DATE4 , BA.ATTRIBUTE_DATE5 , BA.GLOBAL_ATTRIBUTE_NUMBER1 , BA.GLOBAL_ATTRIBUTE_NUMBER2 , BA.GLOBAL_ATTRIBUTE_NUMBER3 , BA.GLOBAL_ATTRIBUTE_NUMBER4 , BA.GLOBAL_ATTRIBUTE_NUMBER5 , BA.GLOBAL_ATTRIBUTE_DATE1 , BA.GLOBAL_ATTRIBUTE_DATE2 , BA.GLOBAL_ATTRIBUTE_DATE3 , BA.GLOBAL_ATTRIBUTE_DATE4 , BA.GLOBAL_ATTRIBUTE_DATE5 FROM CE_INTERNAL_BANK_ACCTS_V BA WHERE (BA.AP_USE_ALLOWED_FLAG = 'Y' or BA.AR_USE_ALLOWED_FLAG = 'Y') and exists (select 'x' from CE_BANK_ACCT_USES_OU BAU WHERE BA.BANK_ACCOUNT_ID = BAU.BANK_ACCOUNT_ID) |