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_RECLASS_DETAILS

Object Details

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

The XTR_RECLASS_DETAILS table contains details relating to the timing of the reclassification of effective unrealized gain/loss amounts from the deferral amounts..

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_RECLASS_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECLASS_DETAILS_ID
XTR_RECLASS_DETAILS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEDGE_ATTRIBUTE_ID RECLASS_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
RECLASS_DETAILS_ID	NUMBER	(15)	Yes	Reclassification detail identifier
HEDGE_ATTRIBUTE_ID	NUMBER	(15)	Yes	Hedge attribute identifier
REFERENCE_TXT	VARCHAR2	(30)		Free text field
RECLASS_HEDGE_AMT	NUMBER		Yes	Reference amount that the reclassified gain/loss amount is calculated on.
RECLASS_DATE	DATE		Yes	Date of the reclassification.
RECLASS_GAIN_LOSS_AMT	NUMBER			Reclassified gain or loss amount.
COMMENTS	VARCHAR2	(240)		Comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns
PROGRAM_ID	NUMBER	(15)		Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER	(15)		Identifies the Oracle Applications Concurrent Program Login ID.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Identifies the Oracle Application that produced the concurrent program.
REQUEST_ID	NUMBER	(15)		Identifies the concurrent request instance that produced the concurrent program.
RECLASS_BALANCE_AMT	NUMBER			Reclassification outstanding balance of the hedge.
LAST_REVAL_BATCH_ID	NUMBER	(15)		Flag to indicate whether the reclassified amount has been included in the revaluations process.
RETRO_BATCH_ID	NUMBER	(15)		Flag to indicate whether the reclassified amount has been included in the retrospective test process.

Query Text

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


SELECT RECLASS_DETAILS_ID
,      HEDGE_ATTRIBUTE_ID
,      REFERENCE_TXT
,      RECLASS_HEDGE_AMT
,      RECLASS_DATE
,      RECLASS_GAIN_LOSS_AMT
,      COMMENTS
,      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
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      RECLASS_BALANCE_AMT
,      LAST_REVAL_BATCH_ID
,      RETRO_BATCH_ID
FROM XTR.XTR_RECLASS_DETAILS;

Dependencies

[top of page]

XTR.XTR_RECLASS_DETAILS does not reference any database object

XTR.XTR_RECLASS_DETAILS is referenced by following:

XTR: XTR_RECLASS_DETAILS#