VIEW: APPS.CE_BANK_ACCOUNTS_V

Source

View Text - Preformatted

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.PAYMENT_MULTI_CURRENCY_FLAG , BA.RECEIPT_MULTI_CURRENCY_FLAG , BA.ZERO_AMOUNT_ALLOWED , BA.MAX_OUTLAY , BA.MAX_CHECK_AMOUNT , BA.MIN_CHECK_AMOUNT , BA.AP_AMOUNT_TOLERANCE , BA.AR_AMOUNT_TOLERANCE , BA.XTR_AMOUNT_TOLERANCE , BA.PAY_AMOUNT_TOLERANCE , BA.AP_PERCENT_TOLERANCE , BA.AR_PERCENT_TOLERANCE , BA.XTR_PERCENT_TOLERANCE , BA.PAY_PERCENT_TOLERANCE , 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 , BA.MASKED_ACCOUNT_NUM , BA.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 FROM CE_INTERNAL_BANK_ACCTS_V BA WHERE nvl(BA.NETTING_ACCT_FLAG, 'N') = 'N'

View Text - HTML Formatted

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.PAYMENT_MULTI_CURRENCY_FLAG
, BA.RECEIPT_MULTI_CURRENCY_FLAG
, BA.ZERO_AMOUNT_ALLOWED
, BA.MAX_OUTLAY
, BA.MAX_CHECK_AMOUNT
, BA.MIN_CHECK_AMOUNT
, BA.AP_AMOUNT_TOLERANCE
, BA.AR_AMOUNT_TOLERANCE
, BA.XTR_AMOUNT_TOLERANCE
, BA.PAY_AMOUNT_TOLERANCE
, BA.AP_PERCENT_TOLERANCE
, BA.AR_PERCENT_TOLERANCE
, BA.XTR_PERCENT_TOLERANCE
, BA.PAY_PERCENT_TOLERANCE
, 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
, BA.MASKED_ACCOUNT_NUM
, BA.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
FROM CE_INTERNAL_BANK_ACCTS_V BA
WHERE NVL(BA.NETTING_ACCT_FLAG
, 'N') = 'N'