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

TABLE: RRS.RRS_GROUP_RULES

Object Details
Object Name: RRS_GROUP_RULES
Object Type: TABLE
Owner: RRS
Subobject Name:
Status: VALID


This table stores the rules for grouping the nodes or sites in Hierarchy. If a rule exists in this table, then user can create the hierarchy as per these rules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SITE_GROUP_TYPE_CODE VARCHAR2 (1) Yes H for Hierarchy.
GROUP_PURPOSE_CODE VARCHAR2 (30) Yes Hierarchy Purpose code
RELATIONSHIP_TYPE VARCHAR2 (30)
Relationship should be 'PARENT_CHILD'
OBJECT1 VARCHAR2 (30) Yes First object in relationship rule i.e. 'SITE' or 'NODE'
CLASSIFICATION_CODE1 VARCHAR2 (30) Yes Classification code should be either Node or Site Purpose
OBJECT2 VARCHAR2 (30)
Second object in relationship rule i.e 'SITE' or 'NODE'
CLASSIFICATION_CODE2 VARCHAR2 (30)
Classification code should be either Node or Site Purpose
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
Query Text

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


SELECT SITE_GROUP_TYPE_CODE
,      GROUP_PURPOSE_CODE
,      RELATIONSHIP_TYPE
,      OBJECT1
,      CLASSIFICATION_CODE1
,      OBJECT2
,      CLASSIFICATION_CODE2
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM RRS.RRS_GROUP_RULES;

Dependencies

[top of page]

RRS.RRS_GROUP_RULES does not reference any database object

RRS.RRS_GROUP_RULES is referenced by following:

SchemaRRS
ViewRRS_GROUP_RULES#