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

TABLE: IGS.IGS_RU_NAMED_RULE

Object Details
Object Name: IGS_RU_NAMED_RULE
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_RU_NAMED_RULE
Subobject Name:
Status: VALID


IGS_RU_NAMED_RULE named rules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_RU_NAMED_RULE_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUL_SEQUENCE_NUMBER
IGS_RU_NAMED_RULE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUD_SEQUENCE_NUMBER
IGS_RU_NAMED_RULE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMESSAGE_RULE
IGS_RU_NAMED_RULE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUG_SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
RUL_SEQUENCE_NUMBER NUMBER (6) Yes Rule sequence number
RUD_SEQUENCE_NUMBER NUMBER (6) Yes Rule description number
MESSAGE_RULE NUMBER (6)
Contains the optional message rule number
RUG_SEQUENCE_NUMBER NUMBER (6)
Determines the rule group for this rule
RULE_TEXT VARCHAR2 (2000) Yes Rule text
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT RUL_SEQUENCE_NUMBER
,      RUD_SEQUENCE_NUMBER
,      MESSAGE_RULE
,      RUG_SEQUENCE_NUMBER
,      RULE_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_RU_NAMED_RULE;

Dependencies

[top of page]

IGS.IGS_RU_NAMED_RULE does not reference any database object

IGS.IGS_RU_NAMED_RULE is referenced by following:

SchemaAPPS
SynonymIGS_RU_NAMED_RULE