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_HEDGE_ATTRIBUTES

Object Details

Object Name:	XTR_HEDGE_ATTRIBUTES
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_HEDGE_ATTRIBUTES
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	Mandatory	Comments
HEDGE_ATTRIBUTE_ID	NUMBER	(15)	Yes	Hedge identifier
HEDGE_STATUS	VARCHAR2	(30)	Yes	Code for the execution status of hedges
HEDGE_DESCRIPTION	VARCHAR2	(240)		Description of the hedge
STRATEGY_CODE	VARCHAR2	(30)	Yes	Strategy identifier
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
HEDGE_APPROACH	VARCHAR2	(30)		No Longer Used
START_DATE	DATE			Date on which the hedge starts
END_DATE	DATE			Date on which the hedge ends
DISCONTINUE_DATE	DATE			Date when hedge accounting ends
HEDGE_CURRENCY	VARCHAR2	(15)	Yes	Denotes currency of Hedge Amount
HEDGE_AMOUNT	NUMBER		Yes	Defines the refeference amount of the Hedge
RETRO_TOLERANCE_MIN	NUMBER			Minimum percentage of effectiveness tolerance level for retrospective testing
RETRO_TOLERANCE_MAX	NUMBER			Maximum percentage of effectiveness tolerance level for retrospective testing
RETRO_METHOD	VARCHAR2	(30)
RETRO_DEALER_CODE	VARCHAR2	(10)		User defined measurement methods for retrospective effectiveness testing.
PROS_FREQUENCY_NUM	NUMBER			Frequency of the prospective effectiveness test.
PROS_FREQUENCY_UNIT	VARCHAR2	(1)		The unit associated with the prospective number to denote the test frequency such as Days, Weeks, Months, Quarters and Years.
PROS_TOLERANCE_MIN	NUMBER			Minimum percentage of effectiveness tolerance level
PROS_TOLERANCE_MAX	NUMBER			Maximum percentage of effectiveness tolerance level
PROS_METHOD	VARCHAR2	(30)		User defined measurement methods for prospective effectiveness testing.
PROS_DEALER_CODE	VARCHAR2	(10)		Designated individual responsible for prospective testing.
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
SET_TO_CURRENT_BY	NUMBER	(15)		Indicates who changed the hedge status to CURRENT
SET_TO_CURRENT_DATE	DATE			Indicates when the hedge status was changed to CURRENT
DEDESIGNATED_BY	NUMBER	(15)		Indicates who changed the hedge status to DEDESIGNATED
DEDESIGNATED_DATE	DATE			Indicates when the hedge status was changed to DEDESIGNATED
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
FULFILLED_AMOUNT	NUMBER			Final Fulfilled Amount
REQUEST_ID	NUMBER	(15)		Concurrent Program request id
FIRST_BATCH_ID	NUMBER	(15)		Flag to indicate whether the hedge item was revalued the first time.
LAST_BATCH_ID	NUMBER	(15)		Flag to indicate whether the hedge item is eligible for revaluations in the next batch.
INIT_FAIR_VALUE_RATE	NUMBER	(38)		Initial GL exchange rate or forward rate for the hedge attribute.
EXCLUSION_ITEM_CODE	VARCHAR2	(30)		Displays the risk component of the hedge instruments and determines the amount types used in effectiveness testing.

Query Text

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


SELECT HEDGE_ATTRIBUTE_ID
,      HEDGE_STATUS
,      HEDGE_DESCRIPTION
,      STRATEGY_CODE
,      COMPANY_CODE
,      HEDGE_APPROACH
,      START_DATE
,      END_DATE
,      DISCONTINUE_DATE
,      HEDGE_CURRENCY
,      HEDGE_AMOUNT
,      RETRO_TOLERANCE_MIN
,      RETRO_TOLERANCE_MAX
,      RETRO_METHOD
,      RETRO_DEALER_CODE
,      PROS_FREQUENCY_NUM
,      PROS_FREQUENCY_UNIT
,      PROS_TOLERANCE_MIN
,      PROS_TOLERANCE_MAX
,      PROS_METHOD
,      PROS_DEALER_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SET_TO_CURRENT_BY
,      SET_TO_CURRENT_DATE
,      DEDESIGNATED_BY
,      DEDESIGNATED_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FULFILLED_AMOUNT
,      REQUEST_ID
,      FIRST_BATCH_ID
,      LAST_BATCH_ID
,      INIT_FAIR_VALUE_RATE
,      EXCLUSION_ITEM_CODE
FROM XTR.XTR_HEDGE_ATTRIBUTES;

Dependencies

[top of page]

XTR.XTR_HEDGE_ATTRIBUTES does not reference any database object

XTR.XTR_HEDGE_ATTRIBUTES is referenced by following:

APPS: XTR_HEDGE_ATTRIBUTES