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.

[Home] [Help]

View: XTR_BIS_NET_POSITIONS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_BIS_NET_POSITIONS_V

View Text

SELECT NE.COMPANY_CODE
, PA.SHORT_NAME
, NE.DEAL_TYPE
, NE.USER_DEAL_TYPE
, NE.CURRENCY
, NE.CONTRA_CCY
, NE.CURRENCY_COMBINATION
, NE.DEAL_SUBTYPE
, NE.USER_DEAL_SUBTYPE
, NE.CPARTY_CODE
, NE.PRODUCT_TYPE
, NE.PORTFOLIO_CODE
, SUM(NE.GROSS_PRINCIPAL)
, SUM(NE.DOMESTIC_CCY_PRIN)
, SUM(NE.WEIGHTED_AVG_PRINCIPAL)
, SUM(NE.NO_OF_DEALS)
, MIN(NE.MIN_GROSS)
, MAX(NE.MAX_GROSS)
, MIN(NE.MIN_RATE)
, MAX(NE.MAX_RATE) FROM XTR_NET_POSITIONS_V NE
, XTR_PARTY_INFO PA WHERE NE.COMPANY_CODE = PA.PARTY_CODE GROUP BY NE.COMPANY_CODE
, PA.SHORT_NAME
, NE.DEAL_TYPE
, NE.USER_DEAL_TYPE
, NE.CURRENCY
, NE.CONTRA_CCY
, NE.CURRENCY_COMBINATION
, NE.DEAL_SUBTYPE
, NE.USER_DEAL_SUBTYPE
, NE.CPARTY_CODE
, NE.PRODUCT_TYPE
, NE.PORTFOLIO_CODE

Columns

Name
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