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_BIS_MIRROR_DDA_LIMIT_ROW_V

Object Details

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

View Type

A Business Intelligence System view

This view contains detailed deal information. It is used when you drill down from the Net Positions inquiry to see the details of the deals that make up the net position information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
USER_DEAL_TYPE	VARCHAR2	(7)	Yes	User-defined deal type code
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
LIMIT_CODE	VARCHAR2	(7)		Code for user-defined limits imposed on deals and transactions
AMOUNT	NUMBER		Yes	Transaction amount
HCE_AMOUNT	NUMBER		Yes	Amount in reporting currency equivalent
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
COMPANY_CODE	VARCHAR2	(7)		Company code
SHORT_NAME	VARCHAR2	(20)	Yes
LIMIT_PARTY	VARCHAR2	(7)
AMOUNT_DATE	DATE
DEALER_CODE	VARCHAR2	(10)
COUNTRY_CODE	VARCHAR2	(2)
TERRITORY_SHORT_NAME	VARCHAR2	(80)
DEAL_SUBTYPE	VARCHAR2	(7)
USER_DEAL_SUBTYPE	VARCHAR2	(7)	Yes
PORTFOLIO_CODE	VARCHAR2	(7)
STATUS_CODE	VARCHAR2	(10)
CURRENCY	VARCHAR2	(15)
UTILISED_AMOUNT	NUMBER
HCE_UTILISED_AMOUNT	NUMBER
CROSS_REF_TO_OTHER_PARTY	VARCHAR2	(7)
LIMIT_TYPE	VARCHAR2	(2)
CURRENCY_COMBINATION	VARCHAR2	(31)
CONTRA_CCY	VARCHAR2	(15)
TRANSACTION_RATE	NUMBER
AMOUNT_INDIC	NUMBER
ACCOUNT_NO	VARCHAR2	(20)

Query Text

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


SELECT DEAL_NUMBER
,      DEAL_TYPE
,      USER_DEAL_TYPE
,      TRANSACTION_NUMBER
,      LIMIT_CODE
,      AMOUNT
,      HCE_AMOUNT
,      PRODUCT_TYPE
,      COMPANY_CODE
,      SHORT_NAME
,      LIMIT_PARTY
,      AMOUNT_DATE
,      DEALER_CODE
,      COUNTRY_CODE
,      TERRITORY_SHORT_NAME
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PORTFOLIO_CODE
,      STATUS_CODE
,      CURRENCY
,      UTILISED_AMOUNT
,      HCE_UTILISED_AMOUNT
,      CROSS_REF_TO_OTHER_PARTY
,      LIMIT_TYPE
,      CURRENCY_COMBINATION
,      CONTRA_CCY
,      TRANSACTION_RATE
,      AMOUNT_INDIC
,      ACCOUNT_NO
FROM APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V;

Dependencies

[top of page]

APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V references the following:

APPS: FND_TERRITORIES_VL; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_MIRROR_DDA_LIMIT_ROW; XTR_PARTIES_V; XTR_USER_ACCESS - show dependent code

APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V is not referenced by any database object