Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
Name |
---|
OBJECT_ID ACCESS_GROUP_ID OBJECT_TYPE ACCESS_LEVEL_CODE OBJECT_NUMBER ACCESS_GROUP_NUMBER |
Query
SQL_Statement |
---|
SELECT OBJECT_ID,ACCESS_GROUP_ID,OBJECT_TYPE,ACCESS_LEVEL_CODE,OBJECT_NUMBER,ACCESS_GROUP_NUMBER FROM ZCA_OBJECT_SHARE WHERE 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 S.OBJECT_ID,G.ACCESS_GROUP_ID,S.OBJECT_TYPE,S.ACCESS_LEVEL_CODE,S.OBJECT_NUMBER,G.ACCESS_GROUP_NUMBER FROM ZCA_OBJECT_SHARE S , ZCA_ACCESS_GROUP_MEMBERS GM ,ZCA_ACCESS_GROUPS G WHERE 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' |