ZCA_AG_OBJECTS_GT
This Global Temp Table for a session. It stores the records to be processed for hybrid/system rules
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | 18 | This column stores the OBJECT_ID value | |
OBJECT_NUMBER | VARCHAR2 | 300 | This stores Object Number of the record. | |
ASSIGNMENT_RULE_GUID | VARCHAR2 | 64 | ASSIGNMENT_RULE_GUID. This is placeholder of the rule | |
OBJECT_INDEX | NUMBER | 10 | This is the index for an object which is unique in a rule. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
ZCA_AG_OBJECTS_GT_N1 | Non Unique | ASSIGNMENT_RULE_GUID, OBJECT_INDEX |