ZCA_ACCESS_GROUP_MEMBERS_VIEW

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
PARTY_ID TYPE_CODE ACCESS_GROUP_ID

Query

SQL_Statement
SELECT GROUP_MEMBERS.PARTY_ID AS PARTY_ID, 'CUSTOM' AS TYPE_CODE, GROUP_MEMBERS.ACCESS_GROUP_ID AS ACCESS_GROUP_ID FROM zca_access_group_members GROUP_MEMBERS WHERE GROUP_MEMBERS.ACTIVE_FLAG='Y'