[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_BIS_NET_POSITIONS_V

Object Details

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

View Type

A Business Intelligence System view

This view shows current net positions grouped by company, counterparty, deal type, deal subtype, product type, portfolio, currency, contra currency and currency combination.

[View Source]

Columns

Query Text

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

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

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

XTR_NET_POSITIONS_V

XTR_PARTY_INFO

XTR_USER_ACCESS - show dependent code

APPS.XTR_BIS_NET_POSITIONS_V is not referenced by any database object