Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
| Name |
|---|
|
OBJECT_SHARE_REASON_ID OBJECT_ID OBJECT_NUMBER ASSIGNMENT_RULE_GROUP_ID OBJECT_TYPE ACCESS_GROUP_ID |
Query
| SQL_Statement |
|---|
|
SELECT SR.OBJECT_SHARE_REASON_ID OBJECT_SHARE_REASON_ID, S.OBJECT_ID OBJECT_ID, S.OBJECT_NUMBER OBJECT_NUMBER, SR.ASSIGNMENT_RULE_GROUP_ID ASSIGNMENT_RULE_GROUP_ID, SR.OBJECT_TYPE OBJECT_TYPE, S.ACCESS_GROUP_ID ACCESS_GROUP_ID 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 AND SR.ASSIGNMENT_RULE_GROUP_ID IS NOT NULL AND S.ACCESS_GROUP_TYPE_CODE NOT IN ( 'ORA_ZCA_RESOURCE_ANCESTORS', 'ORA_ZCA_TERRITORY_ANCESTORS', 'ORA_ZCA_PARTNER_ANCESTORS', 'ORA_ZCA_QUEUE_ANCESTORS', 'ORA_ZCA_TERR_ADMIN_ANCESTORS', 'ORA_ZCA_TERR_DELEG_ANCESTORS', 'ORA_ZCA_TERR_OWNER_ANCESTORS' ) UNION ALL SELECT SR.OBJECT_SHARE_REASON_ID OBJECT_SHARE_REASON_ID, S.OBJECT_ID OBJECT_ID, S.OBJECT_NUMBER OBJECT_NUMBER, SR.ASSIGNMENT_RULE_GROUP_ID ASSIGNMENT_RULE_GROUP_ID, SR.OBJECT_TYPE OBJECT_TYPE, G.ACCESS_GROUP_ID ACCESS_GROUP_ID FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S, ZCA_ACCESS_GROUP_MEMBERS GM, ZCA_ACCESS_GROUPS G WHERE S.OBJECT_TYPE = SR.OBJECT_TYPE AND S.OBJECT_SHARE_ID = SR.OBJECT_SHARE_ID AND SR.ASSIGNMENT_RULE_GROUP_ID IS NOT NULL AND S.ACCESS_GROUP_TYPE_CODE IN ( 'ORA_ZCA_RESOURCE_ANCESTORS', 'ORA_ZCA_TERRITORY_ANCESTORS', 'ORA_ZCA_PARTNER_ANCESTORS', 'ORA_ZCA_QUEUE_ANCESTORS', 'ORA_ZCA_TERR_ADMIN_ANCESTORS', 'ORA_ZCA_TERR_DELEG_ANCESTORS', 'ORA_ZCA_TERR_OWNER_ANCESTORS' ) AND S.ACCESS_GROUP_ID = GM.ACCESS_GROUP_ID AND GM.PARTY_ID = G.SOURCE_ID1 AND G.TYPE_CODE = 'ORA_ZCA_RESOURCE' UNION ALL SELECT SR.OBJECT_SHARE_REASON_ID OBJECT_SHARE_REASON_ID, S.OBJECT_ID OBJECT_ID, S.OBJECT_NUMBER OBJECT_NUMBER, AER.SRC_OBJ_ACCESS_GROUP_ID ASSIGNMENT_RULE_GROUP_ID, SR.OBJECT_TYPE OBJECT_TYPE, S.ACCESS_GROUP_ID ACCESS_GROUP_ID 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 AND SR.ASSIGNMENT_RULE_GROUP_ID IS NULL AND S.ACCESS_GROUP_TYPE_CODE NOT IN ( 'ORA_ZCA_RESOURCE_ANCESTORS', 'ORA_ZCA_TERRITORY_ANCESTORS', 'ORA_ZCA_PARTNER_ANCESTORS', 'ORA_ZCA_QUEUE_ANCESTORS', 'ORA_ZCA_TERR_ADMIN_ANCESTORS', 'ORA_ZCA_TERR_DELEG_ANCESTORS', 'ORA_ZCA_TERR_OWNER_ANCESTORS' ) UNION ALL SELECT SR.OBJECT_SHARE_REASON_ID OBJECT_SHARE_REASON_ID, S.OBJECT_ID OBJECT_ID, S.OBJECT_NUMBER OBJECT_NUMBER, AER.SRC_OBJ_ACCESS_GROUP_ID ASSIGNMENT_RULE_GROUP_ID, SR.OBJECT_TYPE OBJECT_TYPE, G.ACCESS_GROUP_ID ACCESS_GROUP_ID FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S, ZCA_AG_ACC_EXT_RULE_DN AER, ZCA_ACCESS_GROUP_MEMBERS GM, ZCA_ACCESS_GROUPS G 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 AND SR.ASSIGNMENT_RULE_GROUP_ID IS NULL AND S.ACCESS_GROUP_TYPE_CODE IN ( 'ORA_ZCA_RESOURCE_ANCESTORS', 'ORA_ZCA_TERRITORY_ANCESTORS', 'ORA_ZCA_PARTNER_ANCESTORS', 'ORA_ZCA_QUEUE_ANCESTORS', 'ORA_ZCA_TERR_ADMIN_ANCESTORS', 'ORA_ZCA_TERR_DELEG_ANCESTORS', 'ORA_ZCA_TERR_OWNER_ANCESTORS' ) AND S.ACCESS_GROUP_ID = GM.ACCESS_GROUP_ID AND GM.PARTY_ID = G.SOURCE_ID1 AND G.TYPE_CODE = 'ORA_ZCA_RESOURCE' |