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_MILE_COLUMN_ATTRIBUTES

Object Details

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

This table is used to store the attribute data used for the relevant columns in the download/upload file.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_MILE_COLUMN_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLUMN_ID
FTE_MILE_COLUMN_ATTRIBUTES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COLUMN_ATTRIBUTE_ID	NUMBER		Yes	Primary Key for the table - System Generated
COLUMN_ID	NUMBER		Yes	Foreign Key to FTE_MILE_TEMPLATE_COLUMNS - identifies the column the attribute is assigned to
ATTRIBUTE_ID	NUMBER			Foreign key to FTE_MILE_ATTRIBUTES. Identifier for the attribute
CODE	VARCHAR2	(30)		Code of the attribute
ATTRIBUTE_DELIMITER	VARCHAR2	(1)		Delimiter used after the attribute. E.g. a delimiter of ',' (comma) would give a layout like ,. This is only used for two or more attributes in a column
SPACE_PADDING	NUMBER			not used
RETURN_FORMAT	VARCHAR2	(10)		Format code for the returniong attributes. E.g. the transit time may be returned in Hours:Minutes format, the distance may be returned in miles or kilometers
DB_UOM	VARCHAR2	(3)		The Unit of Measure in which to store the return attributes in the database.
ENABLED_FLAG	VARCHAR2	(1)		Indicates if the attribute has been selected for use or not
SEQUENCE_ID	NUMBER			Indicates the position of the attribute in the column
LENGTH	NUMBER			The length of the attribute in the column
DB_LENGTH	NUMBER			The length of the attributes' associated database column
CREATION_DATE	DATE		Yes	Standard who columns
CREATED_BY	NUMBER		Yes	Standard who columns
LAST_UPDATE_DATE	DATE		Yes	Standard who columns
LAST_UPDATED_BY	NUMBER		Yes	Standard who columns
LAST_UPDATE_LOGIN	NUMBER			Standard who columns
PROGRAM_APPLICATION_ID	NUMBER			Standard who columns
PROGRAM_ID	NUMBER			Standard who columns
PROGRAM_UPDATE_DATE	DATE			Standard who columns
REQUEST_ID	NUMBER			Standard who columns

Query Text

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


SELECT COLUMN_ATTRIBUTE_ID
,      COLUMN_ID
,      ATTRIBUTE_ID
,      CODE
,      ATTRIBUTE_DELIMITER
,      SPACE_PADDING
,      RETURN_FORMAT
,      DB_UOM
,      ENABLED_FLAG
,      SEQUENCE_ID
,      LENGTH
,      DB_LENGTH
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM FTE.FTE_MILE_COLUMN_ATTRIBUTES;

Dependencies

[top of page]

FTE.FTE_MILE_COLUMN_ATTRIBUTES does not reference any database object

FTE.FTE_MILE_COLUMN_ATTRIBUTES is referenced by following:

FTE: FTE_MILE_COLUMN_ATTRIBUTES#