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 V.OBJECT_SHARE_REASON_ID, V.OBJECT_ID, V.OBJECT_NUMBER, V.ASSIGNMENT_RULE_GROUP_ID, V.OBJECT_TYPE, V.ACCESS_GROUP_ID FROM ZCA_SHARE_REASON_ELASTIC_VIEW V WHERE EXISTS ( select 1 from fusion.svc_field_group_permissions fgp, fusion.svc_field_groups fg where fgp.access_group_id = V.assignment_rule_group_id and fgp.published_flag = 'Y' and fgp.field_group_id = fg.field_group_id and fg.object_type = V.OBJECT_TYPE ) |