This Global Temp Table is used in different triggers to populate the ZCA_OBJECT_EXT_SHARE table.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| OBJECT_SHARE_REASON_ID | NUMBER | 18 | This stores the reason id for the share record | |
| OBJECT_SHARE_ID | NUMBER | 18 | This stores the share id of the shared record | |
| OBJECT_ID | NUMBER | 18 | This column stores the OBJECT_ID va lue | |
| RULE_GUID | VARCHAR2 | 64 | This stores the rule id that created the share record | |
| ACCESS_GROUP_ID | NUMBER | 18 | This stores the access group id that created the share record | |
| RELATIONSHIP_DN_ID | NUMBER | 18 | This is the relationship identifier due to which the related share rcord got created | |
| RELATIONSHIP_ID | NUMBER | 18 | This is the relationship identifier of the related share | |
| TARGET_OBJECT_ID | NUMBER | 18 | This is the record identifier of the target object | |
| TARGET_OBJECT_NUMBER | VARCHAR2 | 300 | PUID of the target object record. | |
| ACC_EXT_RULE_DN_ID | NUMBER | 18 | Denormalised rule record identifier | |
| ACCESS_LEVEL_CODE | VARCHAR2 | 30 | Access level enabled for a record | |
| DML_OPERATION | VARCHAR2 | 30 | The DML operation performed on this record. |