[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
FTE.FTE_MESSAGE_LOCATION does not reference any database object
FTE.FTE_MESSAGE_LOCATION is referenced by following:
|
|
|