VIEW: QRM.QRM_DEAL_CALCULATIONS#

Source

View Text - Preformatted

select DEAL_CALC_ID DEAL_CALC_ID, DEAL_NO DEAL_NO, TRANSACTION_NO TRANSACTION_NO, MARKET_DATA_SET MARKET_DATA_SET, DEAL_CCY DEAL_CCY, SOB_CCY SOB_CCY, BASE_CCY_AMOUNT_USD BASE_CCY_AMOUNT_USD, BASE_CCY_AMOUNT_SOB BASE_CCY_AMOUNT_SOB, CONTRA_CCY_AMOUNT_USD CONTRA_CCY_AMOUNT_USD, CONTRA_CCY_AMOUNT_SOB CONTRA_CCY_AMOUNT_SOB, FOREIGN_AMOUNT_USD FOREIGN_AMOUNT_USD, FOREIGN_AMOUNT_SOB FOREIGN_AMOUNT_SOB, DOMESTIC_AMOUNT_USD DOMESTIC_AMOUNT_USD, DOMESTIC_AMOUNT_SOB DOMESTIC_AMOUNT_SOB, BUY_AMOUNT_USD BUY_AMOUNT_USD, BUY_AMOUNT_SOB BUY_AMOUNT_SOB, SELL_AMOUNT_USD SELL_AMOUNT_USD, SELL_AMOUNT_SOB SELL_AMOUNT_SOB, DAYS DAYS, FX_REVAL_RATE FX_REVAL_RATE, MM_REVAL_RATE MM_REVAL_RATE, FX_TRANS_RATE FX_TRANS_RATE, MM_TRANS_RATE MM_TRANS_RATE, FAIR_VALUE FAIR_VALUE, FAIR_VALUE_USD FAIR_VALUE_USD, FAIR_VALUE_SOB FAIR_VALUE_SOB, GAP_AMOUNT GAP_AMOUNT, GAP_AMOUNT_USD GAP_AMOUNT_USD, GAP_AMOUNT_SOB GAP_AMOUNT_SOB, MATURITY_AMOUNT MATURITY_AMOUNT, MATURITY_AMOUNT_USD MATURITY_AMOUNT_USD, MATURITY_AMOUNT_SOB MATURITY_AMOUNT_SOB, PREMIUM_AMOUNT_USD PREMIUM_AMOUNT_USD, PREMIUM_AMOUNT_SOB PREMIUM_AMOUNT_SOB, ACCRUED_INTEREST ACCRUED_INTEREST, ACCRUED_INTEREST_USD ACCRUED_INTEREST_USD, ACCRUED_INTEREST_SOB ACCRUED_INTEREST_SOB, DURATION DURATION, MODIFIED_DURATION MODIFIED_DURATION, CONVEXITY CONVEXITY, DELTA DELTA, GAMMA GAMMA, THETA THETA, RHO_FOREIGN RHO_FOREIGN, RHO_DOMESTIC RHO_DOMESTIC, VEGA VEGA, POS_BPV POS_BPV, POS_DELTA POS_DELTA, POS_GAMMA POS_GAMMA, POS_RHO_FOREIGN POS_RHO_FOREIGN, POS_RHO_DOMESTIC POS_RHO_DOMESTIC, POS_VEGA POS_VEGA, VOLATILITY VOLATILITY, GAP_DATE GAP_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RHO RHO, RHO_BASE RHO_BASE, RHO_CONTRA RHO_CONTRA, POS_RHO POS_RHO, POS_RHO_USD POS_RHO_USD, POS_RHO_SOB POS_RHO_SOB, POS_RHO_BASE POS_RHO_BASE, POS_RHO_BASE_USD POS_RHO_BASE_USD, POS_RHO_BASE_SOB POS_RHO_BASE_SOB, POS_RHO_CONTRA POS_RHO_CONTRA, POS_RHO_CONTRA_USD POS_RHO_CONTRA_USD, POS_RHO_CONTRA_SOB POS_RHO_CONTRA_SOB, POS_RHO_FOREIGN_USD POS_RHO_FOREIGN_USD, POS_RHO_FOREIGN_SOB POS_RHO_FOREIGN_SOB, POS_RHO_DOMESTIC_USD POS_RHO_DOMESTIC_USD, POS_RHO_DOMESTIC_SOB POS_RHO_DOMESTIC_SOB, POS_BPV_USD POS_BPV_USD, POS_BPV_SOB POS_BPV_SOB, POS_DELTA_USD POS_DELTA_USD, POS_DELTA_SOB POS_DELTA_SOB, POS_GAMMA_USD POS_GAMMA_USD, POS_GAMMA_SOB POS_GAMMA_SOB, POS_THETA POS_THETA, POS_THETA_USD POS_THETA_USD, POS_THETA_SOB POS_THETA_SOB, POS_VEGA_USD POS_VEGA_USD, POS_VEGA_SOB POS_VEGA_SOB, YIELD_TO_MATURITY YIELD_TO_MATURITY, LAST_MD_CALC_DATE LAST_MD_CALC_DATE, TRANSACTION_PRICE TRANSACTION_PRICE, TRANSACTION_PRICE_USD TRANSACTION_PRICE_USD, TRANSACTION_PRICE_SOB TRANSACTION_PRICE_SOB, REVALUATION_PRICE REVALUATION_PRICE, REVALUATION_PRICE_USD REVALUATION_PRICE_USD, REVALUATION_PRICE_SOB REVALUATION_PRICE_SOB from "QRM"."QRM_DEAL_CALCULATIONS"

View Text - HTML Formatted

SELECT DEAL_CALC_ID DEAL_CALC_ID
, DEAL_NO DEAL_NO
, TRANSACTION_NO TRANSACTION_NO
, MARKET_DATA_SET MARKET_DATA_SET
, DEAL_CCY DEAL_CCY
, SOB_CCY SOB_CCY
, BASE_CCY_AMOUNT_USD BASE_CCY_AMOUNT_USD
, BASE_CCY_AMOUNT_SOB BASE_CCY_AMOUNT_SOB
, CONTRA_CCY_AMOUNT_USD CONTRA_CCY_AMOUNT_USD
, CONTRA_CCY_AMOUNT_SOB CONTRA_CCY_AMOUNT_SOB
, FOREIGN_AMOUNT_USD FOREIGN_AMOUNT_USD
, FOREIGN_AMOUNT_SOB FOREIGN_AMOUNT_SOB
, DOMESTIC_AMOUNT_USD DOMESTIC_AMOUNT_USD
, DOMESTIC_AMOUNT_SOB DOMESTIC_AMOUNT_SOB
, BUY_AMOUNT_USD BUY_AMOUNT_USD
, BUY_AMOUNT_SOB BUY_AMOUNT_SOB
, SELL_AMOUNT_USD SELL_AMOUNT_USD
, SELL_AMOUNT_SOB SELL_AMOUNT_SOB
, DAYS DAYS
, FX_REVAL_RATE FX_REVAL_RATE
, MM_REVAL_RATE MM_REVAL_RATE
, FX_TRANS_RATE FX_TRANS_RATE
, MM_TRANS_RATE MM_TRANS_RATE
, FAIR_VALUE FAIR_VALUE
, FAIR_VALUE_USD FAIR_VALUE_USD
, FAIR_VALUE_SOB FAIR_VALUE_SOB
, GAP_AMOUNT GAP_AMOUNT
, GAP_AMOUNT_USD GAP_AMOUNT_USD
, GAP_AMOUNT_SOB GAP_AMOUNT_SOB
, MATURITY_AMOUNT MATURITY_AMOUNT
, MATURITY_AMOUNT_USD MATURITY_AMOUNT_USD
, MATURITY_AMOUNT_SOB MATURITY_AMOUNT_SOB
, PREMIUM_AMOUNT_USD PREMIUM_AMOUNT_USD
, PREMIUM_AMOUNT_SOB PREMIUM_AMOUNT_SOB
, ACCRUED_INTEREST ACCRUED_INTEREST
, ACCRUED_INTEREST_USD ACCRUED_INTEREST_USD
, ACCRUED_INTEREST_SOB ACCRUED_INTEREST_SOB
, DURATION DURATION
, MODIFIED_DURATION MODIFIED_DURATION
, CONVEXITY CONVEXITY
, DELTA DELTA
, GAMMA GAMMA
, THETA THETA
, RHO_FOREIGN RHO_FOREIGN
, RHO_DOMESTIC RHO_DOMESTIC
, VEGA VEGA
, POS_BPV POS_BPV
, POS_DELTA POS_DELTA
, POS_GAMMA POS_GAMMA
, POS_RHO_FOREIGN POS_RHO_FOREIGN
, POS_RHO_DOMESTIC POS_RHO_DOMESTIC
, POS_VEGA POS_VEGA
, VOLATILITY VOLATILITY
, GAP_DATE GAP_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RHO RHO
, RHO_BASE RHO_BASE
, RHO_CONTRA RHO_CONTRA
, POS_RHO POS_RHO
, POS_RHO_USD POS_RHO_USD
, POS_RHO_SOB POS_RHO_SOB
, POS_RHO_BASE POS_RHO_BASE
, POS_RHO_BASE_USD POS_RHO_BASE_USD
, POS_RHO_BASE_SOB POS_RHO_BASE_SOB
, POS_RHO_CONTRA POS_RHO_CONTRA
, POS_RHO_CONTRA_USD POS_RHO_CONTRA_USD
, POS_RHO_CONTRA_SOB POS_RHO_CONTRA_SOB
, POS_RHO_FOREIGN_USD POS_RHO_FOREIGN_USD
, POS_RHO_FOREIGN_SOB POS_RHO_FOREIGN_SOB
, POS_RHO_DOMESTIC_USD POS_RHO_DOMESTIC_USD
, POS_RHO_DOMESTIC_SOB POS_RHO_DOMESTIC_SOB
, POS_BPV_USD POS_BPV_USD
, POS_BPV_SOB POS_BPV_SOB
, POS_DELTA_USD POS_DELTA_USD
, POS_DELTA_SOB POS_DELTA_SOB
, POS_GAMMA_USD POS_GAMMA_USD
, POS_GAMMA_SOB POS_GAMMA_SOB
, POS_THETA POS_THETA
, POS_THETA_USD POS_THETA_USD
, POS_THETA_SOB POS_THETA_SOB
, POS_VEGA_USD POS_VEGA_USD
, POS_VEGA_SOB POS_VEGA_SOB
, YIELD_TO_MATURITY YIELD_TO_MATURITY
, LAST_MD_CALC_DATE LAST_MD_CALC_DATE
, TRANSACTION_PRICE TRANSACTION_PRICE
, TRANSACTION_PRICE_USD TRANSACTION_PRICE_USD
, TRANSACTION_PRICE_SOB TRANSACTION_PRICE_SOB
, REVALUATION_PRICE REVALUATION_PRICE
, REVALUATION_PRICE_USD REVALUATION_PRICE_USD
, REVALUATION_PRICE_SOB REVALUATION_PRICE_SOB
FROM "QRM"."QRM_DEAL_CALCULATIONS"