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_LOCATION_MILEAGES

Object Details

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

This table is used to store the distance and transit times between two locations (origin and destination), where the locations are identified as regions. The primary key for the table is origin_id - destination_id.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORIGIN_ID	NUMBER		Yes	identifier for the origin region
DESTINATION_ID	NUMBER		Yes	Identifier for the destination region
IDENTIFIER_TYPE	VARCHAR2	(30)	Yes	Determines the region level that the distance between the origin and destination is at. Derived from a site level profile option. Values are 'ZIP' and 'CITYSTATE'
DISTANCE	NUMBER			Distance between the origin and destination
DISTANCE_UOM	VARCHAR2	(3)		Unit of measure for the distance, e.g. Miles or kilometers
TRANSIT_TIME	NUMBER			Time to travel between the origin and destination
TRANSIT_TIME_UOM	VARCHAR2	(3)		Unit of measure for the transit time, e.g. Minutes, Hours
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 ORIGIN_ID
,      DESTINATION_ID
,      IDENTIFIER_TYPE
,      DISTANCE
,      DISTANCE_UOM
,      TRANSIT_TIME
,      TRANSIT_TIME_UOM
,      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_LOCATION_MILEAGES;

Dependencies

[top of page]

FTE.FTE_LOCATION_MILEAGES does not reference any database object

FTE.FTE_LOCATION_MILEAGES is referenced by following:

APPS: FTE_LOCATION_MILEAGES