VIEW: APPS.XTR_BIS_NET_POSITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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