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_NET_POSITIONS_V

Object Details

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

View Type

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

XTR_NET_POSITIONS_V contains view information for your current net positions. Your position is derived from information in the XTR_MIRROR_DDA_LIMIT_ROW table. Each row in XTR_NET_POSITIONS_V corresponds to a net position grouped by company, counterparty, deal type, deal subtype, product type, portfolio, currency and currency combination.
This table corresponds to the Net Transaction Positions window.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY_CODE	VARCHAR2	(7)		Company code
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
USER_DEAL_TYPE	VARCHAR2	(7)	Yes	User-defined deal type code
CURRENCY	VARCHAR2	(15)		Currency code
CONTRA_CCY	VARCHAR2	(15)		Contra currency in a foreign exchange currency quote.
CURRENCY_COMBINATION	VARCHAR2	(31)		Currency quotations which combine a base and a contra currency
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE	VARCHAR2	(7)		User-defined deal subtype code
CPARTY_CODE	VARCHAR2	(7)		Counterparty 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
DEALER_CODE	VARCHAR2	(10)		Dealer code
ACCOUNT_NO	VARCHAR2	(20)		Account number
GROSS_PRINCIPAL	NUMBER			Gross principal amount
DOMESTIC_CCY_PRIN	NUMBER			Gross principal amount in reporting currency equivalent
WEIGHTED_AVG_PRINCIPAL	NUMBER			Average principal of face value amount times transaction rate
QUANTITY	NUMBER			Quantity
NO_OF_DEALS	NUMBER			Number of deals (or transactions for short term money deals)of the net
MIN_GROSS	NUMBER			Minimum amount
MAX_GROSS	NUMBER			Maximum amount
MIN_RATE	NUMBER			Minimum transaction rate
MAX_RATE	NUMBER			Maximum transaction rate

Query Text

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


SELECT COMPANY_CODE
,      DEAL_TYPE
,      USER_DEAL_TYPE
,      CURRENCY
,      CONTRA_CCY
,      CURRENCY_COMBINATION
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      CPARTY_CODE
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      DEALER_CODE
,      ACCOUNT_NO
,      GROSS_PRINCIPAL
,      DOMESTIC_CCY_PRIN
,      WEIGHTED_AVG_PRINCIPAL
,      QUANTITY
,      NO_OF_DEALS
,      MIN_GROSS
,      MAX_GROSS
,      MIN_RATE
,      MAX_RATE
FROM APPS.XTR_NET_POSITIONS_V;

Dependencies

[top of page]

APPS.XTR_NET_POSITIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_DEALS_V; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_MIRROR_DDA_LIMIT_ROW_V; XTR_USER_ACCESS - show dependent code

APPS.XTR_NET_POSITIONS_V is referenced by following:

APPS: XTR_BIS_NET_POSITIONS_V; XTR_DISC_NET_POSITIONS_V