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_GROUP_ATTRIBUTES

Object Details

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

This table provides the method of associating individual attributes defined in FTE_SEL_ATTRIBUTES for a specific object to a group also assigned to the object. Attributes and groups must be associated with the same object in order to be able to be assigned together.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SEL_GROUP_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID
FTE_SEL_GROUP_ATTRIBUTES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ATTRIBUTE_ID	NUMBER		Yes	Primary key of the table
ATTRIBUTE_ID	NUMBER		Yes	Identifier of the attribute defined for the group Foreign Key to FTE_SEL_ATTRIBUTES
ATTRIBUTE_DEFAULT_VALUE	VARCHAR2	(240)		Default value for the group attribute
ATTRIBUTE_UOM_CODE	VARCHAR2	(10)		Unit of measure of the group attribute, e.g. Lbs, KG, FT3, Days, etc...
GROUP_ID	NUMBER		Yes	Group identifier that the attribute is assigned to
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
ATTRIBUTE_NAME	VARCHAR2	(30)	Yes	name of the attribute, denormalized

Query Text

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


SELECT GROUP_ATTRIBUTE_ID
,      ATTRIBUTE_ID
,      ATTRIBUTE_DEFAULT_VALUE
,      ATTRIBUTE_UOM_CODE
,      GROUP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_NAME
FROM FTE.FTE_SEL_GROUP_ATTRIBUTES;

Dependencies

[top of page]

FTE.FTE_SEL_GROUP_ATTRIBUTES does not reference any database object

FTE.FTE_SEL_GROUP_ATTRIBUTES is referenced by following:

FTE: FTE_SEL_GROUP_ATTRIBUTES#