eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QRM_DISC_ANALYSIS_V

Source

View Text - Preformatted


SELECT da.analysis_name, V.CALL_OR_PUT, V.OPTION_STYLE, V.COMPANY_CODE, V.DEALER_CODE, V.CLIENT_CODE, V.CPARTY_CODE, V.PORTFOLIO_CODE, V.LINK_CODE, V.PRICING_MODEL, V.BUY_CCY, V.SELL_CCY, V.FOREIGN_CCY, V.DOMESTIC_CCY, V.BASE_CCY, V.CONTRA_CCY, V.BUY_AMOUNT, V.SELL_AMOUNT, V.FOREIGN_AMOUNT, V.DOMESTIC_AMOUNT, V.BASE_CCY_AMOUNT, V.CONTRA_CCY_AMOUNT, V.DEAL_DATE, V.END_DATE, ST.USER_DEAL_SUBTYPE, DT.USER_DEAL_TYPE, V.EXPIRATION_DATE, V.MATURITY_DATE, V.MARKET_TYPE, V.INSTR_TYPE, V.MM_FX_INSTR_TYPE, V.VALUE_DATE, V.PREMIUM_AMOUNT, V.PRODUCT_TYPE, V.START_DATE, V.KNOCK_EXECUTE_DATE, V.KNOCK_TYPE, V.KNOCK_LEVEL, V.INT_SWAP_REF, V.INT_REF, V.BOND_ISSUE_CODE, V.SECURITY_ID, V.REF_SPOT_RATE, V.MARGIN, V.COUPON_FREQUENCY, V.DAY_COUNT_BASIS, DC.DEAL_NO, DECODE(DC.TRANSACTION_NO,-4,NULL,DC.TRANSACTION_NO), DC.MARKET_DATA_SET, DC.DEAL_CCY, DC.SOB_CCY, DC.BASE_CCY_AMOUNT_USD, DC.BASE_CCY_AMOUNT_SOB, DC.CONTRA_CCY_AMOUNT_USD, DC.CONTRA_CCY_AMOUNT_SOB, DC.FOREIGN_AMOUNT_USD, DC.FOREIGN_AMOUNT_SOB, DC.DOMESTIC_AMOUNT_USD, DC.DOMESTIC_AMOUNT_SOB, DC.BUY_AMOUNT_USD, DC.BUY_AMOUNT_SOB, DC.SELL_AMOUNT_USD, DC.SELL_AMOUNT_SOB, DC.DAYS, DC.FX_REVAL_RATE, DC.MM_REVAL_RATE, DC.FX_TRANS_RATE, DC.MM_TRANS_RATE, DC.FAIR_VALUE, DC.FAIR_VALUE_USD, DC.FAIR_VALUE_SOB, DC.GAP_AMOUNT, DC.GAP_AMOUNT_USD, DC.GAP_AMOUNT_SOB, DC.MATURITY_AMOUNT, DC.MATURITY_AMOUNT_USD, DC.MATURITY_AMOUNT_SOB, DC.PREMIUM_AMOUNT_USD, DC.PREMIUM_AMOUNT_SOB, DC.ACCRUED_INTEREST, DC.ACCRUED_INTEREST_USD, DC.ACCRUED_INTEREST_SOB, DC.DURATION, DC.MODIFIED_DURATION, DC.CONVEXITY, DC.DELTA, DC.GAMMA, DC.THETA, DC.RHO_FOREIGN, DC.RHO_DOMESTIC, DC.VEGA, DC.POS_BPV, DC.POS_DELTA, DC.POS_GAMMA, DC.POS_RHO_FOREIGN, DC.POS_RHO_DOMESTIC, DC.POS_VEGA, DC.VOLATILITY, DC.GAP_DATE, DC.RHO, DC.RHO_BASE, DC.RHO_CONTRA, DC.POS_RHO, DC.POS_RHO_USD, DC.POS_RHO_SOB, DC.POS_RHO_BASE, DC.POS_RHO_BASE_USD, DC.POS_RHO_BASE_SOB, DC.POS_RHO_CONTRA, DC.POS_RHO_CONTRA_USD, DC.POS_RHO_CONTRA_SOB, DC.POS_RHO_FOREIGN_USD, DC.POS_RHO_FOREIGN_SOB, DC.POS_RHO_DOMESTIC_USD, DC.POS_RHO_DOMESTIC_SOB, DC.POS_BPV_USD, DC.POS_BPV_SOB, DC.POS_DELTA_USD, DC.POS_DELTA_SOB, DC.POS_GAMMA_USD, DC.POS_GAMMA_SOB, DC.POS_VEGA_USD, DC.POS_VEGA_SOB, DC.POS_THETA, DC.POS_THETA_USD, DC.POS_THETA_SOB, DC.YIELD_TO_MATURITY, T.INTEREST_BASIS, T.OUTSTANDING_AMOUNT, T.COUPON_RATE, T.NEXT_COUPON_DATE, T.OUTSTANDING_AMOUNT_SOB, T.OUTSTANDING_AMOUNT_USD, pia.FULL_NAME, pib.FULL_NAME, st.NAME, dt.NAME, p.PRODUCT_DESC FROM QRM_CURRENT_DEALS_V V, QRM_DEAL_CALCULATIONS DC, XTR_DEAL_SUBTYPES ST, XTR_DEAL_TYPES DT, QRM_TB_CALCULATIONS T , QRM_DEALS_ANALYSES da, XTR_PRODUCT_TYPES P, XTR_PARTY_INFO pia, XTR_PARTY_INFO pib WHERE DT.DEAL_TYPE = v.DEAL_TYPE AND (ST.DEAL_TYPE = v.DEAL_TYPE and ST.DEAL_SUBTYPE = v.DEAL_SUBTYPE) AND (P.DEAL_TYPE(+) = v.DEAL_TYPE and P.PRODUCT_TYPE(+) = v.PRODUCT_TYPE) AND v.COMPANY_CODE = pia.PARTY_CODE AND v.CPARTY_CODE = pib.PARTY_CODE(+) AND DC.DEAL_NO = V.DEAL_NO AND V.DEAL_NO = T.DEAL_NO AND V.TRANSACTION_NO = T.TRANSACTION_NO AND DC.MARKET_DATA_SET = T.MARKET_DATA_SET AND t.end_date = (select min(end_date) from qrm_tb_calculations b where b.deal_no = t.deal_no and b.transaction_no = t.transaction_no and b.market_data_set = t.market_data_set group by b.deal_no, b.transaction_no, b.market_data_set) AND DC.TRANSACTION_NO = V.TRANSACTION_NO AND (ST.DEAL_SUBTYPE = V.DEAL_SUBTYPE AND ST.DEAL_TYPE=V.DEAL_TYPE) AND DT.DEAL_TYPE = V.DEAL_TYPE AND da.deal_calc_id=dc.deal_calc_id

View Text - HTML Formatted

SELECT DA.ANALYSIS_NAME
, V.CALL_OR_PUT
, V.OPTION_STYLE
, V.COMPANY_CODE
, V.DEALER_CODE
, V.CLIENT_CODE
, V.CPARTY_CODE
, V.PORTFOLIO_CODE
, V.LINK_CODE
, V.PRICING_MODEL
, V.BUY_CCY
, V.SELL_CCY
, V.FOREIGN_CCY
, V.DOMESTIC_CCY
, V.BASE_CCY
, V.CONTRA_CCY
, V.BUY_AMOUNT
, V.SELL_AMOUNT
, V.FOREIGN_AMOUNT
, V.DOMESTIC_AMOUNT
, V.BASE_CCY_AMOUNT
, V.CONTRA_CCY_AMOUNT
, V.DEAL_DATE
, V.END_DATE
, ST.USER_DEAL_SUBTYPE
, DT.USER_DEAL_TYPE
, V.EXPIRATION_DATE
, V.MATURITY_DATE
, V.MARKET_TYPE
, V.INSTR_TYPE
, V.MM_FX_INSTR_TYPE
, V.VALUE_DATE
, V.PREMIUM_AMOUNT
, V.PRODUCT_TYPE
, V.START_DATE
, V.KNOCK_EXECUTE_DATE
, V.KNOCK_TYPE
, V.KNOCK_LEVEL
, V.INT_SWAP_REF
, V.INT_REF
, V.BOND_ISSUE_CODE
, V.SECURITY_ID
, V.REF_SPOT_RATE
, V.MARGIN
, V.COUPON_FREQUENCY
, V.DAY_COUNT_BASIS
, DC.DEAL_NO
, DECODE(DC.TRANSACTION_NO
, -4
, NULL
, DC.TRANSACTION_NO)
, DC.MARKET_DATA_SET
, DC.DEAL_CCY
, DC.SOB_CCY
, DC.BASE_CCY_AMOUNT_USD
, DC.BASE_CCY_AMOUNT_SOB
, DC.CONTRA_CCY_AMOUNT_USD
, DC.CONTRA_CCY_AMOUNT_SOB
, DC.FOREIGN_AMOUNT_USD
, DC.FOREIGN_AMOUNT_SOB
, DC.DOMESTIC_AMOUNT_USD
, DC.DOMESTIC_AMOUNT_SOB
, DC.BUY_AMOUNT_USD
, DC.BUY_AMOUNT_SOB
, DC.SELL_AMOUNT_USD
, DC.SELL_AMOUNT_SOB
, DC.DAYS
, DC.FX_REVAL_RATE
, DC.MM_REVAL_RATE
, DC.FX_TRANS_RATE
, DC.MM_TRANS_RATE
, DC.FAIR_VALUE
, DC.FAIR_VALUE_USD
, DC.FAIR_VALUE_SOB
, DC.GAP_AMOUNT
, DC.GAP_AMOUNT_USD
, DC.GAP_AMOUNT_SOB
, DC.MATURITY_AMOUNT
, DC.MATURITY_AMOUNT_USD
, DC.MATURITY_AMOUNT_SOB
, DC.PREMIUM_AMOUNT_USD
, DC.PREMIUM_AMOUNT_SOB
, DC.ACCRUED_INTEREST
, DC.ACCRUED_INTEREST_USD
, DC.ACCRUED_INTEREST_SOB
, DC.DURATION
, DC.MODIFIED_DURATION
, DC.CONVEXITY
, DC.DELTA
, DC.GAMMA
, DC.THETA
, DC.RHO_FOREIGN
, DC.RHO_DOMESTIC
, DC.VEGA
, DC.POS_BPV
, DC.POS_DELTA
, DC.POS_GAMMA
, DC.POS_RHO_FOREIGN
, DC.POS_RHO_DOMESTIC
, DC.POS_VEGA
, DC.VOLATILITY
, DC.GAP_DATE
, DC.RHO
, DC.RHO_BASE
, DC.RHO_CONTRA
, DC.POS_RHO
, DC.POS_RHO_USD
, DC.POS_RHO_SOB
, DC.POS_RHO_BASE
, DC.POS_RHO_BASE_USD
, DC.POS_RHO_BASE_SOB
, DC.POS_RHO_CONTRA
, DC.POS_RHO_CONTRA_USD
, DC.POS_RHO_CONTRA_SOB
, DC.POS_RHO_FOREIGN_USD
, DC.POS_RHO_FOREIGN_SOB
, DC.POS_RHO_DOMESTIC_USD
, DC.POS_RHO_DOMESTIC_SOB
, DC.POS_BPV_USD
, DC.POS_BPV_SOB
, DC.POS_DELTA_USD
, DC.POS_DELTA_SOB
, DC.POS_GAMMA_USD
, DC.POS_GAMMA_SOB
, DC.POS_VEGA_USD
, DC.POS_VEGA_SOB
, DC.POS_THETA
, DC.POS_THETA_USD
, DC.POS_THETA_SOB
, DC.YIELD_TO_MATURITY
, T.INTEREST_BASIS
, T.OUTSTANDING_AMOUNT
, T.COUPON_RATE
, T.NEXT_COUPON_DATE
, T.OUTSTANDING_AMOUNT_SOB
, T.OUTSTANDING_AMOUNT_USD
, PIA.FULL_NAME
, PIB.FULL_NAME
, ST.NAME
, DT.NAME
, P.PRODUCT_DESC
FROM QRM_CURRENT_DEALS_V V
, QRM_DEAL_CALCULATIONS DC
, XTR_DEAL_SUBTYPES ST
, XTR_DEAL_TYPES DT
, QRM_TB_CALCULATIONS T
, QRM_DEALS_ANALYSES DA
, XTR_PRODUCT_TYPES P
, XTR_PARTY_INFO PIA
, XTR_PARTY_INFO PIB
WHERE DT.DEAL_TYPE = V.DEAL_TYPE
AND (ST.DEAL_TYPE = V.DEAL_TYPE
AND ST.DEAL_SUBTYPE = V.DEAL_SUBTYPE)
AND (P.DEAL_TYPE(+) = V.DEAL_TYPE
AND P.PRODUCT_TYPE(+) = V.PRODUCT_TYPE)
AND V.COMPANY_CODE = PIA.PARTY_CODE
AND V.CPARTY_CODE = PIB.PARTY_CODE(+)
AND DC.DEAL_NO = V.DEAL_NO
AND V.DEAL_NO = T.DEAL_NO
AND V.TRANSACTION_NO = T.TRANSACTION_NO
AND DC.MARKET_DATA_SET = T.MARKET_DATA_SET
AND T.END_DATE = (SELECT MIN(END_DATE)
FROM QRM_TB_CALCULATIONS B
WHERE B.DEAL_NO = T.DEAL_NO
AND B.TRANSACTION_NO = T.TRANSACTION_NO
AND B.MARKET_DATA_SET = T.MARKET_DATA_SET GROUP BY B.DEAL_NO
, B.TRANSACTION_NO
, B.MARKET_DATA_SET)
AND DC.TRANSACTION_NO = V.TRANSACTION_NO
AND (ST.DEAL_SUBTYPE = V.DEAL_SUBTYPE
AND ST.DEAL_TYPE=V.DEAL_TYPE)
AND DT.DEAL_TYPE = V.DEAL_TYPE
AND DA.DEAL_CALC_ID=DC.DEAL_CALC_ID