Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.AS_AT_DATE
, A.COMPANY_CODE
, A.DEAL_TYPE
, A.DEAL_SUBTYPE
, A.CURRENCY
, CONTRA_CCY
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE
, SUM(A.NO_OF_DEALS) NO_OF_DEALS
, SUM(A.GROSS_PRINCIPAL) GROSS_PRINCIPAL
, SUM(A.WEIGHTED_AVG_PRINCIPAL) WEIGHTED_AVG_PRINCIPAL
, SUM(A.HCE_GROSS_PRINCIPAL) HCE_GROSS_AMT
, MIN(A.GROSS_PRINCIPAL) MIN_GROSS
, MAX(A.GROSS_PRINCIPAL) MAX_GROSS
, MIN(A.AVG_INTEREST_RATE) MIN_RATE
, MAX(A.AVG_INTEREST_RATE) MAX_RATE
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE
FROM XTR_COST_OF_FUNDS 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.AS_AT_DATE
, A.COMPANY_CODE
, A.DEAL_TYPE
, A.DEAL_SUBTYPE
, A.CURRENCY
, A.CONTRA_CCY
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE