Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
| Name |
|---|
|
OBJECT_ID OBJECT_NUMBER ASSIGNMENT_RULE_GROUP_ID OBJECT_TYPE |
Query
| SQL_Statement |
|---|
|
SELECT S.OBJECT_ID,S.OBJECT_NUMBER,SR.ASSIGNMENT_RULE_GROUP_ID,SR.OBJECT_TYPE FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S WHERE S.OBJECT_TYPE=SR.OBJECT_TYPE AND S.OBJECT_SHARE_ID=SR.OBJECT_SHARE_ID UNION ALL SELECT S.OBJECT_ID,S.OBJECT_NUMBER,AER.SRC_OBJ_ACCESS_GROUP_ID,SR.OBJECT_TYPE FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S, ZCA_AG_ACC_EXT_RULE_DN AER WHERE S.OBJECT_TYPE=SR.OBJECT_TYPE AND S.OBJECT_SHARE_ID=SR.OBJECT_SHARE_ID AND SR.SRC_ACC_EXT_RULE_DN_ID=AER.ACC_EXT_RULE_DN_ID |