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.CE_CP_XTO_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REFERENCE_ID	NUMBER		Yes	Reference identifier
BANK_ACCOUNT_ID	NUMBER	(15)		Bank account identifier
CASH_ACTIVITY_DATE	DATE			Cash activity date
DEAL_NUMBER	NUMBER		Yes	Deal Number
BASE_AMOUNT	NUMBER			Payment amount in the functional currency
INDICATIVE_FLAG	VARCHAR2	(1)		Indicative flag
DEAL_TYPE	VARCHAR2	(7)	Yes	Deal type
RECONCILED_REFERENCE	NUMBER			Reconciled reference

Query Text

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


SELECT REFERENCE_ID
,      BANK_ACCOUNT_ID
,      CASH_ACTIVITY_DATE
,      DEAL_NUMBER
,      BASE_AMOUNT
,      INDICATIVE_FLAG
,      DEAL_TYPE
,      RECONCILED_REFERENCE
FROM APPS.CE_CP_XTO_V;

Dependencies

[top of page]

APPS.CE_CP_XTO_V references the following:

APPS: CE_BANK_ACCTS_GT_V; XTR_DEAL_DATE_AMOUNTS; XTR_PARTY_INFO

APPS.CE_CP_XTO_V is not referenced by any database object