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: TableXTR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_RECLASS_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECLASS_DETAILS_ID
XTR_RECLASS_DETAILS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEDGE_ATTRIBUTE_ID
ColumnRECLASS_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:

SchemaAPPS
SynonymXTR_RECLASS_DETAILS