[Home] [Help] [Dependency Information]
Object Name: | FTE_MESSAGE_LOCATION# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
DESCRIPTION | VARCHAR2 | (60) | ||
GEOCOORDINATES | VARCHAR2 | (60) | ||
GEOCOORDINATES_TYPE | VARCHAR2 | (60) | ||
LOCATION_ID | VARCHAR2 | (60) | ||
LOCATION_ID_TYPE | VARCHAR2 | (60) | ||
SITELEVEL1 | VARCHAR2 | (30) | ||
SITELEVEL2 | VARCHAR2 | (30) | ||
SITELEVEL3 | VARCHAR2 | (30) | ||
SITELEVEL4 | VARCHAR2 | (30) | ||
SITELEVEL5 | VARCHAR2 | (30) | ||
SITELEVEL6 | VARCHAR2 | (30) | ||
SITELEVEL7 | VARCHAR2 | (30) | ||
SITELEVEL8 | VARCHAR2 | (30) | ||
SITELEVEL9 | VARCHAR2 | (30) | ||
ADDRESS_ID | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
LOCATION_TO_TABLE | VARCHAR2 | (30) | ||
LOCATION_TO_ID | NUMBER | Yes |
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#;
|
|
|