View: XTR_NET_POSITIONS_V

Product:	XTR - Treasury
Description:	Current net position information
Implementation/DBA Data:	APPS.XTR_NET_POSITIONS_V

View Text

SELECT A.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.CURRENCY
, A.CONTRA_CCY
, A.CURRENCY_COMBINATION
, DECODE(A.DEAL_TYPE
, 'FX'
, '%'
, A.DEAL_SUBTYPE) DEAL_SUBTYPE
, DECODE(A.DEAL_TYPE
, 'FX'
, '%'
, ST.USER_DEAL_SUBTYPE) USER_DEAL_SUBTYPE
, A.LIMIT_PARTY CPARTY_CODE
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE
, NVL(A.DEALER_CODE
, '%') DEALER_CODE
, DECODE(A.DEAL_TYPE
, 'CA'
, A.ACCOUNT_NO
, '%') ACCOUNT_NO
, SUM(NVL(A.AMOUNT_INDIC
, 1)*NVL(A.AMOUNT
, 0)) GROSS_PRINCIPAL
, SUM(NVL(A.AMOUNT_INDIC
, 1)*NVL(A.HCE_AMOUNT
, 0)) DOMESTIC_CCY_PRIN
, SUM(NVL(A.AMOUNT_INDIC
, 1)*NVL(A.AMOUNT
, 0)*NVL(A.TRANSACTION_RATE
, 0)/ (DECODE(A.DEAL_TYPE
, 'FX'
, 1
, 'FXO'
, 1
, 100))) WEIGHTED_AVG_PRINCIPAL
, COUNT(DISTINCT DECODE(A.DEAL_TYPE
, 'ONC'
, A.TRANSACTION_NUMBER
, A.DEAL_NUMBER)) NO_OF_DEALS
, MIN(A.AMOUNT) MIN_GROSS
, MAX(A.AMOUNT) MAX_GROSS
, MIN(A.TRANSACTION_RATE) MIN_RATE
, MAX(A.TRANSACTION_RATE) MAX_RATE
FROM XTR_MIRROR_DDA_LIMIT_ROW_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE (A.AMOUNT_DATE>=TRUNC(SYSDATE) OR A.DEAL_TYPE= 'ONC' OR A.DEAL_TYPE='CMF' OR A.DEAL_TYPE='CA' OR A.DEAL_TYPE='IG' OR A.DEAL_TYPE = 'STOCK')
AND A.DEAL_TYPE <> 'EXP'
AND 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.CURRENCY
, A.CONTRA_CCY
, A.CURRENCY_COMBINATION
, DECODE(A.DEAL_TYPE
, 'FX'
, '%'
, A.DEAL_SUBTYPE)
, DECODE(A.DEAL_TYPE
, 'FX'
, '%'
, ST.USER_DEAL_SUBTYPE)
, A.LIMIT_PARTY
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE
, NVL(A.DEALER_CODE
, '%')
, DECODE(A.DEAL_TYPE
, 'CA'
, A.ACCOUNT_NO
, '%')

Columns