VIEW: APPS.XTR_DISC_NET_POSITIONS_V

Source

View Text - Preformatted

SELECT ne.COMPANY_CODE, pa.FULL_NAME, ne.DEAL_TYPE, ne.USER_DEAL_TYPE, dt.NAME, ne.CURRENCY, ne.CONTRA_CCY, ne.CURRENCY_COMBINATION, ne.DEAL_SUBTYPE, ne.USER_DEAL_SUBTYPE, st.NAME, ne.CPARTY_CODE, a.FULL_NAME, ne.PRODUCT_TYPE, p.product_desc, 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, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st, XTR_PRODUCT_TYPES P, XTR_PARTY_INFO A WHERE DT.DEAL_TYPE = ne.DEAL_TYPE AND (ST.DEAL_TYPE(+) = ne.DEAL_TYPE and ST.DEAL_SUBTYPE(+) = ne.DEAL_SUBTYPE) AND (P.DEAL_TYPE(+) = ne.DEAL_TYPE and P.PRODUCT_TYPE(+) = ne.PRODUCT_TYPE) AND ne.CPARTY_CODE = a.PARTY_CODE(+) AND ne.COMPANY_CODE = pa.PARTY_CODE group by ne.COMPANY_CODE, pa.FULL_NAME, ne.DEAL_TYPE, ne.USER_DEAL_TYPE, dt.NAME, ne.CURRENCY, ne.CONTRA_CCY, ne.CURRENCY_COMBINATION, ne.DEAL_SUBTYPE, ne.USER_DEAL_SUBTYPE, st.NAME, ne.CPARTY_CODE, a.FULL_NAME, ne.PRODUCT_TYPE, p.PRODUCT_DESC, ne.PORTFOLIO_CODE

View Text - HTML Formatted

SELECT NE.COMPANY_CODE
, PA.FULL_NAME
, NE.DEAL_TYPE
, NE.USER_DEAL_TYPE
, DT.NAME
, NE.CURRENCY
, NE.CONTRA_CCY
, NE.CURRENCY_COMBINATION
, NE.DEAL_SUBTYPE
, NE.USER_DEAL_SUBTYPE
, ST.NAME
, NE.CPARTY_CODE
, A.FULL_NAME
, NE.PRODUCT_TYPE
, P.PRODUCT_DESC
, 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
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_PRODUCT_TYPES P
, XTR_PARTY_INFO A
WHERE DT.DEAL_TYPE = NE.DEAL_TYPE
AND (ST.DEAL_TYPE(+) = NE.DEAL_TYPE
AND ST.DEAL_SUBTYPE(+) = NE.DEAL_SUBTYPE)
AND (P.DEAL_TYPE(+) = NE.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = NE.PRODUCT_TYPE)
AND NE.CPARTY_CODE = A.PARTY_CODE(+)
AND NE.COMPANY_CODE = PA.PARTY_CODE GROUP BY NE.COMPANY_CODE
, PA.FULL_NAME
, NE.DEAL_TYPE
, NE.USER_DEAL_TYPE
, DT.NAME
, NE.CURRENCY
, NE.CONTRA_CCY
, NE.CURRENCY_COMBINATION
, NE.DEAL_SUBTYPE
, NE.USER_DEAL_SUBTYPE
, ST.NAME
, NE.CPARTY_CODE
, A.FULL_NAME
, NE.PRODUCT_TYPE
, P.PRODUCT_DESC
, NE.PORTFOLIO_CODE