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_MD_RD_SEGS_WM#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROAD_SEGMENT_ID	NUMBER	(30)	Yes
FUNCTIONAL_CLASS	NUMBER		Yes
CONSTRUCTION_STATUS	NUMBER
FORM_OF_WAY	NUMBER
SPEED_CATEGORY	NUMBER
LANE_CATEGORY	NUMBER
ONEWAY_DIRECTION	NUMBER		Yes
TOLL_ROAD	VARCHAR2	(3)	Yes
PAVED	VARCHAR2	(3)
FEATURE_CODE	NUMBER		Yes
FERRY_TYPE	VARCHAR2	(240)
ACCESS_CAR	VARCHAR2	(3)	Yes
ACCESS_CARPOOL	VARCHAR2	(3)	Yes
ACCESS_DELIVERY	VARCHAR2	(3)	Yes
ACCESS_TAXI	VARCHAR2	(3)	Yes
ACCESS_PEDESTRIAN	VARCHAR2	(3)	Yes
ACCESS_BUS	VARCHAR2	(3)	Yes
ACCESS_BICYCLE	VARCHAR2	(3)	Yes
ACCESS_EMERGENCY	VARCHAR2	(3)	Yes
ACCESS_TRUCK	VARCHAR2	(3)	Yes
INST_STYLE_ID	NUMBER	(30)	Yes
SECURITY_GROUP_ID	NUMBER
GEOMETRY	SDO_GEOMETRY	(64)

Query Text

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


SELECT ROAD_SEGMENT_ID
,      FUNCTIONAL_CLASS
,      CONSTRUCTION_STATUS
,      FORM_OF_WAY
,      SPEED_CATEGORY
,      LANE_CATEGORY
,      ONEWAY_DIRECTION
,      TOLL_ROAD
,      PAVED
,      FEATURE_CODE
,      FERRY_TYPE
,      ACCESS_CAR
,      ACCESS_CARPOOL
,      ACCESS_DELIVERY
,      ACCESS_TAXI
,      ACCESS_PEDESTRIAN
,      ACCESS_BUS
,      ACCESS_BICYCLE
,      ACCESS_EMERGENCY
,      ACCESS_TRUCK
,      INST_STYLE_ID
,      SECURITY_GROUP_ID
,      GEOMETRY
FROM CSF.CSF_MD_RD_SEGS_WM#;

Dependencies

[top of page]

CSF.CSF_MD_RD_SEGS_WM# references the following:

CSF: CSF_MD_RD_SEGS_WM
MDSYS: SDO_GEOMETRY
SYS: STANDARD - show dependent code

CSF.CSF_MD_RD_SEGS_WM# is referenced by following:

APPS: CSF_MD_RD_SEGS_WM