VIEW: CE.CE_BANK_ACCT_USES_ALL#

Source

View Text - Preformatted

select BANK_ACCT_USE_ID BANK_ACCT_USE_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, 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, PRIMARY_FLAG PRIMARY_FLAG, 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, ORG_ID ORG_ID, ORG_PARTY_ID ORG_PARTY_ID, AP_USE_ENABLE_FLAG AP_USE_ENABLE_FLAG, AR_USE_ENABLE_FLAG AR_USE_ENABLE_FLAG, XTR_USE_ENABLE_FLAG XTR_USE_ENABLE_FLAG, PAY_USE_ENABLE_FLAG PAY_USE_ENABLE_FLAG, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID, POOLED_FLAG POOLED_FLAG, END_DATE END_DATE, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID, PAYMENT_DOC_CATEGORY PAYMENT_DOC_CATEGORY, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, INVESTMENT_LIMIT_CODE INVESTMENT_LIMIT_CODE, FUNDING_LIMIT_CODE FUNDING_LIMIT_CODE, AP_DEFAULT_SETTLEMENT_FLAG AP_DEFAULT_SETTLEMENT_FLAG, XTR_DEFAULT_SETTLEMENT_FLAG XTR_DEFAULT_SETTLEMENT_FLAG, PAYROLL_BANK_ACCOUNT_ID PAYROLL_BANK_ACCOUNT_ID, PRICING_MODEL PRICING_MODEL, AUTHORIZED_FLAG AUTHORIZED_FLAG, EFT_SCRIPT_NAME EFT_SCRIPT_NAME, PORTFOLIO_CODE PORTFOLIO_CODE, DEFAULT_ACCOUNT_FLAG DEFAULT_ACCOUNT_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AR_CLAIM_INV_ACT_ID AR_CLAIM_INV_ACT_ID, NEW_AR_RCPTS_RECEIVABLE_TRX_ID NEW_AR_RCPTS_RECEIVABLE_TRX_ID from "CE"."CE_BANK_ACCT_USES_ALL"

View Text - HTML Formatted

SELECT BANK_ACCT_USE_ID BANK_ACCT_USE_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, 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
, PRIMARY_FLAG PRIMARY_FLAG
, 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
, ORG_ID ORG_ID
, ORG_PARTY_ID ORG_PARTY_ID
, AP_USE_ENABLE_FLAG AP_USE_ENABLE_FLAG
, AR_USE_ENABLE_FLAG AR_USE_ENABLE_FLAG
, XTR_USE_ENABLE_FLAG XTR_USE_ENABLE_FLAG
, PAY_USE_ENABLE_FLAG PAY_USE_ENABLE_FLAG
, EDISC_RECEIVABLES_TRX_ID EDISC_RECEIVABLES_TRX_ID
, UNEDISC_RECEIVABLES_TRX_ID UNEDISC_RECEIVABLES_TRX_ID
, POOLED_FLAG POOLED_FLAG
, END_DATE END_DATE
, BR_STD_RECEIVABLES_TRX_ID BR_STD_RECEIVABLES_TRX_ID
, PAYMENT_DOC_CATEGORY PAYMENT_DOC_CATEGORY
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, INVESTMENT_LIMIT_CODE INVESTMENT_LIMIT_CODE
, FUNDING_LIMIT_CODE FUNDING_LIMIT_CODE
, AP_DEFAULT_SETTLEMENT_FLAG AP_DEFAULT_SETTLEMENT_FLAG
, XTR_DEFAULT_SETTLEMENT_FLAG XTR_DEFAULT_SETTLEMENT_FLAG
, PAYROLL_BANK_ACCOUNT_ID PAYROLL_BANK_ACCOUNT_ID
, PRICING_MODEL PRICING_MODEL
, AUTHORIZED_FLAG AUTHORIZED_FLAG
, EFT_SCRIPT_NAME EFT_SCRIPT_NAME
, PORTFOLIO_CODE PORTFOLIO_CODE
, DEFAULT_ACCOUNT_FLAG DEFAULT_ACCOUNT_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AR_CLAIM_INV_ACT_ID AR_CLAIM_INV_ACT_ID
, NEW_AR_RCPTS_RECEIVABLE_TRX_ID NEW_AR_RCPTS_RECEIVABLE_TRX_ID
FROM "CE"."CE_BANK_ACCT_USES_ALL"