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_CRITERIA

Object Details

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

The XTR_HEDGE_CRITERIA table stores the find criteria used
to select the hedge items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
HEDGE_CRITERIA_ID	NUMBER	(15)	Yes	Hedge Criteria Identifier
HEDGE_ATTRIBUTE_ID	NUMBER	(15)		Hedge Identifier
CRITERIA_TYPE	VARCHAR2	(30)		Indicates whether this row is a BASIC or ADVANCED criteria row.
CRITERIA_CODE	VARCHAR2	(30)		Code idenifying the criteria item like customer or supplier or operating unit etc
OPERATOR	VARCHAR2	(30)		A condition like '=' or '<>'or 'between'
FROM_VALUE	VARCHAR2	(240)		From value of the criteria item.
TO_VALUE	VARCHAR2	(240)		To value of the criteria item.
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
CRITERIA_SET	VARCHAR2	(50)		Used with the CRITERIA_SET_OWNER column to indicate the criteria set for the row's attributes, and to provide the criteria set name.
CRITERIA_SET_OWNER	NUMBER	(15)		Used with CRITERIA_SET column to indicate the criteria set for the row's attributes, and to provide the user ID of the criteria set creator.

Query Text

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


SELECT HEDGE_CRITERIA_ID
,      HEDGE_ATTRIBUTE_ID
,      CRITERIA_TYPE
,      CRITERIA_CODE
,      OPERATOR
,      FROM_VALUE
,      TO_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CRITERIA_SET
,      CRITERIA_SET_OWNER
FROM XTR.XTR_HEDGE_CRITERIA;

Dependencies

[top of page]

XTR.XTR_HEDGE_CRITERIA does not reference any database object

XTR.XTR_HEDGE_CRITERIA is referenced by following:

XTR: XTR_HEDGE_CRITERIA#