Product: | XTR - Treasury |
---|---|
Description: | Net Position Information, where user access to company information is enforced. |
Implementation/DBA Data: | APPS.XTR_DISC_NET_POSITIONS_V |
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