DBA Data[Home] [Help] [Dependency Information]


TABLE: CSF.CSF_MD_RDSEG_NM_ASGNS_EU

Object Details
Object Name: CSF_MD_RDSEG_NM_ASGNS_EU
Object Type: TABLE
Owner: CSF
Subobject Name:
Status: VALID


DEFINITION
A MD RDSEG NAME ASGN defines the M:M relationship between the MD NAME and MD ROAD SEGMENT entity.
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RD_SEG_NM_ID NUMBER (30) Yes Generic unique identifier for an entity
NAME_TYPE VARCHAR2 (1) Yes The NAME TYPE defines the type of the name given to the road segment.
ROAD_SEGMENT_ID NUMBER (30) Yes The ROAD SEGMENT ID defines the unique identifier for a road segment.
NAME_ID NUMBER (30) Yes The NAME ID defines the unique identifier of the name.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
Query Text

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


SELECT RD_SEG_NM_ID
,      NAME_TYPE
,      ROAD_SEGMENT_ID
,      NAME_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_MD_RDSEG_NM_ASGNS_EU;

Dependencies

[top of page]

CSF.CSF_MD_RDSEG_NM_ASGNS_EU does not reference any database object

CSF.CSF_MD_RDSEG_NM_ASGNS_EU is referenced by following:

SchemaAPPS
SynonymCSF_MD_RDSEG_NM_ASGNS_EU