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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XTR.XTR_RM_MD_CURVES

Object Details

Object Name:	XTR_RM_MD_CURVES
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_RM_MD_CURVES
Subobject Name:
Status:	VALID

XTR_RM_MD_CURVES stores market data curve information that has been defined by a user. Each row corresponds to a unique curve and contains the details of the curve. Each curve contains various market data points (defined in the XTR_MARKET_PRICES table). The relationships between the curves and the market data points are stored in the XTR_RM_MD_CURVE_RATES table.
This table is used by the Market Data Curves and Show Market Data Curves windows.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_RM_MD_CURVES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CURVE_CODE
XTR_RM_MD_CURVES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TYPE CCY AUTHORIZED_YN

Columns

Name	Datatype	Length	Mandatory	Comments
CURVE_CODE	VARCHAR2	(20)	Yes	User-defined unique code for a market data curve
DESCRIPTION	VARCHAR2	(50)		Curve description
TYPE	VARCHAR2	(20)	Yes	Curve type (YIELD, FXVOL , or IRVOL)
CCY	VARCHAR2	(15)	Yes	Currency of the curve
CONTRA_CCY	VARCHAR2	(15)		Second currency of currency pair for curves of type
DATA_SIDE	VARCHAR2	(20)	Yes	Side of market data (BID, ASK, MID, or BID/ASK) to be used
DEFAULT_INTERPOLATION	VARCHAR2	(20)	Yes	Interpolation method (CUBIC, EXPON, LINEAR) that will be used as a default when the curve is selected
AUTHORIZED_YN	VARCHAR2	(1)		Flag to indicate if the curve is enabled (authorized) for usage (Y), or not (N)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Contains descriptive flexfield context value
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CURVE_CODE
,      DESCRIPTION
,      TYPE
,      CCY
,      CONTRA_CCY
,      DATA_SIDE
,      DEFAULT_INTERPOLATION
,      AUTHORIZED_YN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM XTR.XTR_RM_MD_CURVES;

Dependencies

[top of page]

XTR.XTR_RM_MD_CURVES does not reference any database object

XTR.XTR_RM_MD_CURVES is referenced by following:

XTR: XTR_RM_MD_CURVES#