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_DISC_CASHFLOWS_V

Object Details

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

View Type

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

The XTR_DISC_CASHFLOWS _V view is used for the Discoverer report and is based on the XTR_CASHFLOWS_V view. User access to company information is enforced in the XTR_DISC_CASHFLOWS _V view. Please refer to the full description of XTR_CASHFLOWS_V for more details.

[View Source]

Columns

Name	Datatype	Length	Comments
DEAL_NUMBER	NUMBER		Unique number assigned to each deal
DDA_DEAL_TYPE	VARCHAR2	(7)	Refer to base table.
DDA_DEAL_SUBTYPE	VARCHAR2	(7)	Refer to base table.
TRANSACTION_RATE	NUMBER		Refer to base table.
STATUS_CODE	VARCHAR2	(10)	Refer to base table.
CURRENCY_CODE	VARCHAR2	(15)	Refer to base table.
TRX_DATE	DATE		Refer to base table.
AMOUNT	NUMBER		Refer to base table.
COMPANY_CODE	VARCHAR2	(7)	Refer to base table.
COMPANY_ACCOUNT	VARCHAR2	(20)	Refer to base table.
BANK_CODE	VARCHAR2	(7)	Refer to base table.
PRODUCT_TYPE	VARCHAR2	(10)	Refer to base table.
PORTFOLIO_CODE	VARCHAR2	(7)	Refer to base table.
CPARTY_CODE	VARCHAR2	(7)	Refer to base table.
CLIENT_CODE	VARCHAR2	(7)	Refer to base table.
DEAL_TYPE	VARCHAR2	(7)	Refer to base table.
CATEGORY	VARCHAR2	(2)	Refer to base table.
DEAL_SUBTYPE	VARCHAR2	(7)	Refer to base table.
TYPE_OF_AMOUNT	VARCHAR2	(240)	Refer to base table.
AMOUNT_TYPE	VARCHAR2	(7)	Refer to base table.
TRANSACTION_NUMBER	NUMBER		Refer to base table.
DEALER	VARCHAR2	(10)	Refer to base table.
SETTLE	VARCHAR2	(1)	Refer to base table.
CONTRACT_TYPE	VARCHAR2	(7)	Refer to base table.
MULTIPLE_SETTLEMENTS	VARCHAR2	(1)	Refer to base table.
DEAL_TYPE_NAME	VARCHAR2	(80)	Refer to base table.
DEAL_SUBTYPE_NAME	VARCHAR2	(80)	Refer to base table.
COMPANY_FULL_NAME	VARCHAR2	(50)	Refer to base table.
CPARTY_FULL_NAME	VARCHAR2	(50)	Refer to base table.
BANK_NAME	VARCHAR2	(50)	Refer to base table.
AMOUNT_TYPE_NAME	VARCHAR2	(80)	Refer to base table.

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
,      DEAL_TYPE_NAME
,      DEAL_SUBTYPE_NAME
,      COMPANY_FULL_NAME
,      CPARTY_FULL_NAME
,      BANK_NAME
,      AMOUNT_TYPE_NAME
FROM APPS.XTR_DISC_CASHFLOWS_V;

Dependencies

[top of page]

APPS.XTR_DISC_CASHFLOWS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_AMOUNT_TYPES; XTR_BANK_ACCOUNTS; XTR_COMPANY_AUTHORITIES; XTR_DEALER_CODES; XTR_DEAL_DATE_AMOUNTS; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_EXTERNAL_CASHFLOWS; XTR_PARTY_INFO

APPS.XTR_DISC_CASHFLOWS_V is not referenced by any database object