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_STMTRECON

Object Details

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

View Type

A Business Intelligence System view

This shows statement reconciliation information. Statement reconciliation records the reconciliation detail of a transaction against a bank statement line.

[View Source]

Columns

Name	Datatype	Length	Comments
STATEMENT_LINE_ID	NUMBER	(15)	Bank statement line identifier.
MATCHING_TRANSACTION_TYPE_CODE	VARCHAR2	(30)	The type of transaction being matched to the statement line such as Payment Receipt, Journal Open Interface, and so forth.
MATCHING_TRANSACTION_ID	NUMBER	(15)	Identifier of the matching transaction such as check number, receipt number, journal line number and so forth.
JOURNAL_HEADER_ID	NUMBER	(15)	Journal header identifier for journal reconciliation.
RECONCILIATION_DATE	DATE		The date the statement line was reconciled.
AUTOMATICALLY_RECONCILED_FLAG	VARCHAR2	(80)	Indicates whether the reconciliation activity is done automatically by the system or manually.
AMOUNT	NUMBER		Amount of the reconciliation activity.
ORG_NAME	VARCHAR2	(240)	Organization name.
ORG_ID	NUMBER	(15)	Organization identifier.
STATEMENT_LINE_NUMBER	NUMBER	(15)	Bank statement line number.
JOURNAL_NAME	VARCHAR2	(100)	Journal entry header name.
JOURNAL_LINE_NUMBER	NUMBER		Journal entry line number.
CASH_RECEIPT_HISTORY_ID	NUMBER		Cash receipt history identifier.
CHECK_ID	NUMBER		Payment identifier.
MATCHING_STATEMENT_LINE_ID	NUMBER		Matching statement line identifier.
EXTERNAL_TRX_ID	NUMBER		External transaction identifier.
CREATED_DATE	DATE		Standard WHO column.
CREATED_BY	NUMBER	(15)	Standard WHO column.
LAST_UPDATED_DATE	DATE		Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO column.

Query Text

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


SELECT STATEMENT_LINE_ID
,      MATCHING_TRANSACTION_TYPE_CODE
,      MATCHING_TRANSACTION_ID
,      JOURNAL_HEADER_ID
,      RECONCILIATION_DATE
,      AUTOMATICALLY_RECONCILED_FLAG
,      AMOUNT
,      ORG_NAME
,      ORG_ID
,      STATEMENT_LINE_NUMBER
,      JOURNAL_NAME
,      JOURNAL_LINE_NUMBER
,      CASH_RECEIPT_HISTORY_ID
,      CHECK_ID
,      MATCHING_STATEMENT_LINE_ID
,      EXTERNAL_TRX_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.CEFV_STMTRECON;

Dependencies

[top of page]

APPS.CEFV_STMTRECON references the following:

APPS: CE_LOOKUPS; CE_STATEMENT_LINES; CE_STATEMENT_RECONCILS_ALL; GL_JE_HEADERS; HR_ALL_ORGANIZATION_UNITS

APPS.CEFV_STMTRECON is not referenced by any database object