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.

[Home] [Help]

View: XTR_RM_MD_SHOW_CURVES_V

Product:	XTR - Treasury
Description:	Historic rate information for those rates that belong to a market data curve
Implementation/DBA Data:	APPS.XTR_RM_MD_SHOW_CURVES_V

View Text

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

Columns

Name
CURVE_CODE
UNIQUE_PERIOD_ID
PERIOD_CODE
TERM_TYPE
CURRENCY
DAY_COUNT_BASIS
BID_RATE
OFFER_RATE
RATE_DATE