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]

VIEW: CSF.CSF_TDS_ROUTE_TO_BE_CALCULATE#

Object Details

Object Name:	CSF_TDS_ROUTE_TO_BE_CALCULATE#
Object Type:	VIEW
Owner:	CSF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SEGMENT_ID_FROM	NUMBER		Yes
SIDE_FROM	VARCHAR2	(1)	Yes
SPOT_FROM	VARCHAR2	(3)	Yes
SRID_FROM	NUMBER
LATITUDE_FROM	NUMBER
LONGITUDE_FROM	NUMBER
SEGMENT_ID_TO	NUMBER		Yes
SIDE_TO	VARCHAR2	(1)	Yes
SPOT_TO	VARCHAR2	(3)	Yes
SRID_TO	NUMBER
LATITUDE_TO	NUMBER
LONGITUDE_TO	NUMBER
USER_ID	NUMBER		Yes
FROM_TILE_ID	NUMBER		Yes
TO_TILE_ID	NUMBER		Yes
DATASET_NAME	VARCHAR2	(10)
FROM_HR_CTRY_CODE	VARCHAR2	(10)
TO_HR_CTRY_CODE	VARCHAR2	(10)

Query Text

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


SELECT SEGMENT_ID_FROM
,      SIDE_FROM
,      SPOT_FROM
,      SRID_FROM
,      LATITUDE_FROM
,      LONGITUDE_FROM
,      SEGMENT_ID_TO
,      SIDE_TO
,      SPOT_TO
,      SRID_TO
,      LATITUDE_TO
,      LONGITUDE_TO
,      USER_ID
,      FROM_TILE_ID
,      TO_TILE_ID
,      DATASET_NAME
,      FROM_HR_CTRY_CODE
,      TO_HR_CTRY_CODE
FROM CSF.CSF_TDS_ROUTE_TO_BE_CALCULATE#;

Dependencies

[top of page]

CSF.CSF_TDS_ROUTE_TO_BE_CALCULATE# references the following:

CSF: CSF_TDS_ROUTE_TO_BE_CALCULATED

CSF.CSF_TDS_ROUTE_TO_BE_CALCULATE# is referenced by following:

APPS: CSF_TDS_ROUTE_TO_BE_CALCULATED