DBA Data[Home] [Help]

VIEW: APPS.XTR_RM_MD_SHOW_CURVES_V

Source

View Text - Preformatted

SELECT xrmcr.CURVE_CODE, xipr.UNIQUE_PERIOD_ID, xipr.PERIOD_CODE, xipr.TERM_TYPE, xipr.CURRENCY, xipr.DAY_COUNT_BASIS, xipr.BID_RATE, xipr.OFFER_RATE, xipr.RATE_DATE FROM XTR_INTEREST_PERIOD_RATES xipr, XTR_RM_MD_CURVE_RATES xrmcr WHERE xipr.UNIQUE_PERIOD_ID = xrmcr.RATE_CODE
View Text - HTML Formatted

SELECT XRMCR.CURVE_CODE
, XIPR.UNIQUE_PERIOD_ID
, XIPR.PERIOD_CODE
, XIPR.TERM_TYPE
, XIPR.CURRENCY
, XIPR.DAY_COUNT_BASIS
, XIPR.BID_RATE
, XIPR.OFFER_RATE
, XIPR.RATE_DATE
FROM XTR_INTEREST_PERIOD_RATES XIPR
, XTR_RM_MD_CURVE_RATES XRMCR
WHERE XIPR.UNIQUE_PERIOD_ID = XRMCR.RATE_CODE