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_XTR_CASHFLOWS_V

Object Details

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

View Type

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

The CE_XTR_CASHFLOWS_V view contains treasury deal transactions for forecasting. The Cash Forecasting program uses this view to generate projected cash inflow and outflow amounts from the trading activities and the exposures. Based on the forecast template definition and forecast submission criteria, the Cash Forecasting program selects only the applicable deals from this view to determine forecast amounts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes	Deal number
DDA_DEAL_TYPE	VARCHAR2	(7)	Yes	Deal type code
DDA_DEAL_SUBTYPE	VARCHAR2	(7)		Deal subtype code
TRANSACTION_RATE	NUMBER			Deal rate
STATUS_CODE	VARCHAR2	(10)		Deal status
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code of deal
TRX_DATE	DATE			Deal transaction date
AMOUNT	NUMBER			Deal amount
COMPANY_CODE	VARCHAR2	(7)		Company
COMPANY_ACCOUNT	VARCHAR2	(20)		Company account number
PRODUCT_TYPE	VARCHAR2	(10)		Product
PORTFOLIO_CODE	VARCHAR2	(7)		Portfolio
CPARTY_CODE	VARCHAR2	(7)		Counter party
CLIENT_CODE	VARCHAR2	(7)		Client
DEAL_TYPE	VARCHAR2	(7)	Yes	Deal type
CATEGORY	VARCHAR2	(2)	Yes	Deal category
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Deal subtype
TYPE_OF_AMOUNT	VARCHAR2	(7)	Yes	Amount type
TRANSACTION_NUMBER	NUMBER			Deal transaction number
DEALER	VARCHAR2	(10)		Dealer
SETTLE	VARCHAR2	(1)		Settlement indicator
CONTRACT_TYPE	VARCHAR2	(7)	Yes	Contract type
SET_OF_BOOKS_ID	NUMBER	(15)		Identifier for set of books
MULTIPLE_SETTLEMENTS	VARCHAR2	(1)		Indicator for multiple settlements
RECONCILED_REFERENCE	NUMBER			Reference number to the statement line against which this transaction is reconciled
DDA_DEAL_TYPE_NAME	VARCHAR2	(80)	Yes	Deal Type Name
DDA_DEAL_SUBTYPE_NAME	VARCHAR2	(80)	Yes	Deal Subtype Name
COUNTERPARTY	VARCHAR2	(50)		Counterparty
AMOUNT_TYPE_NAME	VARCHAR2	(80)	Yes	Amount Type Name
ORG_ID	NUMBER	(15)		Legal Entity identifier
BANK_ACCOUNT_ID	NUMBER	(15)		Bank account identifier
REFERENCE_ID	NUMBER		Yes	Reference identifier

Query Text

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


SELECT DEAL_NUMBER
,      DDA_DEAL_TYPE
,      DDA_DEAL_SUBTYPE
,      TRANSACTION_RATE
,      STATUS_CODE
,      CURRENCY_CODE
,      TRX_DATE
,      AMOUNT
,      COMPANY_CODE
,      COMPANY_ACCOUNT
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      CPARTY_CODE
,      CLIENT_CODE
,      DEAL_TYPE
,      CATEGORY
,      DEAL_SUBTYPE
,      TYPE_OF_AMOUNT
,      TRANSACTION_NUMBER
,      DEALER
,      SETTLE
,      CONTRACT_TYPE
,      SET_OF_BOOKS_ID
,      MULTIPLE_SETTLEMENTS
,      RECONCILED_REFERENCE
,      DDA_DEAL_TYPE_NAME
,      DDA_DEAL_SUBTYPE_NAME
,      COUNTERPARTY
,      AMOUNT_TYPE_NAME
,      ORG_ID
,      BANK_ACCOUNT_ID
,      REFERENCE_ID
FROM APPS.CE_XTR_CASHFLOWS_V;

Dependencies

[top of page]

APPS.CE_XTR_CASHFLOWS_V references the following:

APPS: CE_BANK_ACCTS_GT_V; XTR_AMOUNT_TYPES; XTR_DEAL_DATE_AMOUNTS; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_PARTY_INFO

APPS.CE_XTR_CASHFLOWS_V is referenced by following:

APPS: CE_CP_DISC_OVERDUE_V; CE_CP_DISC_PRIOR_V; CE_CP_DISC_XTI_V; CE_CP_DISC_XTO_V; CE_CP_PRIORDAY - show dependent code; CE_CSH_FCST_POP - show dependent code; CE_FC_XTR_DISC_V