DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_HEDGE_STRATEGIES

Object Details
Object Name: XTR_HEDGE_STRATEGIES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_HEDGE_STRATEGIES
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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
STRATEGY_CODE VARCHAR2 (30) Yes Hedge strategy identifier
STRATEGY_NAME VARCHAR2 (80) Yes Hedge strategy name
DESCRIPTION VARCHAR2 (240)
Description of the hedge strategy
AUTHORIZED VARCHAR2 (1)
Flag to indicate if the strategy is authorized fo ruse (Y) or not (N).
COMPANY_CODE VARCHAR2 (7)
Company code
RISK_TYPE VARCHAR2 (30) Yes Nature of the risk being hedged
OBJECTIVE_CODE VARCHAR2 (30) Yes Code indicating the objective for holding or issuing hedge instruments
HEDGE_GUIDELINE NUMBER

Hedge % guideline
POLICY_REFERENCE VARCHAR2 (2000)
Refers to your risk management policy or includes a description of transactions or items for which risks are hedged.
DERIVATIVE_DISCLOSURE VARCHAR2 (2000)
Indicates the purpose why the company is dealing in derivatives.
EXPIRY_DATE DATE

Date on which the strategy expires and becomes unavailable for hedging.
HEDGE_TYPE VARCHAR2 (30) Yes Indicates the type of the Hedge i.e cashflow, fairvalue, or non-qualifying.
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_TOLERANCE_CODE_U_FLAG VARCHAR2 (1)
No Longer Used
RETRO_METHOD VARCHAR2 (30)
User defined measurement methods for retrospective effectiveness testing.
RETRO_METHOD_U_FLAG VARCHAR2 (1)
Indicate if the default value of retrospective method can be overridden (Y) or not (N) while defining hedge attributes
RETRO_DEALER_CODE VARCHAR2 (10)
Designated individual responsible for retrospective testing.
RETRO_DEALER_CODE_U_FLAG VARCHAR2 (1)
No Longer Used
PROS_TOLERANCE_MIN NUMBER

Minimum percentage of effectiveness tolerance level for prospective testing
PROS_TOLERANCE_MAX NUMBER

Maximum percentage of effectiveness tolerance level for prospective testing
PROS_TOLERANCE_CODE_U_FLAG VARCHAR2 (1)
No Longer Used
PROS_METHOD VARCHAR2 (30)
User defined measurement methods for prospective effectiveness testing.
PROS_METHOD_U_FLAG VARCHAR2 (1)
Indicates if the default value of prospective method can be overridden (Y) or not (N) while defining hedge attributes
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_FREQUENCY_U_FLAG VARCHAR2 (1)
No Longer Used
PROS_DEALER_CODE VARCHAR2 (10)
Designated individual responsible for prospective testing.
PROS_DEALER_CODE_U_FLAG VARCHAR2 (1)
No Longer Used
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
EXCLUSION_ITEM_CODE VARCHAR2 (30)
Displays the risk component of the hedge instruments and determines the amount types used in effectiveness testing.
AUTO_REC_INIT_PROS_TEST_FLAG VARCHAR2 (1)
Indicates if the initial prospective test for a hedge will be created automatically (Y) or not (N) when the hedge status is changed from DESIGNATE to CURRENT.
HEDGE_APPROACH VARCHAR2 (30)
Indicates the hedge approach.
Query Text

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


SELECT STRATEGY_CODE
,      STRATEGY_NAME
,      DESCRIPTION
,      AUTHORIZED
,      COMPANY_CODE
,      RISK_TYPE
,      OBJECTIVE_CODE
,      HEDGE_GUIDELINE
,      POLICY_REFERENCE
,      DERIVATIVE_DISCLOSURE
,      EXPIRY_DATE
,      HEDGE_TYPE
,      RETRO_TOLERANCE_MIN
,      RETRO_TOLERANCE_MAX
,      RETRO_TOLERANCE_CODE_U_FLAG
,      RETRO_METHOD
,      RETRO_METHOD_U_FLAG
,      RETRO_DEALER_CODE
,      RETRO_DEALER_CODE_U_FLAG
,      PROS_TOLERANCE_MIN
,      PROS_TOLERANCE_MAX
,      PROS_TOLERANCE_CODE_U_FLAG
,      PROS_METHOD
,      PROS_METHOD_U_FLAG
,      PROS_FREQUENCY_NUM
,      PROS_FREQUENCY_UNIT
,      PROS_FREQUENCY_U_FLAG
,      PROS_DEALER_CODE
,      PROS_DEALER_CODE_U_FLAG
,      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
,      EXCLUSION_ITEM_CODE
,      AUTO_REC_INIT_PROS_TEST_FLAG
,      HEDGE_APPROACH
FROM XTR.XTR_HEDGE_STRATEGIES;

Dependencies

[top of page]

XTR.XTR_HEDGE_STRATEGIES does not reference any database object

XTR.XTR_HEDGE_STRATEGIES is referenced by following:

SchemaXTR
ViewXTR_HEDGE_STRATEGIES#