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: FTE.FTE_SEL_RULE_RESTRICTIONS

Object Details

Object Name:	FTE_SEL_RULE_RESTRICTIONS
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_SEL_RULE_RESTRICTIONS
Subobject Name:
Status:	VALID

This table holds the arrtibutes that make up a rule. Attributes are grouped by rule_id. It is this table that is queried by the code in order to find a result (defined in FTE_SEL_RESULTS). Rule restriction may be of numeric or character types and may be singular in value or a range of values. numeric ranges have a low (from) definition of greater than or equal to and a high (to) definition of less than. charater ranges have a low (from) definition of equal to and a high (to) definition of equal to. For character and numeric single values the data is in the low (from) column with the high (to) column value left as null. Whether an attribute is a single or a range is defined in the FTE_SEL_ATTRIBUTES table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SEL_RULE_RESTRICTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_NAME GROUP_ID ATTRIBUTE_VALUE_FROM_NUMBER ATTRIBUTE_VALUE_TO_NUMBER
FTE_SEL_RULE_RESTRICTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_NAME GROUP_ID ATTRIBUTE_VALUE_FROM ATTRIBUTE_VALUE_TO
FTE_SEL_RULE_RESTRICTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_ID
FTE_SEL_RULE_RESTRICTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ATTRIBUTE_ID	NUMBER		Yes	Primary Key to identify rule attribute
RULE_ID	NUMBER		Yes	Rule that the rule attribute is associated with. Foreign Key to FTE_SEL_RULES
ATTRIBUTE_NAME	VARCHAR2	(30)	Yes	Name of the rule attribute
ATTRIBUTE_VALUE_FROM	VARCHAR2	(240)		Character From value of attribute
ATTRIBUTE_VALUE_TO	VARCHAR2	(240)		Character To value of attribute
ATTRIBUTE_VALUE_FROM_NUMBER	NUMBER			Number From value of attribute
ATTRIBUTE_VALUE_TO_NUMBER	NUMBER			Number To value of attribute
DATA_TYPE	VARCHAR2	(1)		Data type of attribute - �C� - character, �N� - number
GROUPING_NUMBER	NUMBER			Stores number of attributes in the group (denormalized)
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
GROUP_ID	NUMBER			denormalized group identifier that the rule attributes are associated to from fte_sel_rules
RANGE_OVERLAP_FLAG	VARCHAR2	(1)		Used for range attribute. Indicates if overlap is allowed. N- No

Query Text

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


SELECT RULE_ATTRIBUTE_ID
,      RULE_ID
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE_FROM
,      ATTRIBUTE_VALUE_TO
,      ATTRIBUTE_VALUE_FROM_NUMBER
,      ATTRIBUTE_VALUE_TO_NUMBER
,      DATA_TYPE
,      GROUPING_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GROUP_ID
,      RANGE_OVERLAP_FLAG
FROM FTE.FTE_SEL_RULE_RESTRICTIONS;

Dependencies

[top of page]

FTE.FTE_SEL_RULE_RESTRICTIONS does not reference any database object

FTE.FTE_SEL_RULE_RESTRICTIONS is referenced by following:

FTE: FTE_SEL_RULE_RESTRICTIONS#