DBA Data[Home] [Help] [Dependency Information]

TABLE: FTE.FTE_MILE_TEMPLATES

Object Details
Object Name: FTE_MILE_TEMPLATES
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_MILE_TEMPLATES
Subobject Name:
Status: VALID


This table is used to store the template header information that is used to format the file for download and read the upload file for loading the file data into the database.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_MILE_TEMPLATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Yes Primary key for the table - system generated
NAME VARCHAR2 (30) Yes User defined name of the template. This must be unique
DESCRIPTION VARCHAR2 (240)
User defined description of the template
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 TEMPLATE_ID
,      NAME
,      DESCRIPTION
,      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_TEMPLATES;

Dependencies

[top of page]

FTE.FTE_MILE_TEMPLATES does not reference any database object

FTE.FTE_MILE_TEMPLATES is referenced by following:

SchemaFTE
ViewFTE_MILE_TEMPLATES#