[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 |