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: ViewCE.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:

SchemaAPPS
ViewCE_BANK_ACCTS_GT_V
SynonymXTR_DEAL_DATE_AMOUNTS
SynonymXTR_PARTY_INFO

APPS.CE_CP_XTO_V is not referenced by any database object