CE_BANK_ACCT_USES

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: VIEW

Columns

Name

BANK_ACCT_USE_ID

BANK_ACCOUNT_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

PRIMARY_FLAG

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

ORG_ID

ORG_PARTY_ID

AP_USE_ENABLE_FLAG

AR_USE_ENABLE_FLAG

XTR_USE_ENABLE_FLAG

PAY_USE_ENABLE_FLAG

END_DATE

INVESTMENT_LIMIT_CODE

FUNDING_LIMIT_CODE

LEGAL_ENTITY_ID

XTR_DEFAULT_SETTLEMENT_FLAG

PRICING_MODEL

AUTHORIZED_FLAG

EFT_SCRIPT_NAME

PORTFOLIO_CODE

DEFAULT_ACCOUNT_FLAG

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

BAU.BANK_ACCT_USE_ID

, BAU.BANK_ACCOUNT_ID

, BAU.LAST_UPDATE_DATE

, BAU.LAST_UPDATED_BY

, BAU.CREATION_DATE

, BAU.CREATED_BY

, BAU.LAST_UPDATE_LOGIN

, BAU.PRIMARY_FLAG

, BAU.ATTRIBUTE_CATEGORY

, BAU.ATTRIBUTE1

, BAU.ATTRIBUTE2

, BAU.ATTRIBUTE3

, BAU.ATTRIBUTE4

, BAU.ATTRIBUTE5

, BAU.ATTRIBUTE6

, BAU.ATTRIBUTE7

, BAU.ATTRIBUTE8

, BAU.ATTRIBUTE9

, BAU.ATTRIBUTE10

, BAU.ATTRIBUTE11

, BAU.ATTRIBUTE12

, BAU.ATTRIBUTE13

, BAU.ATTRIBUTE14

, BAU.ATTRIBUTE15

, BAU.REQUEST_ID

, BAU.PROGRAM_APPLICATION_ID

, BAU.PROGRAM_ID

, BAU.PROGRAM_UPDATE_DATE

, BAU.ORG_ID

, BAU.ORG_PARTY_ID

, BAU.AP_USE_ENABLE_FLAG

, BAU.AR_USE_ENABLE_FLAG

, BAU.XTR_USE_ENABLE_FLAG

, BAU.PAY_USE_ENABLE_FLAG

, BAU.END_DATE

, BAU.INVESTMENT_LIMIT_CODE

, BAU.FUNDING_LIMIT_CODE

, BAU.LEGAL_ENTITY_ID

, BAU.XTR_DEFAULT_SETTLEMENT_FLAG

, BAU.PRICING_MODEL

, BAU.AUTHORIZED_FLAG

, BAU.EFT_SCRIPT_NAME

,BAU.PORTFOLIO_CODE

,BAU.DEFAULT_ACCOUNT_FLAG

,BAU.OBJECT_VERSION_NUMBER

FROM CE_BANK_ACCT_USES_OU BAU