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_INTEREST_RATE_EXPOSURE

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
COMPANY_CODE	VARCHAR2	(7)	Company identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	VARCHAR2	(10)	User who created this record.
CREATED_ON	DATE		Date on which this record is created.
CURRENCY	VARCHAR2	(15)
DEAL_NUMBER	NUMBER		Deal identifier. Foreign key to XTR_DEALS.
DEAL_SUBTYPE	VARCHAR2	(7)	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	VARCHAR2	(7)	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
FIXED_OR_FLOAT	VARCHAR2	(5)
FROM_DATE	DATE
FUND_INVEST	VARCHAR2	(6)
GROSS_AMOUNT	NUMBER
MATURITY_DATE	DATE
NO_OF_DAYS	NUMBER
PORTFOLIO_CODE	VARCHAR2	(7)
REF_NUMBER	NUMBER
START_DATE	DATE
SYN_FLAG	VARCHAR2	(1)
SYN_PHY	VARCHAR2	(7)
TO_DATE	DATE
TRANSACTION_NUMBER	NUMBER
TRANSACTION_RATE	NUMBER

Query Text

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


SELECT COMPANY_CODE
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DEAL_NUMBER
,      DEAL_SUBTYPE
,      DEAL_TYPE
,      FIXED_OR_FLOAT
,      FROM_DATE
,      FUND_INVEST
,      GROSS_AMOUNT
,      MATURITY_DATE
,      NO_OF_DAYS
,      PORTFOLIO_CODE
,      REF_NUMBER
,      START_DATE
,      SYN_FLAG
,      SYN_PHY
,      TO_DATE
,      TRANSACTION_NUMBER
,      TRANSACTION_RATE
FROM XTR.XTR_INTEREST_RATE_EXPOSURE;

Dependencies

[top of page]

XTR.XTR_INTEREST_RATE_EXPOSURE does not reference any database object

XTR.XTR_INTEREST_RATE_EXPOSURE is referenced by following:

XTR: XTR_INTEREST_RATE_EXPOSURE#