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_FX_PERIOD_WEIGHTINGS

Object Details

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

XTR_FX_PERIOD_WEIGHTINGS contains limit weighting information. Each row corresponds to a limit weighting for a combination of deal type, deal subtype, and the number of months the deal is from maturity before this limit is applied.
This table corresponds to the Weightings window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_FX_PERIOD_WEIGHTINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_TYPE DEAL_SUBTYPE NOS_MONTHS ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
LIMIT_WEIGHTING	NUMBER			Percentage of a deal's face value considered as risk
NOS_MONTHS	NUMBER		Yes	Number of months to maturity date for which the limit weighting applies
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT DEAL_SUBTYPE
,      DEAL_TYPE
,      LIMIT_WEIGHTING
,      NOS_MONTHS
,      ZD_EDITION_NAME
FROM XTR.XTR_FX_PERIOD_WEIGHTINGS;

Dependencies

[top of page]

XTR.XTR_FX_PERIOD_WEIGHTINGS does not reference any database object

XTR.XTR_FX_PERIOD_WEIGHTINGS is referenced by following:

XTR: XTR_FX_PERIOD_WEIGHTINGS#