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

TABLE: CSF.CSF_TDS_COND_SEGS_AU

Object Details
Object Name: CSF_TDS_COND_SEGS_AU
Object Type: TABLE
Owner: CSF
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: TablespaceAPPS_TS_TX_DATA
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_AU;

Dependencies

[top of page]

CSF.CSF_TDS_COND_SEGS_AU does not reference any database object

CSF.CSF_TDS_COND_SEGS_AU is referenced by following:

SchemaAPPS
SynonymCSF_TDS_COND_SEGS_AU