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_NET_POSITIONS_V

Object Details

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

View Type

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

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPANY	VARCHAR2	(7)		Company code
COMPANY_NAME	VARCHAR2	(50)	Yes	Refer to base table.
SYS_DEAL_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
DEAL_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
DEAL_TYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
CURR	VARCHAR2	(15)		Refer to base table.
CONTRA_CURR	VARCHAR2	(15)		Refer to base table.
CURR_COMBINATION	VARCHAR2	(31)		Refer to base table.
SYS_DEAL_SUBTYPE	VARCHAR2	(7)		Refer to base table.
DEAL_SUBTYPE	VARCHAR2	(7)		Refer to base table.
DEAL_SUBTYPE_NAME	VARCHAR2	(80)		Refer to base table.
CPARTY	VARCHAR2	(7)		Refer to base table.
CPARTY_NAME	VARCHAR2	(50)		Refer to base table.
PRODUCT_TYPE	VARCHAR2	(10)		Refer to base table.
PRODUCT_TYPE_DESC	VARCHAR2	(80)		Product description
PORTFOLIO	VARCHAR2	(7)		Refer to base table.
GROSS_AMOUNT	NUMBER			Refer to base table.
REPORTING_CURR_AMOUNT	NUMBER			Refer to base table.
WEIGHTED_AMOUNT	NUMBER			Refer to base table.
NO_OF_DEALS	NUMBER			Refer to base table.
MIN_GROSS	NUMBER			Refer to base table.
MAX_GROSS	NUMBER			Refer to base table.
MIN_RATE	NUMBER			Refer to base table.
MAX_RATE	NUMBER			Refer to base table.

Query Text

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


SELECT COMPANY
,      COMPANY_NAME
,      SYS_DEAL_TYPE
,      DEAL_TYPE
,      DEAL_TYPE_NAME
,      CURR
,      CONTRA_CURR
,      CURR_COMBINATION
,      SYS_DEAL_SUBTYPE
,      DEAL_SUBTYPE
,      DEAL_SUBTYPE_NAME
,      CPARTY
,      CPARTY_NAME
,      PRODUCT_TYPE
,      PRODUCT_TYPE_DESC
,      PORTFOLIO
,      GROSS_AMOUNT
,      REPORTING_CURR_AMOUNT
,      WEIGHTED_AMOUNT
,      NO_OF_DEALS
,      MIN_GROSS
,      MAX_GROSS
,      MIN_RATE
,      MAX_RATE
FROM APPS.XTR_DISC_NET_POSITIONS_V;

Dependencies

[top of page]

APPS.XTR_DISC_NET_POSITIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_NET_POSITIONS_V; XTR_PARTY_INFO; XTR_PRODUCT_TYPES; XTR_USER_ACCESS - show dependent code

APPS.XTR_DISC_NET_POSITIONS_V is not referenced by any database object