eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CEFV_BANK_STATEMENTS

Object Details

Object Name:	CEFV_BANK_STATEMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CEFV_BANK_STATEMENTS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

It is a detailed banking transaction, such as a debit and a credit, and its reconciliation status. Along with the Bank Statements, represents a bank statement receive from bank.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STATEMENT_ID	NUMBER	(15)	Yes	Bank statement identifier.
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Bank account number of the statement.
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank account name of the statement.
STATEMENT_NUMBER	VARCHAR2	(50)	Yes	A number or code assigned by the bank to uniquely identify the bank statement.
STATEMENT_DATE	DATE		Yes	Bank statement generation date.
BEGINNING_BALANCE	NUMBER			Beginning balance of the bank statement.
DEBIT_TOTAL	NUMBER			Total payment amount of the bank statement.
CREDIT_TOTAL	NUMBER			Total deposit or receipt amount of the bank statement.
ENDING_BALANCE	NUMBER			Ending balance of the bank statement.
DEBIT_LINE_COUNT	NUMBER			Total number of payment transactions in the bank statement.
CREDIT_LINE_COUNT	NUMBER			Total number of receipt transactions in the bank statement.
CURRENCY_CODE	VARCHAR2	(15)		Monetary currency of the amounts shown on the bank statement.
COMPLETION_STATUS	VARCHAR2	(1)		Indicates whether the bank statement is completely reconciled or not.
DOCUMENT_SEQUENCE_NUMBER	NUMBER			A sequence number assigned by the system or by you. This number may be used to uniquely identify your bank statements.
ORG_NAME	VARCHAR2	(240)		Organization name.
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier.
ORG_ID	NUMBER	(15)		Organization identifier.
CREATED_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATED_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
CHECK_DIGITS	VARCHAR2	(30)		Holds any check digits that result from bank account number validation in FBS.

Query Text

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


SELECT STATEMENT_ID
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_NAME
,      STATEMENT_NUMBER
,      STATEMENT_DATE
,      BEGINNING_BALANCE
,      DEBIT_TOTAL
,      CREDIT_TOTAL
,      ENDING_BALANCE
,      DEBIT_LINE_COUNT
,      CREDIT_LINE_COUNT
,      CURRENCY_CODE
,      COMPLETION_STATUS
,      DOCUMENT_SEQUENCE_NUMBER
,      ORG_NAME
,      BANK_ACCOUNT_ID
,      ORG_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CHECK_DIGITS
FROM APPS.CEFV_BANK_STATEMENTS;

Dependencies

[top of page]

APPS.CEFV_BANK_STATEMENTS references the following:

APPS: CE_BANK_ACCOUNTS; CE_STATEMENT_HEADERS; HR_ALL_ORGANIZATION_UNITS

APPS.CEFV_BANK_STATEMENTS is not referenced by any database object