CE_INTERNAL_BANK_ACCTS_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 ACCOUNT_HOLDER_NAME CASHFLOW_DISPLAY_ORDER POOLED_FLAG MIN_TARGET_BALANCE MAX_TARGET_BALANCE EFT_USER_NUM MASKED_ACCOUNT_NUM MASKED_IBAN INTEREST_SCHEDULE_ID CASHPOOL_MIN_PAYMENT_AMT CASHPOOL_MIN_RECEIPT_AMT CASHPOOL_ROUND_FACTOR CASHPOOL_ROUND_RULE ASSET_CODE_COMBINATION_ID CASH_CLEARING_CCID BANK_CHARGES_CCID OBJECT_VERSION_NUMBER NETTING_ACCT_FLAG POOL_PAYMENT_METHOD_CODE POOL_BANK_CHARGE_BEARER_CODE POOL_PAYMENT_REASON_CODE POOL_PAYMENT_REASON_COMMENTS POOL_REMITTANCE_MESSAGE1 POOL_REMITTANCE_MESSAGE2 POOL_REMITTANCE_MESSAGE3 FX_CHARGE_CCID BANK_ACCOUNT_NUM_ELECTRONIC RECON_FOREIGN_BANK_XRATE_TYPE RECON_FOR_BANK_XRATE_DATE_TYPE XTR_BANK_ACCOUNT_REFERENCE RECON_RULESET_ID MANUAL_TOLERANCE_RULE_ID RECON_START_DATE BANK_EXCHANGE_RATE_TYPE RECON_DIFFERENCE_CCID PARSING_RULE_SET_ID DATA_SECURITY_FLAG GL_CUR_EXC_RATE_TYPE MULTI_CASH_RECON_ENABLED_FLAG CASH_CCID_FIXED_SEGMENTS GL_RECON_START_DATE GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 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 REAL_TIME_BAL_PROCESSING_FLAG CREATION_SOURCE_CODE

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.ACCOUNT_HOLDER_NAME , BA.CASHFLOW_DISPLAY_ORDER , BA.POOLED_FLAG , BA.MIN_TARGET_BALANCE , BA.MAX_TARGET_BALANCE , BA.EFT_USER_NUM , 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.INTEREST_SCHEDULE_ID , BA.CASHPOOL_MIN_PAYMENT_AMT , BA.CASHPOOL_MIN_RECEIPT_AMT , BA.CASHPOOL_ROUND_FACTOR , BA.CASHPOOL_ROUND_RULE , BA.ASSET_CODE_COMBINATION_ID , BA.CASH_CLEARING_CCID , BA.BANK_CHARGES_CCID , BA.OBJECT_VERSION_NUMBER , BA.NETTING_ACCT_FLAG , BA.POOL_PAYMENT_METHOD_CODE , BA.POOL_BANK_CHARGE_BEARER_CODE , BA.POOL_PAYMENT_REASON_CODE , BA.POOL_PAYMENT_REASON_COMMENTS , BA.POOL_REMITTANCE_MESSAGE1 , BA.POOL_REMITTANCE_MESSAGE2 , BA.POOL_REMITTANCE_MESSAGE3 , BA.FX_CHARGE_CCID , BA.BANK_ACCOUNT_NUM_ELECTRONIC , BA.RECON_FOREIGN_BANK_XRATE_TYPE , BA.RECON_FOR_BANK_XRATE_DATE_TYPE , BA.XTR_BANK_ACCOUNT_REFERENCE , 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.GL_CUR_EXC_RATE_TYPE , BA.MULTI_CASH_RECON_ENABLED_FLAG , BA.CASH_CCID_FIXED_SEGMENTS , BA.GL_RECON_START_DATE , 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_ATTRIBUTE11 , 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 , BA.REAL_TIME_BAL_PROCESSING_FLAG , BA.CREATION_SOURCE_CODE FROM CE_BANK_ACCOUNTS BA WHERE BA.ACCOUNT_CLASSIFICATION = 'INTERNAL' and nvl(BA.NETTING_ACCT_FLAG,'N') = 'N' and (nvl(BA.DATA_SECURITY_FLAG,'N') = 'N' or (BA.DATA_SECURITY_FLAG = 'Y' and exists( select 'x' from CE_BANK_ACCOUNT_GRANTS BAG where BAG.grantee_key = fnd_global.user_guid and BA.BANK_ACCOUNT_ID = BAG.BANK_ACCOUNT_ID and trunc(sysdate) <= nvl(bag.end_date,sysdate) )) or (BA.DATA_SECURITY_FLAG = 'Y' and exists( select 'x' from CE_BANK_ACCOUNT_GRANTS BAG, (select role_name user_role_name from fnd_session_roles FSR where session_id = fnd_global.session_id) urg where BAG.user_role_name = urg.user_role_name and BA.BANK_ACCOUNT_ID = BAG.BANK_ACCOUNT_ID and trunc(sysdate) <= nvl(bag.end_date,sysdate) )) or (BA.DATA_SECURITY_FLAG = 'Y' and exists( select 'x' from CE_BANK_ACCOUNT_GRANTS BAG, (select role_name user_role_name from fnd_session_role_sets where session_role_set_key = fnd_global.session_role_set_key) fsrs where BAG.user_role_name = fsrs.user_role_name and BA.BANK_ACCOUNT_ID = BAG.BANK_ACCOUNT_ID and trunc(sysdate) <= nvl(bag.end_date,sysdate) )))