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_SUMMARY_NET_POSITIONS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.CURRENCY
, A.CONTRA_CCY
, SUM(A.NO_OF_DEALS) NOS
, SUM(A.GROSS_PRINCIPAL) GROSS_AMT
, SUM(A.WEIGHTED_AVG_PRINCIPAL) WEIGHTED_AMT
, SUM(A.DOMESTIC_CCY_PRIN) HCE_GROSS_AMT
, MIN(A.GROSS_PRINCIPAL) MIN_GROSS
, MAX(A.GROSS_PRINCIPAL) MAX_GROSS
, MIN(A.MIN_RATE) MIN_RATE
, MAX(A.MAX_RATE) MAX_RATE FROM XTR_NET_POSITIONS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) GROUP BY A.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.CURRENCY
, A.CONTRA_CCY

Columns

Name
COMPANY_CODE
DEAL_TYPE
USER_DEAL_TYPE
DEAL_SUBTYPE
USER_DEAL_SUBTYPE
CURRENCY
CONTRA_CCY
NOS
GROSS_AMT
WEIGHTED_AMT
HCE_GROSS_AMT
MIN_GROSS
MAX_GROSS
MIN_RATE
MAX_RATE