[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 |