[Home] [Help] [Dependency Information]
Object Name: | XTR_HEDGE_RELATIONSHIPS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_HEDGE_RELATIONSHIPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEDGE_RELATIONSHIP_ID | NUMBER | (15) | Yes | Hedge relationship identifier |
HEDGE_ATTRIBUTE_ID | NUMBER | (15) | Yes | Hedge identifier |
SOURCE_TYPE_ID | NUMBER | (15) | Yes | Source type identifier |
PRIMARY_CODE | VARCHAR2 | (30) | Indicates the identifier of the item or instrument | |
SECONDARY_CODE | VARCHAR2 | (30) | Indicates additional identification for the item or instrument | |
INSTRUMENT_ITEM_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the source is a hedge instrument or hedge item. |
PCT_ALLOCATION | NUMBER | Indicates the % of the instrument assigned to the hedge | ||
REFERENCE_AMOUNT | NUMBER | Indicates the reference amount assigned to the hedge | ||
COMMENTS | VARCHAR2 | (240) | Comments | |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
AMOUNT | NUMBER | Original amount of the item or instrument | ||
CUR_PCT_ALLOCATION | NUMBER | Displays the current percentage of the deal assigned to the hedge | ||
CUR_REFERENCE_AMT | NUMBER | Displays the current reference amount of the deal assigned to the hedge. |
Cut, paste (and edit) the following text to query this object:
SELECT HEDGE_RELATIONSHIP_ID
, HEDGE_ATTRIBUTE_ID
, SOURCE_TYPE_ID
, PRIMARY_CODE
, SECONDARY_CODE
, INSTRUMENT_ITEM_FLAG
, PCT_ALLOCATION
, REFERENCE_AMOUNT
, COMMENTS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AMOUNT
, CUR_PCT_ALLOCATION
, CUR_REFERENCE_AMT
FROM XTR.XTR_HEDGE_RELATIONSHIPS;
XTR.XTR_HEDGE_RELATIONSHIPS does not reference any database object
XTR.XTR_HEDGE_RELATIONSHIPS is referenced by following:
|
|
|