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_DOWNLOAD_FILES

Object Details

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

This table is used to store the information of the file created for download. When uploading a file, this table will be checked to ensure that the file is valid and then to get the formatting data from the related template that was used to create the file so that the file can be parsed correctly. This table is also used to check when deleting or updating a template that may be currently in use for download or upload.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_MILE_DOWNLOAD_FILES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FILE_NAME
FTE_MILE_DOWNLOAD_FILES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DOWNLOAD_FILE_ID	NUMBER		Yes	Primary Key for the table - Syatem Generated
FILE_NAME	VARCHAR2	(8)	Yes	Unique name for the upload/download file. The file name is of the format: DLF<5_digit_generated_number> E.g. DLF00012
DOWNLOAD_FILE_EXTENSION	VARCHAR2	(3)	Yes	User defined extension for the download file. If none given the default provided by the system is '.in'
TEMPLATE_ID	NUMBER		Yes	Foreign Key to FTE_MILE_TEMPLATES - identifies the template that was used to create the file
UPLOAD_ID	NUMBER			Batch Id for the upload process - populated after upload is successful
DOWNLOAD_DATE	DATE			Timestamp when the file was created
UPLOAD_DATE	DATE			Timestamp when the file was uploaded
IDENTIFIER_TYPE	VARCHAR2	(30)		Region level identifier for the data that was downloaded, E.g. 'CITYSTATE', 'ZIP'
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 DOWNLOAD_FILE_ID
,      FILE_NAME
,      DOWNLOAD_FILE_EXTENSION
,      TEMPLATE_ID
,      UPLOAD_ID
,      DOWNLOAD_DATE
,      UPLOAD_DATE
,      IDENTIFIER_TYPE
,      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_DOWNLOAD_FILES;

Dependencies

[top of page]

FTE.FTE_MILE_DOWNLOAD_FILES does not reference any database object

FTE.FTE_MILE_DOWNLOAD_FILES is referenced by following:

APPS: FTE_MILE_DOWNLOAD_FILES