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 |