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_MESSAGE_LOCATION

Object Details

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

Stores all the locations mentioned in a shipstatus message

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_MESSAGE_LOCATION_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
FTE_MESSAGE_LOCATION_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary Key
DESCRIPTION	VARCHAR2	(60)		Description
GEOCOORDINATES	VARCHAR2	(60)		Geocoordinates
GEOCOORDINATES_TYPE	VARCHAR2	(60)		Geocoordinates Type
LOCATION_ID	VARCHAR2	(60)		Location Id
LOCATION_ID_TYPE	VARCHAR2	(60)		Location ID Type
SITELEVEL1	VARCHAR2	(30)		Site Level
SITELEVEL2	VARCHAR2	(30)		Site Level
SITELEVEL3	VARCHAR2	(30)		Site Level
SITELEVEL4	VARCHAR2	(30)		Site Level
SITELEVEL5	VARCHAR2	(30)		Site Level
SITELEVEL6	VARCHAR2	(30)		Site Level
SITELEVEL7	VARCHAR2	(30)		Site Level
SITELEVEL8	VARCHAR2	(30)		Site Level
SITELEVEL9	VARCHAR2	(30)		Site Level
ADDRESS_ID	NUMBER			Address ID FK to Address table
CREATED_BY	NUMBER			Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER			Last Updated By
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
TRANSACTION_ID	NUMBER			FK to Transaction ID on headers table
LOCATION_TO_TABLE	VARCHAR2	(30)		Which table does this location belong to?
LOCATION_TO_ID	NUMBER		Yes	The PK of the record on the table this location belongs to

Query Text

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


SELECT ID
,      DESCRIPTION
,      GEOCOORDINATES
,      GEOCOORDINATES_TYPE
,      LOCATION_ID
,      LOCATION_ID_TYPE
,      SITELEVEL1
,      SITELEVEL2
,      SITELEVEL3
,      SITELEVEL4
,      SITELEVEL5
,      SITELEVEL6
,      SITELEVEL7
,      SITELEVEL8
,      SITELEVEL9
,      ADDRESS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANSACTION_ID
,      LOCATION_TO_TABLE
,      LOCATION_TO_ID
FROM FTE.FTE_MESSAGE_LOCATION;

Dependencies

[top of page]

FTE.FTE_MESSAGE_LOCATION does not reference any database object

FTE.FTE_MESSAGE_LOCATION is referenced by following:

FTE: FTE_MESSAGE_LOCATION#