ZCA_ACCESS_GROUP_MEMBERS_VIEW
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZCA
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PARTY_ID TYPE_CODE ACCESS_GROUP_ID |
問合せ
| 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' |