[Home] [Help] [Dependency Information]
Object Name: | FTE_SEL_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_SEL_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
This table holds all attribute definitions. Each attribute is linked to an object defined in FTE_SEL_OBJECTS, E.g. an object could be 'Carrier_selection', and by linking attributes to that object the attributes become available for use by that object.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_SEL_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
CODE
OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Yes | primary key for the table | |
CODE | VARCHAR2 | (30) | Yes | code of the attribute |
NAME | VARCHAR2 | (240) | name of the attribute | |
OBJECT_ID | NUMBER | Yes | foreign key to FTE_SEL_OBJECTS.OBJECT_ID | |
DATA_TYPE | VARCHAR2 | (1) | Yes | data type of the attribute, e.g. 'N'umber, 'C'haracter |
RANGE_FLAG | VARCHAR2 | (1) | Yes | Indicates if the attribute can be used for a range of values |
SELECTION_TYPE | VARCHAR2 | (1) | Yes | Indicates if the attribute is for 'I'nput, 'O'utput or 'B'oth |
VISIBLE_FLAG | VARCHAR2 | (1) | Indicates if the attribute is visible to the user | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if the attribute is enabled or not | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_ID
, CODE
, NAME
, OBJECT_ID
, DATA_TYPE
, RANGE_FLAG
, SELECTION_TYPE
, VISIBLE_FLAG
, ENABLED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FTE.FTE_SEL_ATTRIBUTES;
FTE.FTE_SEL_ATTRIBUTES does not reference any database object
FTE.FTE_SEL_ATTRIBUTES is referenced by following:
|
|
|