[Home] [Help]
View: XTR_RM_MD_CRVRATES_V
Product: | XTR - Treasury |
Description: | All market data points (and their attributes) that help compose market data curves |
Implementation/DBA Data: |
APPS.XTR_RM_MD_CRVRATES_V
|
View Text
SELECT CR.ROWID
, CR.CURVE_CODE
, CR.RATE_CODE
, MP.PRICE_DESCRIPTION
, MP.TERM_LENGTH
, LKP.MEANING
, MP.CURRENCY_A
, MP.CURRENCY_B
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
FROM XTR_RM_MD_CURVE_RATES CR
, XTR_MARKET_PRICES MP
, FND_LOOKUP_VALUES_VL LKP
WHERE CR.RATE_CODE = MP.RIC_CODE AND LKP.LOOKUP_TYPE='XTR_TERM_TYPES' AND MP.TERM_TYPE=LKP.LOOKUP_CODE
Columns
Name |
ROW_ID |
CURVE_CODE |
RATE_CODE |
DESCRIPTION |
PERIOD |
TERM_TYPE |
CURRENCY |
CONTRA |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |