DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CEFV_BANK_ACCOUNTS

Object Details
Object Name: CEFV_BANK_ACCOUNTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CEFV_BANK_ACCOUNTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_ID NUMBER (15)
Bank account unique identifier.
BANK_ACCOUNT_NAME VARCHAR2 (100)
Bank account name.
ALTERNATE_BANK_ACCOUNT_NAME VARCHAR2 (320)
Alternate bank account name.
BANK_ACCOUNT_NUMBER VARCHAR2 (100)
Bank account number.
BANK_ACCOUNT_TYPE VARCHAR2 (25)
Bank account type.
ACCOUNT_TYPE CHAR (8)
MULTICURRENCY_ALLOWED_FLAG VARCHAR2 (1)
Indicates whether you allow payments in multiple currencies from this bank account.
POOLED_ACCOUNT_FLAG VARCHAR2 (1)
Indicates whether this is a pooled bank account.
DESCRIPTION VARCHAR2 (240)
Description of bank account.
MAXIMUM_PAYMENT_BATCH_OUTLAY NUMBER

Maximum payment batch outlay for bank account.
MINIMUM_PAYMENT_AMOUNT NUMBER

Minimum amount allowed per payment for bank account.
MAXIMUM_PAYMENT_AMOUNT NUMBER

Maximum amount allowed per payment for bank account.
ZERO_PAYMENTS_ALLOWED_FLAG VARCHAR2 (1)
Indicates whether the bank account allows zero amount payments.
CONTACT_FIRST_NAME VARCHAR2 (0)
First name of bank contact person.
CONTACT_MIDDLE_NAME VARCHAR2 (0)
Middle name of bank contact person.
CONTACT_LAST_NAME VARCHAR2 (0)
Last name of bank contact person.
CONTACT_PREFIX VARCHAR2 (0)
Title prefix of bank contact person.
CONTACT_TITLE VARCHAR2 (0)
Title of bank contact person.
CONTACT_AREA_CODE VARCHAR2 (0)
Area code of bank contact person telephone number.
CONTACT_PHONE VARCHAR2 (0)
Telephone number of bank contact person.
INACTIVE_DATE DATE

Date on which bank account becomes inactive.
ACCOUNT_HOLDER_NAME VARCHAR2 (240)
Account holder name.
ALTERNATE_ACCOUNT_HOLDER_NAME VARCHAR2 (150)
Alternate account holder name.
EFT_USER_NUMBER VARCHAR2 (30)
Electronic Funds Transfer user number.
BANK_BRANCH_ID NUMBER (15)
Bank branch unique identifier.
CURRENCY_CODE VARCHAR2 (15)
Unique code assigned to a currency.
_DF VARCHAR2 (33)
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      ALTERNATE_BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_TYPE
,      ACCOUNT_TYPE
,      MULTICURRENCY_ALLOWED_FLAG
,      POOLED_ACCOUNT_FLAG
,      DESCRIPTION
,      MAXIMUM_PAYMENT_BATCH_OUTLAY
,      MINIMUM_PAYMENT_AMOUNT
,      MAXIMUM_PAYMENT_AMOUNT
,      ZERO_PAYMENTS_ALLOWED_FLAG
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      CONTACT_AREA_CODE
,      CONTACT_PHONE
,      INACTIVE_DATE
,      ACCOUNT_HOLDER_NAME
,      ALTERNATE_ACCOUNT_HOLDER_NAME
,      EFT_USER_NUMBER
,      BANK_BRANCH_ID
,      CURRENCY_CODE
,      _DF
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.CEFV_BANK_ACCOUNTS;

Dependencies

[top of page]

APPS.CEFV_BANK_ACCOUNTS references the following:

SchemaAPPS
SynonymCE_BANK_ACCOUNTS
ViewIBY_EXT_BANK_ACCOUNTS_V

APPS.CEFV_BANK_ACCOUNTS is not referenced by any database object