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

Object Details

Object Name:	XTR_CASHFLOWS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_CASHFLOWS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DDA_DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
DDA_DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
TRANSACTION_RATE	NUMBER			Transaction rate
STATUS_CODE	VARCHAR2	(10)		Code for the execution status of deals and transactions
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
TRX_DATE	DATE			Date of the cash flow
AMOUNT	NUMBER			Amount of cash flow
COMPANY_CODE	VARCHAR2	(7)		Company code
COMPANY_ACCOUNT	VARCHAR2	(20)		Settlement account number
BANK_CODE	VARCHAR2	(7)		Stores bank code
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
CLIENT_CODE	VARCHAR2	(7)		Client for which the deal is made
DEAL_TYPE	VARCHAR2	(7)	Yes	User-defined deal type code
CATEGORY	VARCHAR2	(2)	Yes	Flag indicates if the deal type is Foreign Exchange (FX), Money Market (MM) or Exposures (EXP)
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	User-defined deal subtype code
TYPE_OF_AMOUNT	VARCHAR2	(7)	Yes	Code that identifies the purpose of the amounts for a deal type
AMOUNT_TYPE	VARCHAR2	(7)	Yes	User-defined amount type code
TRANSACTION_NUMBER	NUMBER			Unique reference number assigned to a transaction
DEALER	VARCHAR2	(10)		Code for Treasury users
SETTLE	VARCHAR2	(1)		Flag to indicate if the settlement has been authorized (Y), or not (N)
CONTRACT_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
MULTIPLE_SETTLEMENTS	VARCHAR2	(1)		Flag to indicate if the settlement is split into more than one company or one bank account (Y), or not (N)

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
,      BANK_CODE
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      CPARTY_CODE
,      CLIENT_CODE
,      DEAL_TYPE
,      CATEGORY
,      DEAL_SUBTYPE
,      TYPE_OF_AMOUNT
,      AMOUNT_TYPE
,      TRANSACTION_NUMBER
,      DEALER
,      SETTLE
,      CONTRACT_TYPE
,      MULTIPLE_SETTLEMENTS
FROM APPS.XTR_CASHFLOWS_V;

Dependencies

[top of page]

APPS.XTR_CASHFLOWS_V references the following:

APPS: XTR_AMOUNT_TYPES; XTR_BANK_ACCOUNTS; XTR_DEAL_DATE_AMOUNTS; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES

APPS.XTR_CASHFLOWS_V is referenced by following:

APPS: XTR_BIS_CASHFLOWS_V; XTR_FX_EXPOSURES_VIEW_V