ZCA_AG_RESOURCE

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
ACCESS_GROUP_ID ACCESS_GROUP_TYPE_CODE ACCESS_GROUP_NUMBER CONDITION_CODE ACCESS_LEVEL_CODE RULE_GUID RESOURCE_ID RULE_GROUP_ID

Name

ACCESS_GROUP_ID

ACCESS_GROUP_TYPE_CODE

ACCESS_GROUP_NUMBER

CONDITION_CODE

ACCESS_LEVEL_CODE

RULE_GUID

RESOURCE_ID

RULE_GROUP_ID

Query

SQL_Statement
SELECT G.ACCESS_GROUP_ID,G.TYPE_CODE AS ACCESS_GROUP_TYPE_CODE,G.ACCESS_GROUP_NUMBER,R.CONDITION_CODE ,RC.CAND_OBJ_ADDL_INFO1 AS ACCESS_LEVEL_CODE,R.RULE_GUID, M.PARTY_ID AS RESOURCE_ID,M.ACCESS_GROUP_ID AS RULE_GROUP_ID FROM ZCA_ACCESS_GROUPS G, MOW_RULES R, MOW_RULE_CANDIDATES RC, ZCA_ACCESS_GROUP_MEMBERS M WHERE G.TYPE_CODE = 'ORA_ZCA_RESOURCE' AND R.RECORD_STATUS = 'P' AND R.INACTIVE_FLAG = 'N' AND R.RULE_GUID = RC.RULE_GUID AND RC.INACTIVE_FLAG = 'N' AND TO_NUMBER(RC.CAND_OBJ_PUBLIC_IDENTIFIER)=M.ACCESS_GROUP_ID AND M.PARTY_ID=G.SOURCE_ID1 AND M.ACTIVE_FLAG='Y'

SQL_Statement

SELECT G.ACCESS_GROUP_ID,G.TYPE_CODE AS ACCESS_GROUP_TYPE_CODE,G.ACCESS_GROUP_NUMBER,R.CONDITION_CODE ,RC.CAND_OBJ_ADDL_INFO1 AS ACCESS_LEVEL_CODE,R.RULE_GUID, M.PARTY_ID AS RESOURCE_ID,M.ACCESS_GROUP_ID AS RULE_GROUP_ID

FROM ZCA_ACCESS_GROUPS G, MOW_RULES R, MOW_RULE_CANDIDATES RC, ZCA_ACCESS_GROUP_MEMBERS M

WHERE

G.TYPE_CODE = 'ORA_ZCA_RESOURCE'

AND R.RECORD_STATUS = 'P' AND R.INACTIVE_FLAG = 'N'

AND R.RULE_GUID = RC.RULE_GUID AND RC.INACTIVE_FLAG = 'N'

AND TO_NUMBER(RC.CAND_OBJ_PUBLIC_IDENTIFIER)=M.ACCESS_GROUP_ID

AND M.PARTY_ID=G.SOURCE_ID1

AND M.ACTIVE_FLAG='Y'