VIEW: APPS.QRM_DISC_ANALYSIS_TB_V

Source

View Text - Preformatted

SELECT da.ANALYSIS_NAME, c.START_DATE TB_START_DATE, c.END_DATE TB_END_DATE, v.DEAL_NO, v.TRANSACTION_NO, v.MARKET_DATA_SET, v.CALL_OR_PUT, v.OPTION_STYLE, v.ISSUER_CODE, v.COMPANY_CODE, v.DEALER_CODE, v.CLIENT_CODE, v.CPARTY_CODE, v.PORTFOLIO_CODE, v.LINK_CODE, v.PRICING_MODEL, v.DEAL_CCY, v.BUY_CCY, v.SELL_CCY, v.FOREIGN_CCY, v.DOMESTIC_CCY, v.BASE_CCY, v.CONTRA_CCY, v.SENSITIVITY_CCY, v.PREMIUM_CCY, v.BUY_AMOUNT, v.SELL_AMOUNT, v.FOREIGN_AMOUNT, v.DOMESTIC_AMOUNT, v.BASE_CCY_AMOUNT, v.CONTRA_CCY_AMOUNT, v.START_AMOUNT, v.FACE_VALUE, v.INTEREST, v.ACCUM_INTEREST_BF, v.ACCUM_INT_ACTION, v.ACCRUED_INTEREST ACCRUED_INTEREST_PRICE, v.INTEREST_SETTLED, v.DEAL_DATE, v.END_DATE, st.USER_DEAL_SUBTYPE, dt.USER_DEAL_TYPE, v.DISCOUNT_YIELD, v.EXPIRATION_DATE, v.MATURITY_DATE, v.NO_OF_DAYS, v.MARKET_TYPE, v.INSTR_TYPE, v.MM_FX_INSTR_TYPE, v.VALUE_DATE, v.SETTLE_DATE, v.PREMIUM_AMOUNT, v.PRODUCT_TYPE, v.START_DATE, v.PHY_START_DATE, v.KNOCK_TYPE, v.KNOCK_LEVEL, v.KNOCK_EXECUTE_DATE, v.INITIAL_BASIS, v.INT_SWAP_REF, v.INT_REF, v.BOND_ISSUE_CODE, v.SECURITY_ID, v.REF_SPOT_RATE, v.COUPON_ACTION, v.MARGIN, v.TRANSACTION_RATE, v.INTEREST_FREQUENCY, v.COUPON_FREQUENCY, v.DAY_COUNT_BASIS, v.QUANTITY_REMAINING, v.QUANTITY_REMAINING_USD, v.QUANTITY_REMAINING_SOB, v.ROUNDING_TYPE, v.DAY_COUNT_TYPE, v.PREPAID_INTEREST, 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_THETA, dc.POS_THETA_USD, dc.POS_THETA_SOB, dc.POS_VEGA_USD, dc.POS_VEGA_SOB, dc.YIELD_TO_MATURITY, dc.LAST_MD_CALC_DATE, dc.TRANSACTION_PRICE, dc.TRANSACTION_PRICE_USD, dc.TRANSACTION_PRICE_SOB, dc.REVALUATION_PRICE, dc.REVALUATION_PRICE_USD, dc.REVALUATION_PRICE_SOB, tb.INTEREST_BASIS, tb.OUTSTANDING_AMOUNT, tb.OUTSTANDING_AMOUNT_USD, tb.OUTSTANDING_AMOUNT_SOB, tb.COUPON_RATE, tb.NEXT_COUPON_DATE, tb.AMT_QTY_OUT, tb.AMT_QTY_OUT_USD, tb.AMT_QTY_OUT_SOB, pi1.FULL_NAME COMPANY_NAME, pi2.FULL_NAME CPARTY_NAME, st.NAME DEAL_SUBTYPE_NAME, dt.NAME DEAL_TYPE_NAME, p.PRODUCT_DESC PRODUCT_TYPE_DESC FROM qrm_deal_calculations dc, qrm_deals_analyses da, qrm_current_deals_v v, qrm_saved_analyses_col c, qrm_tb_calculations tb, xtr_deal_types dt, xtr_deal_subtypes st, xtr_product_types p, xtr_party_info pi1, xtr_party_info pi2 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 = pi1.PARTY_CODE AND v.CPARTY_CODE = pi2.PARTY_CODE(+) AND da.deal_calc_id=dc.deal_calc_id AND dc.deal_no=v.deal_no AND dc.transaction_no=v.transaction_no AND c.analysis_name=da.analysis_name AND v.deal_date<=c.end_date AND (v.end_date IS NULL OR c.end_date<=v.end_date) AND dc.deal_no=tb.deal_no AND dc.transaction_no=tb.transaction_no AND (c.end_date>=tb.pos_start_date OR tb.pos_start_date IS NULL) AND (tb.pos_end_date IS NULL OR c.end_date