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]

TABLE: CSF.CSF_TDS_COND_SEGS

Object Details

Object Name:	CSF_TDS_COND_SEGS
Object Type:	TABLE
Owner:	CSF
FND Design Data:	CSF.CSF_TDS_COND_SEGS
Subobject Name:
Status:	VALID

DEFINITION
Intersection table required since one segment can be part of multiple conditions and one condition can be composed of multiple segments.
EXAMPLE
MISCELLANEOUS
The sequence number in the Condition Segment table defines where in the condition the segment occurs.

Storage Details

Tablespace:	APPS_TS_MEDIA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_SEGMENT_ID	NUMBER	(30)	Yes	Unique identifier for the Condition Segment Table
SEQUENCE_NUMBER	NUMBER	(4)	Yes	Defines sequence of Segment in Condition
CONDITION_ID	NUMBER	(30)	Yes	Unique identifier for Condition Table
SEGMENT_ID	NUMBER	(30)	Yes	Unique identifier for Segment Table
JUNC_NODE_FLAG	VARCHAR2	(3)		Indicates that condition segment is part of a junction.
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 CONDITION_SEGMENT_ID
,      SEQUENCE_NUMBER
,      CONDITION_ID
,      SEGMENT_ID
,      JUNC_NODE_FLAG
,      SECURITY_GROUP_ID
FROM CSF.CSF_TDS_COND_SEGS;

Dependencies

[top of page]

CSF.CSF_TDS_COND_SEGS does not reference any database object

CSF.CSF_TDS_COND_SEGS is referenced by following:

APPS: CSF_TDS_COND_SEGS